Forum Discussion

fredrikg's avatar
fredrikg
Helper I
10 years ago
Solved

Refresh Excel without refreshing through connections

Hi, The subject might sound strange, but here is what I am trying to do:   I have an Excel document with a data model that I load from SQL Server, on-premise. Our IT-department won't let me instal...
Need Help
  • Youssef's avatar
    Youssef
    10 years ago

    Hi fredrikg,

     

    Wondering how this worked for you? ashishrj's solution should work. You can also keep using Excel 2013, and Power BI will pick up the changes made on the OneDrive file automatically without needing to click 'refresh now'. All files uploaded from both OneDrive for Business and personal OneDrive are kept up to date with the OneDrive version.

     

    When you clicked Refresh Now, Power BI attempted to refresh the actual connections (which are to your on prem database), that;s why it showed you that error since it needs the gateway to access that source.

     

    Hope this helps. Let us know if you are still facing issues.

Youssef's avatar
Youssef
Microsoft Employee
10 years ago

Hi fredrikg,

 

Wondering how this worked for you? ashishrj's solution should work. You can also keep using Excel 2013, and Power BI will pick up the changes made on the OneDrive file automatically without needing to click 'refresh now'. All files uploaded from both OneDrive for Business and personal OneDrive are kept up to date with the OneDrive version.

 

When you clicked Refresh Now, Power BI attempted to refresh the actual connections (which are to your on prem database), that;s why it showed you that error since it needs the gateway to access that source.

 

Hope this helps. Let us know if you are still facing issues.