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

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'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