Forum Discussion

kakirr's avatar
kakirr
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

Cannot 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...
d_gosbell's avatar
d_gosbell
Icon for Super User rankSuper User
6 years ago

That's because unfortunately Sharepoint online is not listed as a supported data source for PBIRS. The only options I'm aware of is to either move the file to a supported location like a local file share or to host your report on PowerBI.com. 

  • d_gosbell's avatar
    d_gosbell
    Icon for Super User rankSuper User
    6 years ago

    It 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.