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.