Refresh connection to simple Excel in OneDrive

[Anonymous]

Hello friends,

I've published a dashboard from Power BI Desktop.

One of my queries uses:

= Excel.Workbook(Web.Contents("https://my-onedrive_account/someexcelfile.xlsx"), null, true) - as a Source

I've set as an Organizational Authentication, entered my credential and everything works in a Desktop.

After I've published it to Powerbi.com - my DataSource fail to refresh.

I tried to enter credentials  - but there's no Organizational Authentication option. 

What do I miss? It should be simple - I have the same account for OneDrive and PowerBI.

Please Help!

Thank you

Michael

[v-caliao-msft]

Hi @Anonymous,

I have tested it on my local environment, we cannot reproduce this issue.

Regards,

Charlie Liao