How can we improve Power BI?

Refreshing Excel Files in OneDrive loaded in Desktop and published to cloud.

When you load an Excel File (stored in OneDrive Personal) into Power BI Desktop, once you publish to the web, the data set should automatically refresh / allowed to be manually refreshed.

Currently i note you can load a OneDrive - Personal file from the cloud and can refresh it. But if you utilise a OneDrive file on the desktop you cannot refresh it once it has been published to the cloud (without Personal Gateway).

Apologies if this has been implemented. I just can't find any reference on how to do it.

2 votes
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

angus shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

2 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • Kevin commented  ·   ·  Flag as inappropriate

    However, this does not enable OneDrive Refresh like loading the file via the cloud service does

  • Kevin commented  ·   ·  Flag as inappropriate

    This can be done by loading the Excel file in Power BI Desktop via URL. Grab the URL portion of the <embed> link that can be obtained from OneDrive on the web and change "embed" to "download"

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.