Migrating data sources at times can be tricky in Power BI. This article focuses on how to change the data source from an Excel table to a SQL table in minimum possible steps, considering the following scenarios: The name and structure of the data source tables are different in Excel and SQL. It includes a… READ MORE
Most dataflows needs to have scheduled refresh setup so that the data will be up to date ready for the reports connecting to it. This post walks through the basic steps to set up the refresh. Dataflow Series This post is part of a series on dataflows. Create a dataflow Set up dataflow refresh Endorsement… READ MORE
With Power BI you can set up a scheduled refresh of any dataset which have an accessible data source. But you must be aware of, how many refreshes are at the same time. With every particular capacity you have only limited parallel refreshing resources. So, you can only refresh one dataset at the same time… READ MORE
I have created two new PowerShell functions for Granting or Revoking permission on items in the Power BI Report Catalog. These two will be the probably be the last two functions I create for Power BI Report Server for a little while. I’ll be working on SSAS cmdlets for the next week or two. RECAP… READ MORE
After Installing the PowerShell Power BI Management cmdlets a few months back, I finally managed to get a dataset refresh working, initiated from PowerShell with a Service Principal. Yeej 
But as you can imagine, it didn’t go without a fight (or 2, or maybe more), so I thought it would probably be good to share my… READ MORE
Microsoft PowerPivot is a free add-on to Excel from Microsoft that allows users to produce new kinds of reports and analyses that were simply impossible before, and this book is the first to tackle DAX formulas, the core capability of PowerPivot, from the perspective of the Excel audience. Download 2 Chapters: 8 – CALCULATE() –… READ MORE
When your report has a bunch of slicers and charts that can also add filters to the page resetting back to no filters can be painful. So we need a quick way to reset slicers. This post walks through the steps of creating a bookmark and the using that bookmark to reset the page by… READ MORE
Analyse your company’s data quickly and easily using Microsoft’s latest tools. You will learn to build scalable and robust data models to work from, clean and combine different data sources effectively, and create compelling visualisations and share them with your colleagues. This excerpt ‘Data Munging with Power Query’ from the book Beginning Power BI by Dan Clark… READ MORE
Notifications