I cannot connect to Azure Storage to back up my Power BI Premium Per User/Premium
What I did learn when working through the blog post is that I ran into some errors when trying to re-connect or trying to connect to the Azure Storage in my Premium App Workspace and it failed. The errors that I got were, “We couldn’t connect to Azure, but it’s likely temporary. Try again later or see details.” Below is…
Data Loading – Part 3 | Migrating AAS to PPU
Welcome to the third instalment of my series on migrating AAS to PPU. In this blog post I am going to cover what the difference to load data into AAS and how to load data into PPU and the associated performance. Here are the previous 2 parts I have completed in the series. 1 – Query Performance – Part 1…
Scalability – Part 2 Migrating AAS to PPU
Thanks for reading and welcome to part 2 of my series on migrating AAS (Azure Analysis Services) to PPU (Power BI Premium per User) If you missed the first part of the series here is the link here: Query Performance – Part 1 Migrating Azure Analysis Services to Power BI Premium Per User – Reporting/Analytics Made easy with FourMoo and…
Changing the User Account in Excel when connecting to Power BI Premium/Per User or Azure Analysis Services
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 The method below will work…
Create Currency Formatting Strings using Calculation Groups in Power BI Pro & Premium / Azure Analysis Services / SQL Server Analysis Services 2019
Below are the steps on how I got the calculation groups to work for Currency formatting strings when the currency format string will be displayed per currency shown. Following on from my previous blog post (How to create and use Calculation Groups in Power BI Pro & Premium / Azure Analysis Services / SQL Server Analysis Services 2019) on how…
How to create and use Calculation Groups in Power BI Pro & Premium / Azure Analysis Services / SQL Server Analysis Services 2019
I have been reading some great blog posts from SQLBI.COM on using and implementing Calculation Groups. What I did find is that currently there is not step by step process on how to get this working. This is what I will do in my blog post below. As it stands today 29 April 2020 you can currently use calculation groups…
Intro into Power BI Premium
I was chatting to my good friend Treb Gatte and one of the things we both discovered is that there was not a good blog post with regards to an introduction into Power BI Premium. I thought this was a great idea and have turned it into this blog post below. I am going to cover the following sections below…
How to connect to your Power BI Premium Datasets using Excel (with the XMLA End Points)
I have had seen a few questions in the Power BI Community, as well as from other people asking if it is possible to connect directly from Excel to a Power BI Premium dataset from Excel. Without having to log into the Power BI Service or download any .ODC files. I am going to show you how to do this…
Review of new features & Announcements for #PowerBI – From the Microsoft Business Applications Summit
I was once again very fortunate to make it across to the Microsoft Business Applications Summit in Atlanta. I had 3 sessions which I presented at, and they went well. It was great to meet new people (some of whom I had only read their blog posts or viewed their videos) and reconnected with existing people. As I did last…
Power BI Premium Performance – Part 5 | How much memory will the PBIX consume?
This was something that I thought I had covered off already and was one of the key messages that I wanted to get across when looking to move to Power BI Premium. It can be quite confusing when always thinking about the size of a PBIX file being smaller than 1 GB and then moving to Power BI Premium where…