View Native Query Now Works For Analysis Services Data Sources

If you’re familiar with the topic of query folding in Power Query, you’ll know that the View Native Query right-click option in the Applied Steps pane of the Power Query Editor can be used to show the native query that is run against the data source. You may also know that there are some data sources where query folding does take place but where View Native Query remains greyed out. One of those used to be Analysis Services, but the good news is that that is no longer the case: you can use View Native Query when importing data from Analysis Services! Look:

I’m told it also now works for SAP BW, but I haven’t tested it.

7 responses

  1. Just confirming that query folding works for SAP as well. Seeing the native SAP BW code will also make it easier to have a good communication with the SAP technicians

  2. Pingback: View Native Analysis Services Queries in Power Query – Curated SQL

  3. Pingback: Power BI Insights: Native queries; Exporting website data; Subscriptions; Waterfall charts; DAX calculations | MSDynamicsWorld.com

  4. Pingback: Power BI Insights: Native queries; Exporting website data; Subscriptions; Waterfall charts; DAX calculations ERP for Hong Kong SME

  5. Pingback: View Native Query Now Works For Analysis Services Data Sources | Pardaan.com

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: