Migrating from Azure Analysis Services to Power BI Premium

Power BI Premium support for the XML for Analysis (or XMLA) protocol is in public preview. XMLA is an industry standard for data access for analytic client and management applications (and has been an open standard for almost 20 years). Azure Analysis Services and SQL Server Analysis Services both use the XMLA protocol for communicationsContinue reading “Migrating from Azure Analysis Services to Power BI Premium”

Power BI Exact Distinct Count and Aggregations

It’s not news that Power BI supports aggregations. What might be news is that these aggregations support distinct count measures. Today. The aggregation dialog has “Summarization” method. If you select “GroupBy” as the summarization method for a column, not only are all unique values of the column retained, but Power BI is clever enough toContinue reading “Power BI Exact Distinct Count and Aggregations”

Follow My Blog

Get new content delivered directly to your inbox.

%d bloggers like this: