Forum Discussion
Paginated Report missing fields when run from Power Automate
Closing the loop as I have resolved this!
Firstly - everything I tried came up with the same result:
- No filters in Paginated Report
- Data not in a subreport
- No expressions - just data as is
- No formatting
Data Source was PowerQuery to a SharePoint List.
As stated in the initial issue / question, when run independently the data all shows and displays as expected. It's only when run through a Power Automate Flow that the data doesn't appear.
So the fix...
The only thing that worked was to change the data source from PowerQuery to a Power BI Semantic Model.
This has a number of further limitations as the flow then needs to refresh the dataset (which is pointed at the SPO List) before it processess the Paginated Report - but it has resolved the issue.
Not ideal - but its working.
Hope this helps anyone else that has a similar issue moving forward!
Thanks
Dan
Hi, tieva_dan
You need to make sure that all parameters are correctly passed from Power Automate to the paginated report. Sometimes, parameters may not be mapped correctly or missing, resulting in incomplete data rendering. Also verify that the data in the SharePoint list is refreshed and accessible when the report is generated. There may be latency or synchronization issues that cause the data to not be fully available.
Because your reports contain sub-reports, make sure they are properly linked and satisfy their data dependencies when you run the report through Power Automate.
You can check the following links:
Export paginated reports with Power Automate - Power BI | Microsoft Learn
Solved: Power Automate "export to file for paginated repor... - Microsoft Fabric Community
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.