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 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?
you will be able to refresh but those who you share your content with will have to have a Pro account to see it
I see, so there is no way to refresh a shared report so that others will see the updated version without a Pro account, right?
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 see, thank you!
One more question: what if I refresh from OneDrive? (never tried that) Does that work on non-pro accounts?