How to configure Azure Function App notifications for errors
Below are the steps to enable error notifications on Azure Function Apps Follows on from my previous blog post How you can store All your Power BI Audit Logs easily and indefinitely in Azure, where every day it extracts the Audit logs into Azure Blob storage. One of the key things when working with any job that runs, is that…
How you can store All your Power BI Audit Logs easily and indefinitely in Azure
With the new Power BI Get-PowerBIActivityEvent I wanted to find a way where I could automate the entire process where it all runs in the cloud. One of the current challenges with the Audit logs is that they only store 90 days, so if you want to do analysis for longer than 90 days the log files have to be…
Connecting to Snowflake DB in Power BI
Below are the steps to connect to Snowflake DB using DirectQuery for Power BI. The same steps can be included for Import Mode Installation of ODBC Drivers The first thing I did was to install the ODBC Drivers. I installed the 64bit drivers where I had my Power BI Desktop installed, and I also installed it on all the Servers…
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…
Additional reporting insights using the Get-PowerBIActivityEvent audit logs
I have been working on implementing changes with the new PowerShell script Get-PowerBIActivityEvent from the Power BI team. One of the awesome things is that I noticed that there are some additional fields in the data extract. This then allowed me to be able to provide additional reporting insights. For example, which reports, and dashboards are consumed via an App!…
How to find who has been allocated Power BI Licenses
I got this question the other day from a customer I am consulting at “How many Power BI Licenses do we have, and who are they allocated to?” I thought that this would be useful for other people to know where to find out how many Power BI Licenses there are, if they have been fully allocated, and if so…
How to chat with Guest users in your default Microsoft Team
I recently have been working across multiple Microsoft Teams Tenants and one of the challenges I could not figure out was how can I chat to Guest users outside of the my default Microsoft Teams. The advantages of having a Guest user within your Microsoft Team within the Chat window means that I am not only able to have a…
How to quickly and easily copy a report with a shared dataset to another New App Workspace in the Power BI Service
I was working on some documentation for a customer and I came across a very quick and easy way to create a copy of a report which also creates a connection to the shared dataset that I could then copy to another “New Workspace” Before I found out this gem, I had to manually do this via PowerShell which worked…
AAS Processing Error “Error returned: ‘M Engine error: ‘Microsoft.Data.Mashup; Token Comma expected”
I was recently working on an Azure Analysis Service – AAS project (It could also be a SQL Server Analysis Services – SSAS project), where I edited the M code using the wonderful Tabular Editor I hope that this will assist people who have a similar error and quickly find the solution to the problem! When I then tried to…
Did you know you can throttle the CPU and Memory on the Power BI On-Premise Data Gateways?
In this blog post below, I am going to show you how to configure the Load Balancing with CPU and Memory. I always recommend for On-Premise Data Gateway installations that there be at least 2 Gateways installed. The initial reason was to ensure that if one gateway went down the other one would be able to still refresh or connect…