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

Can't refresh a Data Set from Excel file

Hello,

 

I have uploaded an .xls file (with Power Pivot data models and Power Query connections to csv and xls files) to OneDrive and from there to Power BI, but I am not able to refresh the data set. When I click on "schedule refresh" I get the error message below - could you please explain what I am doing wrong?

 

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.

2 ACCEPTED SOLUTIONS

Accepted Solutions
BraneyBI Member
Member

Re: Can't refresh a Data Set from Excel file

In your Excel file, are the Power Queries writing to the data model, just back to an Excel table or both?

From your error message, It looks like you are using PQ to only write back to Excel.  If you click on the "Load To" option on your Power Query, can you also "Add it to Data Model"? 

 

Then re-save the file, and see if you can refresh it from PowerBI.com

View solution in original post

andre
Advisor

Re: Can't refresh a Data Set from Excel file

You will be able to refresh it but those who don't have Pro account will lose ability to see it the minute you set up scheduled refresh

View solution in original post

20 REPLIES 20
Super User IV
Super User IV

Re: Can't refresh a Data Set from Excel file

Do you have a Power BI Personal Gateway installed? I have loaded up Excel files and refreshed from data pulled in from Power Query from CSV files and Excel file data sources.


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Gnoom Frequent Visitor
Frequent Visitor

Re: Can't refresh a Data Set from Excel file

Yes, I do - doesn't help. 😞 I am using a free Power BI account, by the way.
Super User IV
Super User IV

Re: Can't refresh a Data Set from Excel file

Bad, can't update local files with free account.


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Gnoom Frequent Visitor
Frequent Visitor

Re: Can't refresh a Data Set from Excel file

I've just signed up for a Pro account (60 days free trial) - didn't help either.

BraneyBI Member
Member

Re: Can't refresh a Data Set from Excel file

In your Excel file, are the Power Queries writing to the data model, just back to an Excel table or both?

From your error message, It looks like you are using PQ to only write back to Excel.  If you click on the "Load To" option on your Power Query, can you also "Add it to Data Model"? 

 

Then re-save the file, and see if you can refresh it from PowerBI.com

View solution in original post

roumen92 Regular Visitor
Regular Visitor

Re: Can't refresh a Data Set from Excel file

Did you have tried with Microsoft Access Database Engine 2010 installed?

Gnoom Frequent Visitor
Frequent Visitor

Re: Can't refresh a Data Set from Excel file

Braney,

 

Thank you, you were right! It works now.

 

One more thing to confirm: do I have to be a Power BI Pro user to use this auto-update feature through Gateway? 

Super User III
Super User III

Re: Can't refresh a Data Set from Excel file

Gnoom,

As a free user you can set a scheduled update 1x per day

If you want to refresh more than that, you need to be a Pro User.

 

Here is a list of capabilities for each based on free/Paid


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG
Gnoom Frequent Visitor
Frequent Visitor

Re: Can't refresh a Data Set from Excel file

I checked the features list, but still don't understand one thing: will I be able to refresh the data (daily) from an excel workbook located on my local PC through the Power BI Personal Gateway without a Pro account?

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors