Forum Discussion
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!
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
2 Replies
- amitchandakSuper User
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
- AnonymousNot applicable
Ah thank you so much - I think you might have made my day! 😀