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. I could not find any blog posts or videos on how to do this. In my blog post I detail how to achieve this. Connecting to the dataset using Excel… 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 Today I am going to speak to you about Exam DA-100: Analyzing Data with Microsoft Power BI. I will talk about my experience, how I passed the… 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
In this blog series I will set apart all the steps needed to get this demo up and running on your own. I will use the text in this post, as well as screen shots and video’s explaining it step by step. So if you’re already (somewhat) familiar with Forms, Power Automate and/or Power BI… READ MORE
