Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 calculated columns and agrouping/summarizing within the query editor. In the desktop it refreshes perfectly, but after I upload the report to the web, the data credentials are failing to connect to the 3 sources. If I re-enter the credentials (oauth2) for the first connection it refreshes, but the two other fail, even if I use the exaclty the same credentials.
The following message appears:
I do have the latest version of the powerbi client. Do you have any advice, how to solve this problem? Are some features (e.g. grouping/summarizing in query editor) not available within the web? Is it not possible to connect to multiple data sources with PowerBI free?
Any help is appreceated. Thanks in advance.
Julian
Solved! Go to Solution.
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!
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
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
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
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!