automate exporting data from a power BI table report to sharepoint list

[Sean-OReilly]

Hi

Can i automate the exporting of data from a power BI table report to sharepoint list using Power Automate / Flow?

[NikNithiy]

Hi 

I have preminum license for Power BI, but do i need to pay any amount for utlizing the power automate. I have free license in power automate and when i create a flow it is working fine but i dont want to be billed for using power automate.

[Anonymous]

I tried just creating a Power Automate flow from Power BI, and was successful by utilizing the SharePoint Get Items and Update Item connectors. However, the "apply to each" stops at 1000 items. Is there a way to make it go past that point? Does pagination to 5000 items work for Power Automate flows built in Power BI?

Or is there an easier way to filter the ['Power BI Values'] so that it doesn't have to search through so many records?

I'm comparing to the SharePoint list entries and just need values for those entries, but can't figure out how to tell the flow to JUST use those values. Thanks for any tips!

[v-yingjl · Accepted solution]

Hi @Sean-OReilly ,

If you want to export data from power bi to Sharepoint list using Power Automate, you may need to create a subcriotion in power bi and use paginated report to export as .xlsx / .csv format.

For this feature, you need to have a premuim licence in power bi becasuse power bi premium per user licence just allow .pdf / .pptx format.

Please refer this document and consideration:

1. Paginated reports in the Power BI service 
2. Subscribe yourself and others to paginated reports in the Power BI service 

After this, you can combine it with Power Automate to export to sharepoint list, please refer this blog:

Automatically export Power BI Reports to files in SharePoint using Power Automate 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ImkeF]

Hi @Sean-OReilly ,

there is currently no native connector for it. But the technical option seems to exist: Chris Webb's BI Blog: Sample HTTP Endpoint For Querying Azure Analysis Services And Power BI Premium...

You would have to configure that individually in the flow,