Create Trello Reporting using Power BI
Where I am consulting, they use Trello boards which enables them to keep track of what tasks are being done, getting done and how things are progressing. An interesting question came up asking how much work has been done. And I thought this could be done via Trello and looking at the number of tasks in the boards that have…
Creating a Power BI Report from the Audit Logs stored in Azure Blob Storage
Following on from my blog post on How you can store All your Power BI Audit Logs easily and indefinitely in Azure, I wanted to share with you how I connected to the Blob Storage Files and created my Power BI report, to report on the audit logs. Pre-requisites Before starting with the Power BI report, I first had to…
Power BI – Which Groups can be used to set Permissions in Power BI
There are quite a few areas where Power BI can assign permissions. Below is a list of which permissions can be assigned by which Groups that are available in Power BI. Explanation of Groups Security Group This is also known as an Active Directory Security Group. This group lives within Active Directory and Azure Active Directory. It is where you…
How to configure Incremental Refreshing in Power BI with DateKey or Date (instead of the default DateTime)
I was helping on the Power BI community forum (where I certainly learn a lot) and I came across this blog post where a Microsoft Employee had suggested that a Power Query function could be used as part of the Incremental refresh. What I mean by this is when implementing Incremental refreshing in Power BI the default is that you…
Ensuring your Power BI Incremental Refresh does not Timeout when using a SQL Server Source
I recently was updating my PBIX files to use the Incremental refresh. I ran into a timeout error as shown below. This was because on the first refresh it has to process all the data before it can incrementally refresh the dataset. As per the documentation the default timeout for a SQL Server database is set to 10 minutes, and…
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…