Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Excel in OneDrive as Dataset

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!