Yearly Archives: 2018

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 … Continue reading →

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

Continue reading →

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 Dot plot layout support in scatter charts Copy value and selection from table & matrix Built-in report theme options Report page tooltips generally available & Card support Accessibility improvements for analytics and formatting pane support Analytics Aggregations (preview) Q&A support for RLS Custom visuals Horizon Chart Text Enhancer by MAQ Software Advance Card Multi KPI Custom visual API updates Data connectivity PDF file connector (preview) SAP BW connector – support for measure properties Dataflows connector (beta) Data preparation M … Continue reading →

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 … Continue reading →

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. … Continue reading →

Maintain & Monitor : Power BI Premium Capacities

Khilitchandra's Business Intelligence Blog Posted on by

Hi, Good Saturday to you all. Microsoft Power BI Team has shared a very good news – Now you can maintain and monitor your Premium capacity Power BI resources & Usages. Premium Capacity Monitoring App is now available for us. This app supports capacity in monitoring the health of premium capacities and making sound decisions about the best use of them and when to scale them so that your users get the best possible experience. The app can be installed by searching for “Power BI Premium Capacity Monitoring” in the Power BI apps or click here to get it now … Continue reading →

AZURE DATA WEEK – Azure Data Virtual Conference

Khilitchandra's Business Intelligence Blog Posted on by

Hi All, There an upcoming Virtual Conference setup by Pragmatic Works. Super affordable (29 USD for entire Conference) and interesting. Go for it. When? October 8-12, 2018 Where? Online Need more information? azuredataweek@pragmaticworks.com Highlights of agenda per day: Monday, October 8th -> Power BI – The Exciting Future of Power BI – World-class Power BI Solutions – Accelerating Development with Power BI Embedded and APIs – Digital Storytelling with Power BI – Enterprise Identity and Security in Power BI – Data Security and Management in Power BI – Deploying and Managing Enterprise Power BI – Migrating to Power BI Quickly and … Continue reading →

SQL Saturday #784, Singapore – Great & Memorable Event – Thanks to All :)

Khilitchandra's Business Intelligence Blog Posted on by

Hi All, I am very happy to share that we have successfully completed our yearly major event – SQL Saturday #784, Singapore. On behalf of entire Singapore PASS Chapter, we thank to all our prestigious speakers (Amit R S Bansal, Patrick Flynn, Karen Lopez, Dinesh Priyankara, Sanjiv Venkatram, David Alzamendi, Denny Cherry, Kevin Boles, Manohar Punna, Asanka Padmakumara, Naginder Singh Virdi, Senthamil Selvan, Sarbjit Singh Gill, Jason Aw, Dharmendra Keshari) for delivering great sessions and fill the day with knowledge and fun. Special thanks to PASS and Microsoft for gracious support to make this event great. Thanks to event organizers, … Continue reading →

Power BI Report Server – August 2018 Updates

Khilitchandra's Business Intelligence Blog Posted on by

Hi All, People who are working on Power BI On-Premise, there are more updates for Power BI Report Server. Major features are related look and feel about the Reports/Dashboards. Plus there are few updates on Modelling and Formulas. Browse through below links and check out all examples provided by Microsoft Power BI Blog with examples 🙂 REPORTING Report Theming Buttons to trigger actions Combo chart line styles Improved default sort for visuals Numeric slicer Advanced slicer syncing Log axis improvements Data label options for funnel chart Set line stroke width to zero High contrast support for reports Donut radius control Pie … Continue reading →

Interact with Power BI with PowerShell

Khilitchandra's Business Intelligence Blog Posted on by

Hi All, PowerShell is awesome command-line tool. Microsoft Team has recently released couple of Power BI APIs and PowerShell cmdlets – which will allow you to work with workspaces, dashboards, reports, datasets, and so forth in Power BI. But these cmdlets and APIs are not just limited to Administration purposes but also for other Power BI users. Basically there are 4 general categories of users who can leverage these cmdlets: Power BI administrators, who must work with resources at the Power BI tenant level, such as to enumerate workspaces, dashboards, reports, and datasets, recover orphaned workspaces, or discover the data … Continue reading →