web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Export To File for Pag...
Power Automate
Unanswered

Export To File for Paginated Reports

(0) ShareShare
ReportReport
Posted on by 2

Scope: Daily Send and Email with the PDF attached.

 

Job: 

I created a Paginated report with 4 parameters, the data source is a Power BI Dataset. It has four parameters:

 

start_date: yesterday

end_date: current day

star_hour: 6am yesterday

end_hour: 6am current day

 

The flow starts at 9 am scheduled, applied parameters and Exports a pdf file through mail to some end users.

Suly82_0-1711033801430.png

 

Problem: 

The report on service works without problem but since I started executing the flow I've been getting the same errors:

(RootActivityId(f9dbfd93-8f8f-4f65-8ecb-52bd041b333c): There was an error communicating with Analysis Services. Please verify that the data source is available and your credentials are correct. wabi-europe-north-b-redirect.analysis.windows.net). 

 

Suly82_1-1711033852527.png

 

After getting this error If I run it again, the flow works but others don´t, I don't understand why this works in an unstable way.

Suly82_2-1711033922154.png

 

 

 

Thanks in advanced for your help

 

Categories:
I have the same question (0)
  • jonzhu Profile Picture
    4 on at

    Hi @Suly82 have you came across a solution yet? I have a similar problem but it only happens when I apply certain params to the report. For the same report if I query using different params it will work and not output the same error.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard