Forum Discussion
Issue with Data Source Connection in Power BI Service
Hi Anonymous,
If you are still unable to solve the issue you can reach out to Microsoft Support by raising a ticket with them.
Please refer below link on how to raise a contact support or support ticket.
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft LearnBest Regards,
Hammad.
Community Support TeamIf this post helps then please mark it as a solution, so that other members find it more quickly.
Thank you.
Hi Anonymous,
Thanks for reaching out to the Microsoft fabric community forum.
It looks like facing issue with your report being unable to access the data source. Usually PowerBI Service throws this error when it cannot establish a successful connection with the expected data source. As you have already mentioned you have taken some troubleshooting steps related to connection, version and permissions. This shows the issue is specific to report rather than a configuration issue.
As Anonymous already asked about the mode of semantic model as it is important to know because Power BI handles data connections differently based on the mode.
As you also said there's another report with similar settings which works fine. Then the issue could be related to:
* Dataset configurations (such as parameters or transformations),
* Gateway mapping specific to the report,
* Caching issues in Power BI Service,
* User roles and row-level security (RLS),
* Differences in report-level filters or query load patterns.
I would also take a moment to thank Anonymous, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real differe
If I misunderstand your needs or you still have problems on it, please feel free to let us know.
Best Regards,
Hammad.
Community Support Team
If this post helps then please mark it as a solution, so that other members find it more quickly.
Thank you.
The report uses a live Connection to an OLAP cube.
"As you also said there's another report with similar settings which works fine."
I had other report connected with different cubes, but settings are the same.
There is only one user, with admin role that use this report.
Hi Anonymous,
Thanks for confirming that your report uses a Live Connection to an OLAP cube. Since another report connected to a different cube works fine, the issue is likely related to that particular cube's connection rather than the general setup.
Thank you.
"the issue is likely related to that particular cube's connection rather than the general setup".
No, as I said I can see the report correctly but the client no, so it's not a problem of connection, I guessed permissions, but the client had the same settings of other cube and she have only problem with report connected with this one.
Anonymous talked about a cleaning permission option from power bi desktop. I didn't find this option. I asked for more details but I'm still waiting his answer.Hi Anonymous,
Thanks for the clarification, since you can see the report correctly but the client cannot, the issue is likely user-specific and related to either permissions, caching, or how the authentication token is being handled.
Anonymous might be referring to clearing cached credentials in Power BI Desktop. Your client can do it by going to Power BI Desktop then click on File -> Options and Settings -> Data Source Settings. There they have to locate the connection to the OLAP Cube and click Clear Permissions and re-enter credentials.
After that, make the client reopen Power BI Service and try accessing the report again.
Also make sure the client have effective permissions on the Cube. Even though the client has the same permissions as in other cubes, SSAS (OLAP) security can be schema-specific. They can check it by going to SSMS -> Connect to SSAS Instance -> Security -> Roles. Also make sure the client is explicitly listed with "Read" or "Full Control" access on this cube.
And also test the client’s access in incognito mode as sometimes, PowerBI Service caches authentication tokens, which can cause permission issues.
Best Regards,
Hammad.
Community Support TeamIf this post helps then please mark it as a solution, so that other members find it more quickly.
Thank you.