Exporting Summarized data with live connection not refreshing in Excel

[nleuck_101]

Hello All,

I'm having a hard time figuring out how to refresh my Excel file daily on SharePoint with data from Power BI using the live connection. I've tried creating a script and then I have a Power Automate process to refresh the data but it's not working. I hope someone here can help me with this process. Below are images of my Power Automate process and Excel script. And yes, I've already tried posting this on the Power Automate community and looked up the script to run in Excel but nothing is working. Any help would be greatly appreciated!

[nleuck_101 · Accepted solution]

Hello All,

I used the following script and Power Automate flow to work.

[Anonymous]

Hi @nleuck_101 ,

It is important to note that when using a live connection in Power BI, the data is not stored in Power BI. This means that the data in the Excel file on SharePoint needs to be updated in the source to be reflected in Power BI through the live connection.

You can refer to below document:

Refresh a semantic model created from an Excel workbook - cloud - Power BI | Microsoft Learn

Connect Excel to Power BI semantic models - Power BI | Microsoft Learn

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[nleuck_101]

Hello @Anonymous 

I think you misunderstand. I'm not connecting this data to Power BI. I'm exporting the data from Power BI to Excel using the export data and live connection. My Power BI data is connected to SQL Server that refreshes everyday. I export that data to Excel but need it to refresh everyday. My Power BI report refreshes but it's not refreshing the Excel data.

[Raj3798]

Hey @nleuck_101 did you find a solution? Am looking for somthing similar as well !

[foodd]

Hello @Raj3798 ,  thanks for reaching out to the Fabric Community Forum. Since the original post has a Soution, and three months old, please create a new post for your questions instead of replying to the existing one. With that, please reply to your post with this detail, and then mark as a Solution.  Rest assured, our community is here to support you, and this approach will help ensure that your question is seen by more people and answered more quickly.