Forum Discussion

jaryszek's avatar
jaryszek
Super User
1 year ago
Solved

Measuring power query outside power bi

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

  • 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

2 Replies

  • 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's avatar
      jaryszek
      Super User

      Thank you. 

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

      Best,
      Jacek