Forum Discussion
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
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
I've just signed up for a Pro account (60 days free trial) - didn't help either.
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
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?
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
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?
Hi,
I'm also facing the same error. But i'm not familiar with power query. I have a set of data in excel 2013 file and kept it as a table. Then I have added to data model. So, power pivot has been created there. Then I have copied the file to ondrive-personal folder. I have connected to this file from powerbi.com. But when I tried to set refresh it shows the same error. How to resolve this issue?
