Forum Discussion

Workener's avatar
Workener
Frequent Visitor
9 years ago
Solved

Data source credentials fails with multiple sources

Hello,   I have created a Report within the PowerBI desktop with three odata sources (1 SharePoint List, 2 Tables from Project Online). The report does not use functions or parameters, just some ca...
General Comment
Need Help
  • Workener's avatar
    Workener
    9 years ago

    Hi,

     

    I opened a ticket at Microsoft. It was a temporary problem of the tenant, so everything was setup in the right way.

     

    Thanks anyway!

     

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
9 years ago

Hi Workener,

 

As far as I know, there is no restrictions on connecting to resource. Could you please check the following.

1. Do you mean Project online is Microsoft Project online?

2. There should be two credentials like this.

 

 

 

 

 

 

 

 

 

 

 

 

3. How about changing the authentication method?

4. Did you use a function to fetch the data from Project Online? or Odata?

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale

Workener's avatar
Workener
Frequent Visitor
9 years ago

Hi Dale,

 

1. I mean Project Online OData api.

2. There are 3 credentials (the first one for the SharePoint list works fine, the other two throw the error message above):

3. I tried to login with other authentification methods, but cannot get access. It is not a security problem within Project Online because I can enter the odata feed within the browser without troubles.

4. I do not use any functions, just some statements in the query editor (like grouping):

 

In the meantime I assigned myself a Pro license - same problem again, but I was able to narrow it down a little bit further.

 

Seems like I have a general problem to connect to Project Online Odata datasources within this tenant. I did create some demo reports and are facing the same issue. If I connect to a different tenant, the connection works properly. The security settings from the data sources are exactly the same, also the security within Project Online.

 

Can this be related to a central O365 setting of the tenant?

 Any further advice?

 

Best regards,

Julian

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    9 years ago

    Hi Workener,

     

    I think you are right. It seems the problem is caused by authorization (different tenants). 

    1. Which way did you use to authenticate the connection? It's Organization account in this document.

    2. Could you please try to connect to Project online with a content pack in the Service as a test? Reference: powerbi-content-pack-project-online.

     

    Best Regards!

    Dale

    • Workener's avatar
      Workener
      Frequent Visitor
      9 years ago

      Hi,

       

      I opened a ticket at Microsoft. It was a temporary problem of the tenant, so everything was setup in the right way.

       

      Thanks anyway!