Issue with authentication with OneDrive

[lomorris]

I am having an authentication issue with my BI report once it is published to the PowerBI service. I am trying to connect to an excel spreadsheet that is located on OneDrive. I am able to connect to it after selecting data source as Web and giving it the following URL.

https://alliancemat-my.sharepoint.com/personal/lmorris_alliancemat_com/Documents/Reporting/PowerBI/Alliance%20Reports/Development/DailyDoc/VITSALES.xlsx.

I get prompted for my credentials and using Organizational. It works as expected. The issue I have is once the report is published to PowerBI service. The refresh fails due to authentication with One Drive.

Any thoughts on this? I am stuck only with authenticating.

[lomorris]

I was able to determine the issue. In the case of credentials for PowerBI Service to OneDrive. I had to select OAuth2 and Organizational. Once I did that, it popped the Microsoft office dialog box and after I selected the account, I use it worked like a charm. All good here.