Forum Discussion

adumont's avatar
adumont
Icon for Advocate I rankAdvocate I
8 years ago

Organizational account credentials from Power BI Server?

Hi,   I've created a report with a Sharepoint Folder data source (specificaly, an excel xlsx file in a folder of my Sharepoint site). My Sharepoint is hosted on Sharepint Online and I access it via...
Excel
Power BI Desktop
power bi server
SharePoint
Hayleysea's avatar
Hayleysea
Icon for Resolver II rankResolver II
6 years ago

I'm not sure if this is the exact same issue but I had a Power BI desktop file connecting to an excel file in Sharepoint and it was working fine in Desktop but when I published online I had the same issue with credentials and OAuth2 missing. I realised I had "/:x:/r/" in the data source connection, once I removed this and updated the data source it worked perfectly.

  • OleksandrM's avatar
    OleksandrM
    Frequent Visitor
    6 years ago

    Hello,

    Spent a few days searching for the solution, and the last post was a revelation - I used to copy link to an excel file from the web browser, deleted the part after ? till the end:

     

    Now I see when I remove /:x/r/ or copy the path by opening the workbook in Excel solves the issue and I add credentials 

     

    Here it is:

     

    Suggest to mark the above suggestion as a Solution.

    • XaniloM's avatar
      XaniloM
      New Member
      3 years ago

      Many thanks, is 2023 now and this is still a problem in BI Online, and your hint is the only way that i got to solve it!!!!