One Drive refresh with Excel

[Anonymous]

Hi Everyone,

My data source is Excel which needs to be automatically refreshed every day(that means I change excel every day), so I placed excel in one drive and got connected but whenever I change the excel. Power bi is not able to extract from the excel into individual tables.

In excel I have different tabs that need to be in different tables in power bi, but power bi was not able to do that and says key not available error, again I have to go into power query and edit the query into separate tables and refresh manually every time.

Any idea of how it can be automated?

The main idea is to autorefresh the excel in one drive on daily basis. Power bi needs to pick the excel file in one drive and auto-refresh it. The excel has many tabs which automatically needs to become tables in power bi

[V-lianl-msft]

Hi @Anonymous ,

According to my test, this happens when you use the excel connector to connect to the excel file on onedrive. Try to connect to the excel file on onedrive using the web connector.

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-onedrive-business-links 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous ,Based ion what I got

Refer for refresh : https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-desktop-file-onedrive

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-onedrive-business-links