Forum Discussion

Gnoom's avatar
Gnoom
Frequent Visitor
11 years ago
Solved

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 s...
  • BraneyBI's avatar
    BraneyBI
    11 years ago

    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

  • andre's avatar
    andre
    11 years ago

    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

BraneyBI's avatar
BraneyBI
Kudo Commander
11 years ago

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

juliesam's avatar
juliesam
Regular Visitor
10 years ago

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?