Dataflows and OneDrive for Business

[RobertCasper]

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.

[v-easonf-msft]

Hi, @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

[v-easonf-msft]

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=1

If your problem persists，please show a screenshot of your error message

Best Regards,
Community Support Team _ Eason

[blopez11]

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

[RobertCasper]

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.