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.
It also works for Salesforce Objects, at least for some basic transforms like filters and row limits.
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
Pingback: View Native Analysis Services Queries in Power Query – Curated SQL
It would be great to see this feature with Spark/Databricks connector!
Pingback: Power BI Insights: Native queries; Exporting website data; Subscriptions; Waterfall charts; DAX calculations | MSDynamicsWorld.com
Pingback: Power BI Insights: Native queries; Exporting website data; Subscriptions; Waterfall charts; DAX calculations ERP for Hong Kong SME
Pingback: View Native Query Now Works For Analysis Services Data Sources | Pardaan.com
It’s greyed out for MS SQL Server queries for me!? Even though all steps (aside from Source) show the gear. Source is greyed out (presumably) because it’s a reference query to my raw data query. Is there no way around this other than to re-apply all the steps onto the raw data query (where View Native is not greyed out.)
I was barking up the wrong tree. I had a Transformation to Date Only in one of the reference queries. Turns out that breaks the chain, and using Change Type – Date preserves it!