Measuring power query outside power bi

[jaryszek]

Hi Guys,

from engineering point of view -> it is possible to measure power queries times outside power bi? 
Like run them outside power bi ? 
How?

I know diagnostics tool inside power bi but i want to have possibility to control power queries outside power bi?

Best Wishes,
Jacek

Best Wishes,
Jacek

[Akash_Varuna · Accepted solution]

Hi @jaryszek , Yes, it’s possible to run Power Query transformations and measure their execution times outside of Power BI Please try these out 

• Dataflows: Use Power BI Dataflows and check refresh history for timings.
• Power Query SDK: Run M scripts via Visual Studio with the Power Query SDK.
• Azure Tools: Convert M code to run in Azure Data Factory or Synapse for detailed monitoring.
  If this post helped you please do give a kudos and accept this as a solution
  Thanks In Advance

[jaryszek]

Thank you. 

Do you know if it is possible to import power queries from visual code SDK into Power BI? 

Best,
Jacek