This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowThe Fabric community is now in read-only for platform upgrade. Learn more
Hi all,
Is there any tool that Converts PowerQuery commands to SQL or TSQL?
If so please share links with more information.
Thank you,
Rita
Solved! Go to Solution.
Hi @Ritaf1983 ,
View Native Query in Power BI is a feature that allows you to see the underlying SQL query that is generated when you create a visual in Power BI.
If your query can be floded( Power Query Query Floding), you could use the view native query on the last step.
For more details, please refer to:
Query folding - Power Query | Microsoft Learn
Power BI Native Query and Query Folding (mssqltips.com)
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Ritaf1983 ,
View Native Query in Power BI is a feature that allows you to see the underlying SQL query that is generated when you create a visual in Power BI.
If your query can be floded( Power Query Query Floding), you could use the view native query on the last step.
For more details, please refer to:
Query folding - Power Query | Microsoft Learn
Power BI Native Query and Query Folding (mssqltips.com)
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
| User | Count |
|---|---|
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
| User | Count |
|---|---|
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |