Forum Discussion
kakirr
Microsoft Employee
6 years agoCannot link to a datasource URL housed by SPO Modern
Power Bi is not accepting the Modern SPO URL format as a datasource / example our Excel file is at: https://microsoft.sharepoint.com/:x:/r/teams/SteyerFinancials/_layouts/15/Doc.aspx?sourcedoc=%7B10F...
kakirr
Microsoft Employee
6 years agoInteresting, our xlsx file previously connected to Bi fine from: https://microsoft.sharepoint.com/teams/SteyerFinancials/Shared%20Documents/General/Steyer_PO_INVOICING_FY19_H2_xlsx
It would be good to know why the Modern SPO URLs do not work.
d_gosbell
Super User
6 years agoIt looks like you are a Microsoft employee so you could probably find out more about this internally.
But my understanding is that the issue is around storing and forwarding Azure AD credentials for scheduled refreshes. I believe that on PowerBI.com this is handled by functionality in Azure which does not exist in the on-prem environment.