-
This article describes the differences in the levels available in Azure Analysis Services (Azure AS), comparing them with the features in SQL Server Analysis Services (SSAS) on-premises. Read more
-
UPDATE 2021-06-29: also read Choosing Azure Analysis Services or Power BI Premium for large datasets – SQLBI containing updates about Power BI Premium Gen2. I often get questions about use cases for Azure Analysis Services. So I wanted to do… Read more
-
This article and its companion video describe how to create a service principal account to be used with the Power BI API. The reader must already be familiar with the Power BI API. Read more
-
Almost 18 months ago I compared Azure Analysis Services and Power BI Premium for large datasets. At that time, Azure Analysis Services was a clear choice, but it is almost time to update that post with a longer article. Because… Read more
-
I recently implemented Power BI models by extracting data from Azure Data Lake Storage (ADSL) Gen 2, and I wanted to share a lesson learned when using this connector. Read more
-
This article describes the memory configuration in SQL Server Analysis Services and Azure Analysis Services. Modifying these settings may impact performance and memory errors. Read more
-
This article shows how to define variables in DAX queries and introduces the differences in scope when there are multiple EVALUATE statements. Read more
-
blog post
DataMarket and PowerPivot
Yesterday Microsoft released the Windows Azure Marketplace DataMarket (which everyone will simply call DataMarket, I hope). It was previously called Codename “Dallas”. This is an important step toward the empowerment of self-service BI tools. Microsoft also released two add-ins: The… Read more
-
This blog is usually dedicated to Business Intelligence and SQL Server, but I didn’t found easily on the web simple PowerShell scripts to help me deploying a number of virtual machines on Azure that I use for testing and development.… Read more
-
This blog is usually dedicated to Business Intelligence and SQL Server, but I didn’t found easily on the web simple PowerShell scripts to help me deploying a number of virtual machines on Azure that I use for testing and development.… Read more