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
“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
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
Occasionally in Power BI, you may want to display day or month names as single letters to save space. This may result in duplicates because neither day nor month names are unique when you shorten them to one letter. In this blog post, I’m showing two solutions to the problem: one in DAX and one… READ MORE
In this article, we will be talking about the new Power BI experience in Microsoft Teams. During Ignite 2020, Microsoft announced that users can now use Power BI Service from teams without leaving the context of Teams. This feature is very useful for modern workspace users where we can use Microsoft Team as a centralized… READ MORE
Hidden gems! Slicer Pain Relief in Power BI! Power BI is full of them…Sometimes, you find them after thorough research, and sometimes they just appear out of nowhere. This post won’t be long – it’s just an homage to Power BI and one of its handy features that will make your life easier in specific… READ MORE
