Forum Discussion
Issue with Data Source Connection in Power BI Service
Hi Power BI Community,
I'm experiencing an issue with a report in Power BI Service that I'm hoping someone can help me resolve. The error message states, "The report was unable to access the data source. Contact the author to correct the error."
Here are the steps I've taken so far to troubleshoot the issue:
Checked Permissions: The user accessing the report has the necessary permissions for both the workspace and the OLAP cube (data source).
Configured Data Gateway: The data gateway is connected and online.
Verified Connection: The connection to the data source is active and functioning.
Updated Power BI: While the issue is with the online service, I've ensured that I am using the latest version of Power BI Desktop as well.
Author Verification: I am the author of the report and I've tried to correct the error, but I can't identify the root cause.
Interestingly, I recently created another report with similar settings and didn't encounter this issue.
Additionally, when I connect to Power BI Service, I can see everything correctly, but the client is experiencing the mentioned issue.
Could anyone provide insights or suggestions on what might be causing this error and how to fix it?
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.
15 Replies
Hi Anonymous,
If you are using Direct Query, there are few troubleshooting steps you can follow and see if this resolves your issue.
* You can check if the gateway mapping is correctly configured in the Power BI Service. Go to manage
gateways and there check the Data sources for mapping of the report.
* Confirm that the user has permissions on the data source itself.
If I misunderstand your needs or you still have problems on it, please feel free to let us know.
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.
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 TeamIf this post helps then please mark it as a solution, so that other members find it more quickly.
Thank you.
Hi Anonymous,
As we haven’t heard back from you, so just following up to our previous message. I'd like to confirm if you've successfully resolved this issue or if you need further help.
If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.
If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you for your patience and look forward to hearing from you.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.