topic Re: Power bi in Report Server

Power bi

panduranga — Wed, 26 Mar 2025 13:37:34 GMT

Hello,
i have developed few reports in power bi using datasource as Postgres .After publishing the reports to workspace i am encountering the below error

Data source connection failed

Unable to connect to the data source . Either the data source is inaccessible, a connection timeout occurred, or the data source credentials are invalid. Please verify the data source configuration on the and contact a data source administrator to troubleshoot this issue.

Re: Power bi

bradsy — Wed, 26 Mar 2025 23:56:54 GMT

You most likely need to use a gateway once they are published. Here is one example for a PowerBI report with VNet Gateway. You can also search for Power BI Gateway and use that as well. https://powerbi.microsoft.com/en-us/blog/postgresql-connector-for-the-virtual-network-data-gateway/

Re: Power bi

v-nmadadi-msft — Thu, 27 Mar 2025 06:36:24 GMT

Hi panduranga,
Thanks for reaching out to the Microsoft fabric community forum.

Here is some information on On-Prem Data gateway

On-premises data gateway - Power BI | Microsoft Learn
and on Vnet gateway: What is a virtual network (VNet) data gateway | Microsoft Learn

Installation guide: Install an on-premises data gateway | Microsoft Learn
Document to help with any troubleshooting steps: Troubleshoot gateways - Power BI | Microsoft Learn

If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS. Feel free to reach out if you need further assistance.
Thanks and Regards

Re: Power bi

panduranga — Thu, 27 Mar 2025 07:00:25 GMT

Hi v-nmadadi-msft i have already installed On-premises data gateway status is online eventhough i was facing this error

Re: Power bi

v-nmadadi-msft — Fri, 28 Mar 2025 04:33:33 GMT

Hi panduranga,

Please verify the data source configuration settings
To verify the data source configuration in Power BI Service, start by navigating to Power BI Service and accessing Settings and then Manage Gateways. Ensure that the correct gateway is selected and that the data source credentials (username and password) are correctly entered. Additionally, confirm that the data source configuration matches the one used in Power BI Desktop, including the database name, connection details, and authentication method. Properly aligning these settings ensures seamless connectivity between Power BI and the data source.

Ensure that you've added one or more data sources correctly to the gateway, as described in Add or remove a gateway data source - Power BI | Microsoft Learn

As a final step, if all troubleshooting efforts fail, consider removing and re-adding the Power BI Gateway. Start by uninstalling the gateway, then proceed with a fresh installation and configuration. After reinstalling, ensure that you re-add your data sources and credentials correctly to restore connectivity and resolve any persistent connection issues.

If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS.
Thanks and Regards

Re: Power bi

v-nmadadi-msft — Mon, 31 Mar 2025 13:18:44 GMT

Hi panduranga,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

Re: Power bi

v-nmadadi-msft — Thu, 03 Apr 2025 16:31:58 GMT

Hi panduranga,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If our responses has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

Re: Power bi

v-nmadadi-msft — Mon, 07 Apr 2025 04:30:17 GMT

Hi panduranga,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the community members for the issue worked. If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Thanks and regards

Re: Power bi

panduranga — Thu, 10 Apr 2025 11:57:20 GMT

Hi bradsy Refered the link provided Thank you for it .Actually workspace Licence i have is Pro licence is it i need to change to Premium ? or any other solution Please help me

Re: Power bi

v-nmadadi-msft — Sun, 13 Apr 2025 18:32:16 GMT

Hi panduranga,
It is perfectly fine to use Gateway with a pro license. As the issue is still not solved I would suggest these steps
Please re confirm that the data source configuration matches the one used in Power BI Desktop, including the database name, connection details, and authentication method. Properly aligning these settings ensures seamless connectivity between Power BI and the data source.
As mentioned if all troubleshooting efforts fail, consider removing and re-adding the Power BI Gateway. Start by uninstalling the gateway, then proceed with a fresh installation and configuration. After reinstalling, ensure that you re-add your data sources and credentials correctly to restore connectivity and resolve any persistent connection issues.

If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS. Feel free to reach out if you need further assistance.
Thanks and Regards