topic Re: Organizational account credentials from Power BI Server? in Report Server

Organizational account credentials from Power BI Server?

adumont — Tue, 20 Mar 2018 17:27:50 GMT

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

Re: Organizational account credentials from Power BI Server?

BI-lingual — Tue, 27 Mar 2018 14:58:52 GMT

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.

Re: Organizational account credentials from Power BI Server?

Annemie — Mon, 22 Oct 2018 13:40:41 GMT

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

Re: Organizational account credentials from Power BI Server?

sachintandon — Mon, 12 Nov 2018 13:51:55 GMT

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!

Re: Organizational account credentials from Power BI Server?

Annemie — Mon, 12 Nov 2018 14:24:21 GMT

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 !

Re: Organizational account credentials from Power BI Server?

sachintandon — Mon, 12 Nov 2018 14:59:03 GMT

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

Re: Organizational account credentials from Power BI Server?

Annemie — Mon, 12 Nov 2018 15:00:33 GMT

Did you pick Oauth2 in powerbi online ?

Re: Organizational account credentials from Power BI Server?

sachintandon — Mon, 12 Nov 2018 15:58:17 GMT

Oauth 2 isn't an option in Power BI Online

When I go to datasets >> security, the only credential options are

Anonymous

Windows

Basic

I've ended up using Dataflows, the Excel File import connector (which supports both Online Excel files, so I can just point it to my OneDrive file, AND Organisational Account as a fourth option credential option)

Then in Power BI Desktop, I use the Dataflow Connector

Then in Power BI Online, when I go to datasets >> security, there is no credential error, and it all works fine!

The only downside is that I'm having to introduce another gate or stage in the whole data flow, as follows:

One Drive >> Power BI Data Flow >> PowerBI Desktop >> Power BI Online

When, I'd have prefered

One Drive >> Power BI Desktop >> Power BI Online

As a result there is a chain of scheduled refreshes I need to set up

1) Power BI DataFlow - refresh at 6:00 am (refresh on demand takes about 5-7 mins)

2) Power BI Online - refresh at 6:30 am (refresh on demand takes about 3-5 mins)

With my preferred option, I'd only have had to do

1) Power BI Online - refresh at 6:30 am (refresh on demand taking about 3-5 mins)

If anyone knows of a solution to get my preferred option working, would be really grateful!

- ST

Re: Organizational account credentials from Power BI Server?

adumont — Tue, 13 Nov 2018 22:26:58 GMT

Not to be rude, but please stay on topic. This thread is about Power BI Report Server, not Power BI online service.

This thread is in the Report Server forum, not the Power BI Online Service forum. If you have a similiar issue to the one described here, please open a new thread in the correct forum for the correct product.

Please, do not hijack the thread with non related issues. Thanks.

Re: Organizational account credentials from Power BI Server?

sachintandon — Tue, 13 Nov 2018 22:34:29 GMT

Sorry about that.

The thread topic was so similar, that I didn't notice it was Power BI server. I found it via Google, so would probably blame Google's pagerank algorithm.

No intention to "hijack" the thread, as you word it.

Surprising though that it appears to be an issue on BOTH Power BI Server AND Power BI Online...so probably, and actually, still quite relevant!

Re: Organizational account credentials from Power BI Server?

mpsrshl — Wed, 20 Feb 2019 02:34:15 GMT

Hi,

Is there any solution to this issue?

Thanks.

Re: Organizational account credentials from Power BI Server?

Anonymous — Thu, 13 Jun 2019 14:05:14 GMT

This problem has been solved by Power Bi Team.

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

Re: Organizational account credentials from Power BI Server?

Anonymous — Thu, 13 Jun 2019 14:08:50 GMT

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.

Re: Organizational account credentials from Power BI Server?

mpsrshl — Thu, 13 Jun 2019 20:22:16 GMT

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?

Re: Organizational account credentials from Power BI Server?

Anonymous — Wed, 19 Jun 2019 10:20:40 GMT

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.

Re: Organizational account credentials from Power BI Server?

mpsrshl — Wed, 19 Jun 2019 20:33:11 GMT

You are right, nothing seems to have changed.

Re: Organizational account credentials from Power BI Server?

Anonymous — Wed, 10 Jul 2019 21:24:21 GMT

I'm also needing this functionality. Everything works well on Power BI Server, but on both Report Server and in my Data Gateway I don't have an option to use an organizational account. All of our data is on SharePoint and is locked up.

Re: Organizational account credentials from Power BI Server?

RobThrive — Thu, 14 Nov 2019 13:23:35 GMT

14-11-2019 and still a problem... WTF. It should just be so simple for Microsoft Power BI RS to connect to Microsoft Sharepoint and open up a Microsoft Excel file and pull the data in.

Re: Organizational account credentials from Power BI Server?

whereismydata — Mon, 25 Nov 2019 10:28:18 GMT

Also having this problem. Latest PBIRS (09/2019)

Re: Organizational account credentials from Power BI Server?

Anonymous — Wed, 12 Feb 2020 16:05:34 GMT

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