cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jimmy-pa
Regular Visitor

Refresh Power BI DataFlows with Flow

Hi all, good morning! 

 

Does anyone know if it's possible to create a Flow similar to automatic refresh datasets, but this time refreshing DataFlows?

 

I want to refresh a dataflow and cascade to dataset as soon as a SharePoint file is updated. Have you heard something related to this?

 

Thanks in advance and best!

Jimmy

22 REPLIES 22
HarishShades
Frequent Visitor

Hi Rjhale,

 

By using " HTTP with Azure AD" it works perfectly fine but due to DLP rules in my org I cant use this connector along with any other connections, so that where I have to rely on using just the "HTTP" connection and I am facing this error.

rjhale
Advocate IV
Advocate IV

Yeah, I ran into the same issue.  I had to convince our tenant admins that this should fit into our "Business" DLP group.  I believe you can make DLP rules more granular by applying different sets to different environments.  If you have your own environment, perhaps getting a customized set of DLP rules for you environment would be a viable option?  

 

I'm not really sure how to work around the issue of the 1 hour expiration window on the bearer token.  With other API endpoints I've been able to use a renewal token to generate a new access token and then store the two tokens in a text file that can only be accessed by our Flow service account.  Definitely not the best way to do things, and I'm not sure if or how that would work with the Power BI endpoint.  Admittedly, I kind of stopped researching that route once I got the HTTP with Azure AD connector to work properly.  

 

Good luck and let us know if you figure out a solution.  

HarishShades
Frequent Visitor

sure @rjhale @AU 
I appreciate your advice and support on this, I will talk to my Power Platform admins and get this added to my environment.
I hope Microsoft gives a straight forward documentation on these requests, since these options are being used by so many Power BI developers and I will let you know if I find any other approach for the same.

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (1,718)