Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Error in refreshing and updating link using Excel data file to PowerBI

Every once in a while for whatever reason the link to my excel file needs to be manually refreshed by going to Edit Queries, then Data Source Settings. I then go to change source and re-upload the fi...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Anonymous

    Is this excel file stored on your local or online?

    you could create a new pbix file, use option "Get data"-"excel", select a excel file, check if this excel file can be imported to Power BI?

     

    If this doesn't help, please share the screenshot of your "change dataset" setting.

    Mine is as below

     

    Have you alreadly created any visuals using the fileds from previous excel file data?

    Are the structure of data from privous excel file and this excel file same?

     

    Best Regards

    Maggie

     

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi Anonymous

Is this excel file stored on your local or online?

you could create a new pbix file, use option "Get data"-"excel", select a excel file, check if this excel file can be imported to Power BI?

 

If this doesn't help, please share the screenshot of your "change dataset" setting.

Mine is as below

 

Have you alreadly created any visuals using the fileds from previous excel file data?

Are the structure of data from privous excel file and this excel file same?

 

Best Regards

Maggie