Forum Discussion

Luxilon's avatar
Luxilon
Regular Visitor
9 years ago
Solved

Power BI (Free) Refresh Frequency

Hello,   This is in refernce to the Power BI Free version:   Created an Excel Power Pivot Connection via SQL Server which adds to the Data Model via query Saved the Excel Workbook to OneDrive-B...
Need Help
  • GilbertQ's avatar
    GilbertQ
    9 years ago

    Hi Luxilon,

     

    DSimma is correct in that you still need to update your Excel file from your SQL Server Source. And that is what you do when you manually click refresh.

     

    The only option that I can think of is to use Power Update which does have a free version for 1 file refresh, which will open your file, update it, and upload it to OneDrive for Business.

GilbertQ's avatar
GilbertQ
Super User
9 years ago

Hi Luxilon,

 

DSimma is correct in that you still need to update your Excel file from your SQL Server Source. And that is what you do when you manually click refresh.

 

The only option that I can think of is to use Power Update which does have a free version for 1 file refresh, which will open your file, update it, and upload it to OneDrive for Business.

Luxilon's avatar
Luxilon
Regular Visitor
9 years ago

Power Update is the perfect solution! Works like a charm.