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

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

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
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (19,036)