Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Refresh connection to simple Excel in OneDrive

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

1 Reply

  • v-caliao-msft's avatar
    v-caliao-msft
    Microsoft Employee

    Hi Anonymous,

     

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

     

    Regards,

    Charlie Liao