Forum Discussion

nleuck_101's avatar
nleuck_101
Continued Contributor
2 years ago
Solved

Exporting Summarized data with live connection not refreshing in Excel

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 P...
Need Help
  • nleuck_101's avatar
    nleuck_101
    2 years ago

    Hello All,

     

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

     

     

     

nleuck_101's avatar
nleuck_101
Continued Contributor
2 years ago

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's avatar
Raj3798
Frequent Visitor
2 years ago

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

  • foodd's avatar
    foodd
    Community Champion
    2 years ago

    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.