Historical Data Loading – Part 5 – Migrating AAS to PPU
In this blog post I am looking at how to load or reload historical data in AAS and PPU and compare the differences. It should already be noted that I am only going to compare tables where I have partitions created and enabled. The reason being for dimension tables it is typically quick and easy to reload the data by…
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…
Power BI RoundUp – Paginated Reports in Power BI Apps | Cache Settings for Azure Analysis Service
Here is another weeks Power BI RoundUp, and there is still a lot going on! Paginated Reports in Power BI Apps As you can see above paginated reports are now available when you create an app for your organisation to use. All the details are here: Paginated Reports now supported in Apps in Power BI Cache settings for Azure Analysis…
BI-RoundUp – Power BI (Happy 2nd Birthday) – Azure Analysis Services (Web Designer)
Here is the weekly BI-RoundUp with the latest news. Power BI – Happy 2nd Birthday I cannot believe that it has already been 2 years since Power BI was launched. It is amazing to see how many new features and capabilities that keeps on happening. In the past year they have released 153 new features and updates. That is amazing…