Blog

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…

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…

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…

WordPress Theme built by Shufflehound. Copyright @FourMoo 2021 | ABN 80 382 360 382