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…
How I saved 40%+ on my Power BI Dataset size
I have been working with a customer who has a fairly large dataset. Part of my role was to see if there was any way to see how I could reduce the amount of memory being consumed, whilst still allowing for the same metrics to be represented. Challenge accepted! I had already applied all the best practices in terms of…
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…
Getting automatically notified for Power BI Support Issues
I had an interesting question from a good friend of mine on Twitter (Mim), where he asked if it was possible to get notified of when there are updates to Power BI Support issues. This got me thinking as I had already created my own Power BI Report, which sends me a daily email subscription of the Power BI Support…
Power Platform (Power BI, Power Apps, Power Automate) Announcements from Ignite & SQL Pass
It is that time of the year when there are 2 massive Microsoft conferences happening at the same time. As I have done previously, please find below all the Power Platform announcements with some of my initial thoughts. I do get FOMO at not being at either of them, but thanks to Twitter and other good people there is no…
AAS (Azure Analysis Services) / SSAS Tabular -Using BISM Normalizer to NOT Overwrite existing Partitions
I had partitions already configured and running on my AAS model. Partitions allow you to process only the data that needs to be updated. I have certainly done it in the past whereby mistake I updated all the partitions, which would mean I would then need to re-process them. This would not only take a lot of time (due to…
How to see what the actual values are in a FILTER when using a DAX Measure
I was working with a customer trying to get them to better understand DAX and one if the things that is difficult to understand is how the filtering works in DAX. The challenge I have found is that when using filters in a DAX measure I cannot visually see what is happening within the DAX Filter. Below I will show…
Power Query – Add Column to see if it is a Number Data Type
I was recently extracting some data from a web page and I wanted to remove all the rows that did not have a Numeric or Number value. I solved it by doing the following below. The column I was using was called ironically Column5 The syntax below can be used in Power Query / Query Editor to see if the…