Forum Discussion
Power bi
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.
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
9 Replies
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/
Hi panduranga,
Thanks for reaching out to the Microsoft fabric community forum.
Here is some information on On-Prem Data gatewayOn-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 RegardsHi v-nmadadi-msft i have already installed On-premises data gateway status is online eventhough i was facing this error
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
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.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
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
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
