Power BI Insights: Azure Analysis Services server properties; Showing completed months; Time dimension tables with Power Query; M language

This week, Power BI pros share their insights on changing Azure Analysis Services server properties, viewing completed months in Power BI, time dimension tables or the M language and Power Query.

Changing the visibility of Azure Analysis Services server properties

On Chris Webb's BI Blog, Webb explored how to change the visibility of Azure Analysis Services server properties in SQL Server Management Studio. Many server properties can be edited in SQL Server Management Studio,  but these are often more difficult to change in Azure Analysis Services. He recommended using an XMLA script. Within the server properties dialog, users can alter the server properties but shouldn't click ok. Instead, they need to create a new XMLA query window and update the naming and values as needed.

According to Webb, users will usually need to enter section names in addition to the name of the server property and then hit the execute button.

Showing completed months in Power BI

FREE Membership Required to View Full Content:

Joining MSDynamicsWorld.com gives you free, unlimited access to news, analysis, white papers, case studies, product brochures, and more. You can also receive periodic email newsletters with the latest relevant articles and content updates.
Learn more about us here

Get full access

or login