Excel in OneDrive as Dataset

[Anonymous]

Hi all,

Please bear with me as I'm pretty new to BI and O365 in general...

I have an Excel sheet in OneDrive that I want to use as a dataset for a BI report. Whilst I can do a rudimentary version on BI Service, ideally I want to set it up via BI Desktop as I need to write some measures. Having had a look around, I understand my best option is to use the Web Connector in Desktop to set up the dataset, and I have attempted to follow the instructions that I've found online.

My issue is this - when I look for the file path in Excel Online (by going to File > Info), there is nothing there for me to copy - just a couple of options like Version History etc. Might this be to do with the version of Excel given to me by my organisation, or do I need to do something else with Excel before the option to copy the filepath is available to me?

Cheers!

[amitchandak · Accepted solution]

@Anonymous , You to choose open in-app and from there take the url from info. I followed these steps and able to do that

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

[Anonymous]

Ah thank you so much - I think you might have made my day! 😀