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 Organizational Credentials. I've been able to do it in Power BI Desktop for Report Server (October 2017). Once I publish my report to POwer BI Server, I go to "Manage > Data Source" , there in Credentials I can only choose Anoymous or WIndows Authentication. Is there a way to have a report pulling data from Sharepoint Online from Power BI Server as of now? (and have it refresh on a scheduled basis). THe idea is to have some select users edit data in the EXcel file, and management can open the report done in POwerBI. (I'd like to avoid having to open the report in PowerBI Desktop and republish it everytime there is a change in the data source, which is what I am doing for now.)

This needs to be resolved or solved, Currently there is NO way to set up a scheduled refresh, if your file is on ONE DRIVE, or SHARE POINT, where you need to login using the "Organisational Account" credentials option. It will work in PowerBI Desktop, but as soon as you publish from there to PowerBI online, when you try to set up a scheduled refresh you will get the following error: "Your data source can't be refreshed because the credentials are invalid. Please update your credentials and try again." If you from there try to edit the credentials, the only options you will have are: - Anonymous- Windows- Basic Unlike PowerBI Desktop, no "Organisational Account" option! This is basic functionality that should ought to really have been fixed a while 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.

Hi, I'm also facing the same issue. Does anyone knows a solution to it? I've upraded to Mar 2018 Report Server version too.

Mine is actually a https:// url and its not working...

have you been able to solve this problem ? I have the same issue....

Organizational account credentials from Power BI Server?

35 Replies

sachintandon
Regular Visitor
7 years ago
This needs to be resolved or solved,

Currently there is NO way to set up a scheduled refresh, if your file is on ONE DRIVE, or SHARE POINT, where you need to login using the "Organisational Account" credentials option.

It will work in PowerBI Desktop, but as soon as you publish from there to PowerBI online, when you try to set up a scheduled refresh you will get the following error:

"Your data source can't be refreshed because the credentials are invalid. Please update your credentials and try again."

If you from there try to edit the credentials, the only options you will have are:

- Anonymous
- Windows
- Basic

Unlike PowerBI Desktop, no "Organisational Account" option!

This is basic functionality that should ought to really have been fixed a while ago!
- Annemie
  Frequent Visitor
  7 years ago
  I eventually solved the problem for myself !
  
  For some reason power bi desktop used a http:// link to my organizational account and this worked in power bi.
  As soon as I changed this link to https:// and did a new export of the data to power bi online the refresh worked just fine !
  - sachintandon
    Regular Visitor
    7 years ago
    Mine is actually a https:// url and its not working...
Hayleysea
Resolver 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
  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
    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!!!!
BI-lingual
Frequent Visitor
8 years ago
Hi, I'm also facing the same issue. Does anyone knows a solution to it? I've upraded to Mar 2018 Report Server version too.
- Annemie
  Frequent Visitor
  7 years ago
  have you been able to solve this problem ? I have the same issue....
Anonymous
Not applicable
6 years ago
Happy New Year everyone! Is there an update to this problem? Still can't connect to an Organizational Account

2/12/2020 on PBIRS 9/2019
- Anonymous
  Not applicable
  6 years ago
  Same here... that's crazy.
  
  When will this be available ?!
  - Anonymous
    Not applicable
    6 years ago
    Forgot to precise we are using PBIRS Jan-2020 update.
jonathanChavez
New Member
4 years ago
Encontré la solución! En opción> security >habilitar default web browser, colocas las credenciales de la organización y listo!!
- mpsrshl
  Advocate II
  4 years ago
  screenshots of this?
- cnschulz
  Helper IV
  4 years ago
  Where is this setting? Are you talking about client or server? Also does this mean we need to create a single user to do this connection?
  - mpsrshl
    Advocate II
    4 years ago
    He may have misunderstood the question. under the credentials section of the data sources I cannot set the ones for the Odata driver. This happens for both sharepoint and CRM settings
mpsrshl
Advocate II
7 years ago
Hi,

Is there any solution to this issue?

Thanks.
Anonymous
Not applicable
7 years ago
This problem has been solved by Power Bi Team.

Edit credentials ---> choose "OAuth2" in Authentication method ---> sign in
Anonymous
Not applicable
7 years ago
This problem has been solved by Power Bi Team.

Edit credentials ---> choose "OAuth2" in Authentication method ---> sign in

Then it will link you to the organizational account sign in page.
- mpsrshl
  Advocate II
  7 years ago
  Hi,
  
  thanks for the update, would this also apply to CRM 365 accounts?
  
  Also, where can I find the release notes regarding this update? does this update come with the May version of the report Server?
  - Anonymous
    Not applicable
    7 years ago
    I cannot see this feature in May 2019 Report Server at all, release is from 20th May and no newer file is available for download. I wish they would be more clear on when we can actually expect this fix, not when the Power BI team have fixed it in some un-released version.
whereismydata
Resolver IV
6 years ago
Also having this problem. Latest PBIRS (09/2019)
RavinderSunkara
Advocate II
6 years ago
Is there any workaround or solution for this issue yet. I am also facing the same issue with Power bi report server March 2020 release too.
- whereismydata
  Resolver IV
  6 years ago
  hi,
  
  not that I'm aware of. My (to be tested) workaround would be creating a ssis package, load data in on prem sql db or csv. not very efficient.
  - cnschulz
    Helper IV
    6 years ago
    This is crazy. Why bother putting the Auth model in the client if it's not available in the server!?
    
    Replying only to get updates.