cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
juliesam Frequent Visitor
Frequent Visitor

Schedule refresh for power pivot from one drive shows error

Hi All,

I have opened an account in powerbi.com and taken the 60 days trial for power bi pro. I'm new to Power BI desktop. I have an excel 2013 file contains a table of data. Then I have added this to data model. This power pivot has been copied to OnDrive personal folder. I have connected to the file in onedrive personal from powerbi.com. Then I need to schedule refresh for the same. But, I'm getting an error message while trying to schedule refresh it.

"You cannot schedule refresh for this dataset because it does not contain data model connections. You cannot schedule refresh on worksheet connections or linked tables. To schedule refresh the data must be loaded into the data model."

Please suggest.

 


Regards,

Julie

3 REPLIES 3
ashishrj Senior Member
Senior Member

Re: Schedule refresh for power pivot from one drive shows error

@juliesam Even I was facing a similar issue when scheduling data refresh for Excel file connected via One Drive for business/personal. But data refresh works fine with Data Management Gateway but not with One Drive. Shows error message as given above by @juliesam

DaveBreyley Frequent Visitor
Frequent Visitor

Re: Schedule refresh for power pivot from one drive shows error

I am having the same issue.

 

I have done the following:

  • Created a simple Excel file and set a table on my worksheet
  • added table to the data model, and renamed the table in the data model to TableX
  • saved the worksheet to OneDrive
  • on Power BI site, connected to the Excel file on One Drive.
  • the dataset sees the TableX in the data model

Schedule refresh is not allowed, error message is

               You cannot schedule refresh for this dataset because it gets data from sources that currently don't support refresh. ...

Tried using a .xslx and and xlsm files.

 

Additionaly tried to use a power query rather then adding table to the data model.

Highlighted
PowerBIGuy Member
Member

Re: Schedule refresh for power pivot from one drive shows error

Julie, there’s no need to schedule refresh. The data is automatically refreshed every hour when connected to one-drive. 

Business Intelligence Architect / Consultant

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 313 members 3,106 guests
Please welcome our newest community members: