Power BI – Bulk Changing Permissions (Read, Reshare & Build) on Datasets
I recently had a challenge where a report was shared with a whole lot of people (Which is a good thing!). The challenge was that when you share reports, by default it has the option to “Reshare” as shown below. Whilst this sometimes is what is required, I always suggest to people to remove this option and rather manage it…
Did you know you can use the Scheduled Cache Refresh for LiveConnections in Power BI to tell you if it is down?
Did you know you could use the Scheduled Cache refresh to notify you if your Live Connection is down between Power BI and your SSAS/AAS Database? In this example below I already have got my reporting connecting to an Azure Analysis Services database, this could also be an On-Premise SQL Server Analysis Services database. I make sure that I first…
Using Power BI Support to create a Support Ticket
Whilst I have been busy answering questions on the Power BI Community one of the things that I have found is that at times people with Power BI Pro or Power BI Premium are unsure where to create a support ticket which will allow them to escalate their issues. Below I explain how to do this. Creating Support Ticket The…
Power Query – Getting the Min Value repeated for all rows in my table
I was working on a side project, looking to track how I had been training in Strava (Yes, I am a M.A.M.I.L. for anyone who has been to my presentations would have seen the picture!) What I was looking to do was to get the starting time of my event repeated on every row, which would then allow me to…
How to enable the Power BI On-Premise Data Gateway to Stream data immediately
Below is a quick blog post on how to stream the data immediately when using the On-Premise Data Gateway. Currently as far as I understand it the On-Premise Data Gateway will wait and buffer some data before sending it through to the Power BI Service. By changing the setting below in the On-Premise Data Gateway, it will start streaming the…
Hiding the Filter Pane on opening a report or in Full screen mode in Power BI
I was answering a question on the Power BI Community where a user was having a challenge when opening a report in Full screen mode and it kept on expanding the filter pane. This report was only going to be run in full screen. Below are the steps on how I solved the solution. I solved it by doing the…
Creating a Time Dimension using the Power Query Editor in Power BI Desktop
Below is the syntax to create a Time Dimension Table in Power Query I had a requirement where I needed to create a Time Dimension for a customer. Most of the time I only need the date. Upon searching I could not find a resource where they had created the time dimension only using Power Query. Reference: https://docs.microsoft.com/en-us/powerquery-m/list-times What I…
Using Azure Analysis Services to connect via an ODBC Source (Redshift)
I am busy working with a customer and had a challenge when using Azure Analysis Services to connect to Amazon Redshift via an ODBC connection. The first issue that I encountered was the following error: OLE DB or ODBC error: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application; AWS PROD. This lead me…
Power BI Desktop – How did I connect to Analysis Services using my Power BI Desktop Application when I was outside of the Analysis Services Domain?
I was working with a customer where I was working on my own laptop. My laptop is not part of their domain. I did have an account in their domain and when I tried to connect using Power BI Desktop, I got the following error when trying to connect as shown below. This is not the greatest error message. Fortunately,…
Using Version Control with Power BI Desktop Files, check in, check out, view or revert to previous versions | Part 2
In the second part of my blog post I am going to detail how to use the version control with Power BI Desktop files. This will include adding files, checking files in and out, viewing previous versions and reverting to previous versions. If this is the first time you are reading this blog post, I would highly suggest reading Setting…