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
sachintandon's avatar
sachintandon
Regular Visitor
7 years ago

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

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

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.

  • sachintandon's avatar
    sachintandon
    Regular Visitor
    7 years ago

    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!