Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Direct Query for Excel Data

I know that various data sources support a Direct Query (https://docs.microsoft.com/en-us/power-bi/desktop-directquery-data-sources) but is it possible to connect an Excel spreadsheet held on a Share...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Yep, those are the only possibilities. I'd use refresh now to check out if it's working. Then you should set up some refresh times to refresh the report periodically everyday. I think there is no way to have automatic updates that refresh the report as soon as you change your file.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

I see the 'scheduled refresh' and the 'refresh now' menu items for the Dataset in the web version of Power BI. It seems that these are the only two valid options for Power BI reports that link to Excel data.

 

Thanks for your assistance!

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Yep, those are the only possibilities. I'd use refresh now to check out if it's working. Then you should set up some refresh times to refresh the report periodically everyday. I think there is no way to have automatic updates that refresh the report as soon as you change your file.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Agreed.

  • karaoan's avatar
    karaoan
    Icon for Kudo Kingpin rankKudo Kingpin
    5 years ago

    Anonymous One other option that you can try is: Acterys Power BI Sync This solution enables you to automatically synchronize a Power BI model with any source supported in Power BI to Azure SQL Server and also adds very extensive planning and editing options with 8 Power BI visuals: Business Apps – Microsoft AppSource