In modern BI projects, understanding the flow of data from the data source to its destination, and understanding the data transformation done along the way, is a key challenge for many customers. This challenge becomes even bigger if you have built advanced analytical projects spanning multiple data sources, artifacts, and dependencies. Questions like “What happens …
This post was contributed by Ken Puls and Miguel Escobar, Power BI experts and authors of the new ebook, “[M]agic Tricks for Data Wizards”. Have you ever wanted to consolidate, combine or append data from multiple excel spreadsheets or workbooks? I bet you have, and it has been a painful process either done manually or via …
Combining Excel Files Hosted On SharePoint Folder With Power BI Read More »
Custom visuals have become a key part of Power BI allowing users to tap into hundreds of different visualizations. It is hard to believe that a little over two years ago we announced the availability of the first batch of custom visuals in Power BI Desktop and the Power BI Service. But custom visuals go far beyond …
Excel Announces New Data Visualization Capabilities With Power BI Custom Visuals Read More »
Bringing more AI to Power BI The February 2019 release of Power BI Desktop unveiled a new, out-of-the-box visual to Power BI called Key Influencers. Key Influencers is Power BI’s first Artificial Intelligence (AI) powered visualization. Microsoft has long incorporated AI capabilities in Power BI through features such as Natural Language (Q&A) and Quick Insights. However, with Key Influencers report developers …
This post will walk through the first report in BlueGranite’s Power BI showcase – a series designed to highlight key capabilities and tools within the Power BI platform using real and reproducible methods – and introduce the data and features used to create it. The “Employee Retention – Organizational Flight Risk” report displays the results of a …
Power BI Showcase: Employee Retention – Organization Flight Risk Read More »
Working out how long a Power Query M query takes to run – the first step to troubleshooting refresh performance problems in Power BI or Excel – is something I have blogged about several times (see here, here and here for example). However, there are problems with all of these methods such as the need to alter the M code …
A while ago I found myself wondering – as I often do about this kind of thing – about what the undocumented third parameter of the Excel.Workbook() M function (called delayTypes) actually does. I found a forums post from Guy Hunkin of the Excel Power Query team in 2017 here, which gives the following summary: Originally, Excel.Workbook used …
Excel.Workbook() And The delayTypes Option In Power Query/Power BI Read More »
I have already blogged in great detail many times about Power BI/Power Query data privacy settings (see this series for example) but there’s always something new to learn. Recently I was asked a question by Ian Eckert about how Power BI handles data privacy for cloud or web-based data sources after a dataset has been published, and …
Power BI Data Privacy Levels And Cloud /Web-Based Data Sources Or Dataflows Read More »
A few weeks ago I wrote an article introducing dataflows in Power BI and discussed why you should care about them. There are a few questions that have been spinning around in my head since then, significantly: What implication is there to the Power BI Golden Dataset as a result of the new dataflows? Should I extract my queries …
Moving Queries From Power BI Desktop To Dataflows Read More »
Microsoft recently released a new feature in Power BI called “Dataflows”. You may have seen it pop up in a recent release of Power BI Desktop under Home\Get Data\Power BI Dataflows (beta) as shown below. It is also visible when you log into PowerBI.com and go to an App Workspace as shown in 1 below. …
Power BI Dataflows: Why You Should Care? (Videos) Read More »