How to add a One drive Excel as a Data set in Power BI

Question

Hello. I want to add a One drive Excel as a Data set in BI.
Can someone please let me know how to connect the data.?

Also, will the updates in the OneDrive Excel be automatically updated in the BI reports?

Earlier I had used Google Data studio and connected google sheets. Any updates in the Google Sheets used to get reflected automatically in Data Studio reports. But unable to find the same option I'm Power BI.

Kindly advise on how to proceed.
Thanks.

score 0 · Answer 1 · Oct 29, 2020

If the one Drive is from your company environment you can directly connect to get data. If it’s from the clients' environment then open that file in a desktop application, click on info, copy the path, in powerBI click on connect to Web, past the path, remove till? at the end keep only till file extension (Eg:xlsx), Then load data

Ready to revolutionize your data skills? Explore our dynamic Power BI Course Syllabus designed to empower you with in-depth knowledge and practical expertise.