Forum Discussion

tieva_dan's avatar
tieva_dan
Frequent Visitor
1 year ago
Solved

Paginated Report missing fields when run from Power Automate

So - little bit of an odd one here. Posted in PowerBI as the issue is with Paginated Reports, however I am using a lot of the Power Platform.   If I have posted this in the wrong place - just let m...
Need Help
  • tieva_dan's avatar
    tieva_dan
    1 year ago

    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

     

tieva_dan's avatar
tieva_dan
Frequent Visitor
1 year ago

Thanks Anonymous,

 

All parameters are correctly passed (there is just the one - the SharePoint List ID).

I have verified the SharePoint list data is in-tact - this issue is consistant with resubmits of older submissions as well as new ones - consistantly not showing the same fields.

Subreports are properly linked and satify their data dependencies.

 

The only thing is it does take over two minutes to run - but the flow is set to be asyncronous.

It does feel like it could be a latency issue, but the consistant way it fails is making me question if its a bug?!

 

Thanks

Dan

tieva_dan's avatar
tieva_dan
Frequent Visitor
1 year ago

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