Forum Discussion
Dataflows and OneDrive for Business
If possible, how do you create a Dataflow to a file stored on OneDrive for Business without using the workaround of a Gateway/Local file? I have no problem doing this with files stored on Teams or another standard Sharepoint site by just copying the link and then applying my credentials. I've been unable to figure this out specifically for files stored on my OneDrive for Business.
Thanks.
4 Replies
You can follow the steps in the link below, then copy your M code when creating the dataflow. Use oath as the authentication method when scheduling a refresh of your newly created dataflow
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-onedrive-business-links
Unfortunately that reference is for Power BI Desktop as opposed to Power BI Service and it does not relate to creating a Dataflow. I can create a Dataset from 1DfB easily. What I've been unable to do is create a Dataflow from a 1DfB file.
Hi, RobertCasper
As mentioned by blopez11 ,it also applies to dataflow of powerbi service . I test it on my side and everything works well.Please make sure that the excel path is correct and the authentication kind is organizational account.
The correct file path format is like:
https://xxxxxx.sharepoint.com/xxxxx/filenamexxx.xlsx
?web=1If your problem persists，please show a screenshot of your error message
Best Regards,
Community Support Team _ EasonHi, RobertCasper
Could you please tell me whether your problem has been solved?
For now, there is no content of description in the thread. If you still need help, please share more details to us.Best Regards,
Community Support Team _ Eason
