Did you know external (Guest) users can connect to your Semantic Model using Excel?
Yes, you read that right, it is possible where you have shared Power BI semantic model with an external (guest user in Entra ID) they can now connect to the semantic model using Excel. This has been around for quite a while I just did not know about it, here is the Microsoft documentation: Semantic model connectivity and management with…
How to easily send an Excel extact using a paginated report in Power BI
The goal of this blog post is to show you how to create a subscription which sends the data in an Excel attachment. To do this I will first create a paginated report off an existing dataset. Once the paginated report is created, I will then create a subscription with the Excel attachment. I could then share this paginated report…
How to refresh an Excel file stored in SharePoint Online without the need for a Power BI Gateway
I have been answering some questions on the Power BI (Or is it now Fabric?) community forum, and I have found recently that there are some people asking how to get data from Excel that is stored in SharePoint Online. In this blog post I will show you how to connect to a single Excel file using Power BI desktop,…
Power BI – Testing Row Level Security (RLS) for multiple users in Excel
I have been doing a fair amount of work on Row Level Security (RLS) where the requirements were quite complex to implement. Once I had completed the implementation of RLS there were two outstanding items I needed to test. Make sure that the users are only viewing the data they should see. Ensure that the performance of a selected user…
How to create an Excel table from a DAX (Power BI) query to be used for Data Validation
I had a requirement where the customer wanted to make sure that the right user could only see the colour from the stock item assigned to them. Essentially using the Excel file for Row Level Security. For the Row level security to work correctly it required the colour name to be an exact match. For me to ensure that this…
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…
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…
How to enable Excel Pro’s to use Power BI Datasets
In the steps below, I am going to demonstrate how to access your Power BI Dataset through Excel. This is a great example for people who love Excel and use it as their tool of choice, but the company or organization still wants to have a single version of the data. By leveraging the steps below the data is available…
Power BI – DAX Measures for Excel based “ % of Column Total “ or “ % of Row Total ”
Where I am currently consulting there was a requirement to create a measure like you can in the Excel pivot tables for the % of Column Total or the % of Row Total. One of the things that you can currently do in Power BI, which I only learnt as part of this requirement is that you can use %…
BI-RoundUp – Power BI (Office 365 Adoption Content Pack – Embedded Accelerator) – Excel (Get & Transform Updates May 2017)
This will no doubt be a quieter week, leading up towards the end of May and into June when there will be the next wave of updates from the Microsoft Power BI Team You might also notice that I have changed the name from BI-NSIGHT to BI-Roundup, as there was another blogger who has his blog URL as BiInsights, so…