cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate III
Advocate III

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
Highlighted
Microsoft
Microsoft

Re: Export To File for Paginated Reports via Power BI Action

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

 

Highlighted
Advocate III
Advocate III

Re: Export To File for Paginated Reports via Power BI Action

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (5,494)