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

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

 

 

  • Annemie's avatar
    Annemie
    Frequent Visitor
    7 years ago

    Did you pick Oauth2 in powerbi online ?

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