Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
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

 

  • jonzhu Profile Picture
    4 on at
    Re: Export To File for Paginated Reports

    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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,668 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,004 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow