Unanswered

PBI report export page to PDF gives "Error fetching data for this visual See details"

(1) Share

Report

Posted on by CU04081424-0

Hi all, I have this report page that we would like to export automatically through Power Automate.. And althouth the PDF is send by email the correct way, it says (for one visual) that there is an error fetching data for this visual.
The data within this visual is both direct query from a database and an import from sharepoint list. And whenever we open de PBI report in service we are able to export it. Also, when I leave out the sharepoint list data and just only the DQ data, the PDF export works!.. Power Automate account is the same as the PBI service/sharepoint.

Any idea? I have also disabled the New designer toggle, but nevertheless

Thank you in advance!
Max

Categories:

Building flows

I have the same question (1)

All responses (3)

Answers (0)

Sort by

Michael E. Gernaey 53,978 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi @CU04081424-0

What does it say under the link for more details?

Since I do not see a flow and that error isn't enough information can you tell me.

1) you said the flow works and sends the email correct?

2) the but the email doesn't work due to the sharepoint data?

3) can you please share the flow itself as well as a flow run, so we can see the inputs and outputs

I'd like to see how the data is attached to the email. I know you said it works fine without sharepoint but I want to see it.

Also, in the case of SharePoint specifically, do the users have M365 licenses, since your expectation is they are seeing data in real-time from the embedded data and or report/dashboard?

Who are the recipients?

Was this reply helpful? Yes No
CU04081424-0 5 on at

Like (0)

Report
Copy link

Link copied!

To answer you reply @Michael E. Gernaey,

Attached screenshot show the current PA flow for exporting the PBI page to PDF.

This flow works; sends an email with a PDF of the page that I want; however, one matrix visual containing data (one column) from a sharepoint list is not loaded/showing (as mentioned before). Previously, I added a refresh dataset and delay since perhaps it had to do something with loading the data from the sharepoint list, but this has not fixed the issue.

Whenever I click on the link to check the error I am redirected to the general Power BI service environment. For now the email is only send to me due to testing of this flow.

Was this reply helpful? Yes No
CU31122335-0 2 on at

Like (0)

Report
Copy link

Link copied!

Hey,

Were you able to find a solution for your problem? I came across the same issue...

Was this reply helpful? Yes No