Power BI doesn’t yet have a feature that allows end-users to turn on/off the ability to process calculations for visuals on a report page until they are ready. Most of the time, this is perfectly fine – however, in some instances, it can be handy to disable long-running and heavy calculations from running. At the… READ MORE
SharePoint and Power BI can work very well together. SharePoint can be a data source (lists), a container for data files (Excel. CSV etc in libraries), and as a dashboarding platform (pages). This demo rich session will explore all of these scenarios in great depth. SharePoint data can be finicky to retrieve, and this session… READ MORE
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
Recently I have been working where I have multiple accounts, and I wanted to test the different access to the accounts when connecting via Excel. Today we will discuss Changing the User Account in Excel when connecting to Power BI Premium/Per User or Azure Analysis Services. I could not find any blog posts or videos… READ MORE
I have been playing around with the new awesome (preview) feature in the December Power BI Desktop release where we can use DirectQuery for Power BI datasets and Azure Analysis services (link to blogpost) In my case I combined data from a Power BI dataset, Azure Analysis Services, and a local Excel sheet. The DirectQuery… 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
Once upon a time, your old scary DBA walked into your office with a red-colored face and asked you furiously: “What the hell you’ve done with your Power BI report?! It killed all of our workloads!!!” You knew why he was angry, even before he started screaming at you. It’s because of “that” report which… READ MORE
Note: To watch this webinar you must login to your ESPC Community Account by clicking the blue banner above the video. If you do not have an account, you can sign up here. Implementing Power BI in your organisation is more then allowing people to download Power BI desktop and publish reports to the Power… READ MORE
“Learning is a process, a method, an area of mastery, and with effort, focus, and practice, we can get a lot better at gaining expertise.” – Ulrich Boser Analyzing Data with Microsoft Power BI Exam Today I am going to speak to you about Exam DA-100: Analyzing Data with Microsoft Power BI. I will talk… 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
