Power BI Insights: REST API with Power Automate; Changing column types; SQL scalar value functions; Progressive disclosure

User Review
0 (0 votes)

Microsoft Power BI pros share their latest insights on working with the new Power BI REST API using Power Automate, detecting and changing column types, SQL scalar value functions and progressive disclosure designs.

Calling the Power BI export API with Power Automate

In a multi-part blog, Chris Webb detailed how to work with the newly released Power BI REST API, which is in public preview, with a focus on using it with Power Automate. He cautioned that for now, the slate of new capabilities only works with Power BI Premium or Embedded and is limited in the number of report pages that can be exported in an hour. So far, others in the Power Platform sphere have blogged extensively about creating custom connectors with Power Automate for the new REST API. After explaining how to configure endpoints, Webb explained how to navigate to the General and Security pages to create a new action button.

With endpoints setup, JSON text and parameters set for two Actions, Webb’s custom connector was ready to use. Webb wrote that Export To File In Group needs to be called first to begin exporting to a file, with Get Export To File Status In Group used to test if the export is ready and Get File Of Export To File In Group for the final step of downloading the export file. To make things streamlined, Webb set a manual trigger for the flow and hard coded which report he wanted to export. He wrote:

If the export status is Succeeded, then the file is downloaded and saved to OneDrive for Business…Otherwise, the flow sends a failure notification email.

Detecting and changing column types

FREE Membership Required to View Full Content:

Become a MemberLogin

Joining MSDynamicsWorld.com gives you free, unlimited access to news, analysis, white papers, case studies, product brochures, and more. You can also receive periodic email newsletters with the latest relevant articles and content updates. 
Learn more about us here