Update: Brisbane Data Platform User Group

Khilitchandra's Business Intelligence Blog Posted on by

I would like to keep my Technical Community & my online friends updated that – I have moved from Singapore to Australia in year 2023. Hence during the movement, I could not keep up with my blogging. But I am back to community again 🙂

I have established a brand new FaceBook User Group for Australia Data Community. And I am getting very good response which is fueling my enthusiasm even more for community.

Please check-out and join this group if you havent yet. The group is created with vision “

Brisbane Data Platform User Group is for Data professionals and enthusiasts interested in any Data Platform Technologies. Its technology agnostic group, so all Data Platform techies are invited to join and collaborate in this group.”

Link to join: Brisbane Data Platform User Group | Facebook

Stay tuned for latest and greatest news here.

Thank you, Khilit

Interview with BIConsultingPro on Enterprise Data Architecture journey + Sharing of learnings on the way

Khilitchandra's Business Intelligence Blog Posted on by

I had the pleasure of sharing my Enterprise Data Architecture journey and experiences on the @BIConsultingPro channel. If you weren’t able to catch the live event, don’t worry! You can watch the recording at your convenience on YouTube. I hope it provides you with some valuable insights and guidance.

A special thank you to Ajay Kumar for hosting me. It was truly an honor to be a part of your latest Tech Series – “Learn from the Best”.

You can find the recording on YouTube here: https://lnkd.in/g7qpf_pQ
For more content from BI Consulting Pro, visit their YouTube channel here: https://lnkd.in/gCDBRHJi

Cool Tricks in Power BI for Advanced Users

Khilitchandra's Business Intelligence Blog Posted on by

Hi All, Greetings.

It was my great pleasure presenting into “Singapore Data Platform” Event.
Please download Session Slides & Supporting Demo Files from here.

I am very happy to see the enthusiasm and response from everyone. Thank you.
Special thank you to all Organizers (Aroh, Asif & Pio).

Stay tuned for more informative sessions 🙂
Thank you, Khilit

Dashboards in Power BI with Real-time Data – SQL Saturday #818, Malaysia

Khilitchandra's Business Intelligence Blog Posted on by

Had a great time speaking @ SQL Saturday # 818, Microsoft Malaysia.
My slides are here -> Dashboards in Power BI with Real-time Data

Great audience & great speakers 🙂 Big thanks to Organizers, Microsoft & PASS. Nice engaging Tech sessions from Experts – Chiu Kiang Phua, Ian Choy Swee Ho, Hamid J. Fard, Deh Hui Chuan, Patrick Flynn, Jan Rokicki, Ben Weissman, David Alzamendi, Vinod Kumar, Asanka Padmakumara, Jonathan Stewart

Thank you to Singapore PASS Chapter Team.
Khilit

Demystifying DAX in Power BI – Session @ Singapore DataCamp 2019

Khilitchandra's Business Intelligence Blog Posted on by

Hi All,

It was my great pleasure presenting into “Singapore DataCamp 2019” full day event @ Microsoft, Singapore. My slides & Demo PBIXs are here -> Demystifying DAX in Power BI

I was very happy to see the enthusiasm and response of everyone.

A special thank you to all our prestigious speakers – Dinesh Priyankara, Naginder Singh Virdi, Zack Loh, Hitendra Changlani, Sanjiv Venkartram, Hansamali Gamge, Nilesh Gule, Nisal Mihiranga, Nagaraj Venkatesan, Dharmendra Keshari, Fiqri, Kasun Pathirana, Khilitchandra

A BIG thank you to Microsoft, Nagaraj Venkatesan & Pei Shang loh – without their generous support, this event would have not been possible.

Thank you to Singapore PASS Chapter Team.
Khilit

Power BI Web Scraping – Deck from “Data Visualization Day – Power BI” @ Microsoft

Khilitchandra's Business Intelligence Blog Posted on by

Hi All,

It was my great pleasure presenting today into “Data Visualization Day – Power BI” full day event @ Microsoft, Singapore.

My slides & Demo PBIXs are here -> Data Visualization Day 2018-12-22 – Power BI Web Scraping – ZIP

I extremely happy to see the enthusiasm and response of everyone, especially Attendees. Even during this holiday seasons, there were around 120+ ignited minds in session. Event after event & response from communities & people, I can clearly see that “Power BI” is a Rock Star 🙂

A special thank you to Sanjiv Venkatram for encouraging folks in Singapore to be more involved in our communities & igniting the sparks of innovations in community by personal consultations.

A BIG thank you to Microsoft, Nagaraj Venkatesan & Pei Shang loh – without their generous support, this event would have not been possible.

Hats off to all great Speakers – Naginder Singh Virdi, Jenzus HSU, Dharmendra Keshari, Kasun Pathirana, Sanjiv Venkatram

Thank you to Singapore PASS Chapter Team.

Khilit

Power BI MixTape – Web Scraping, Architecture, Custom Functions, Custom Tooltip

Khilitchandra's Business Intelligence Blog Posted on by

Hi All,

It was fun & engaging session on 22nd Nov 2018 @ Singapore PASS Chapter, Microsoft. I presented few mix topics of Power BI e.g. Web Scraping, General architecture, Custom functions, Custom Tool-tip etc.

I am thankful to all energetic folks who came (~7 pm after work) for attending the session – I consider that as great support. That’s what keeps us moving. Cheers 🙂

My slides & demo PBIX are here -> Meetup 2018-11-22 – Power BI MixTape – Web Scraping

Thanks,
Khilit

Power BI Desktop September 2018 Feature Summary

Khilitchandra's Business Intelligence Blog Posted on by

Hello Guys,

Power BI Desktop’s Monthly Feature Summary of September 2018 is out.

Here is the direct links to features:

Reporting

Analytics

Custom visuals

Data connectivity

Data preparation

On a side note – I am very happy that one of my ideas submitted to Power BI Team, already delivered in this release 🙂 Thanks to Chelsie Eiden.

Thanks Power BI Team.
Khilit

Quick Access Toolbar in Power BI Desktop – Get more working space for your productivity

Khilitchandra's Business Intelligence Blog Posted on by

Hi,
Good Saturday to you all 🙂

I would like to share today a very small and quick Tip. This is for all those Users who needs some more space while building Power BI Reports. And at the same time, have their favorite options available in some corner. You can do that in few steps.

1. Launch Power BI Desktop (does not matter whether it’s Power BI Desktop or Power BI Desktop for Report Server). You should see something like this.

2. Right click anywhere on Ribbon -> Select “Show Quick Access Toolbar below the Ribbon”.

3. Then your Quick Access Toolbar is visible. Now, Hide the Ribbon.

4. Add your favorite Tools available in Quick Access Toolbar.

Enjoy more space in Power BI Desktop.
Thanks, Khilit

Power BI Desktops & File Extension (pbix file)

Khilitchandra's Business Intelligence Blog Posted on by

Hi All,

Microsoft Power BI Team is keep on releasing amazing features for Power BI Service as well as Power BI On-Premise version (i.e. Report BI Report Server). And obviously we would like to try them all 🙂

If you notice, Power BI Report files created in bother authoring tools (Power BI Desktop as well as Power BI Desktop for Report Server) have the same file extension (which is understood). But when you double click the pbix file and you want that to open in its correct authoring tool then you need to remember 1 rule before double clicking it.

Simple rule: When the same machine has Power BI Desktop as well as Power BI Desktop for Report Server installed -> Then you need to remember which was the last tool installed on machine. Because it will by default take preference/choice when you open any pbix file directly by double clicking.

What if I don’t remember or keep track of which version of Power BI I have installed last (Because Microsoft is keep releasing new versions every month :)). Well, in that case you can do following in order to avoid confusion:

  1. If you want to work with Power BI Report files which were developed in Power BI Desktop -> then open the Power BI Desktop Tool first and select your file. Simple 🙂

Note: The Power BI Desktop version for the Power BI service doesn’t have the month and year in the title bar.

  1. Same way, to work with Power BI Report files which were developed for Power BI Report Server -> You jump into Web Portal (ideally it looks like: http://machine_name/Reports) -> Click on your Report and Edit in Power BI Desktop. (below screen-shot shows where you can get the Power BI Desktop for Report Server easily)

Find out more details here: https://docs.microsoft.com/en-us/power-bi/report-server/install-powerbi-desktop

Thanks, Khilit