Power BI Insights: Native queries; Exporting website data; Subscriptions; Waterfall charts; DAX calculations

User Review
0 (0 votes)

Microsoft Power BI pros share their tips on native queries, exporting website data, setting up report subscriptions, waterfall charts and DAX calculations.

Viewing native queries with Analysis Services

Chris Webb explained that users already familiar with query folding in Power Query may also know about the View Native Query right-click option in the Applied Steps pane of the Power Query Editor. This option shows the native query running against the data source.

Until recently, the View Native Query option was grayed out for Analysis Services. Webb noted that Microsoft has changed that paradigm, allowing users to import data from Analysis Services. He added that it may also work for SAP, but he hasn’t attempted the process yet.

Exporting website data to use in Power BI and Power Automate

FREE Membership Required to View Full Content:

Become a MemberLogin

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