cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
srduval
Advocate V
Advocate V

Export To File for Paginated Reports via Power BI Action

Trying to use the new export file option that's baked into the power bi action works great for anything that doesn't have a parameter, but when I try and export a report that requires a parameter, I get a general connection failure

Error Has Occurred during report processing. My parameters are date/time in the report builder and this is what i'm passing via flow:

[
  {
    "name""StartDate",
    "value""2020-09-16T00:00:00.0000000"
  },
  {
    "name""EndDate",
    "value""2020-09-16T00:00:00.0000000"
  }
]
Anyone have a working sample or ideas as to what i'm doing wrong?
2 REPLIES 2
analmei
Community Support
Community Support

Hello, 

In order I can help you, can you share a screenshot of your flow and the error message?

Ana Almeida | Power Platform Support Engineer

 

Thanks @analmei 

I'm working with Sk on this issue as well. But here is the requested screenshotAnnotation 2020-10-06 101344.png. Also further trial and error on my side has revealed that it is not about the parameter, the report has to be mapped to a gateway, even though it's strictly azure sql database, and a gateway is not supposed to be required to use the report, and the report renders fine within power bi service without needing to have a gateway assigned 

 

Sk Javul Raheman(MINDTREE LIMITED)
Support Engineer
PowerApps and MS Flow Support
Email: v-skrahe@microsoft.com
Backup Email: mtappflowomta@microsoft.com
Working hours: 6:30 PM – 3:30 AM IST

 

srduval_0-1601998356378.jpeg

 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (2,114)