Forum Discussion

dinesh_jui's avatar
dinesh_jui
New Member
3 years ago

Refresh DataSet Issue on powebi service

hi team,

 

I am facing Issue while refreshing the datasets in powerbi service published from powerbi desktop. I first tried using Onpremise Data Gateway. In this, I setup the Onpremise Data Gateway and set it with my dataset. Here the issue is, it is doing the dataset refresh but I need to enable the VPN (which is used to access the private subnet azure postgresql server database). Incase, I am not enabling the VPN , then I am getting below error:
{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"ODBC: ERROR [08001] timeout expired\n"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"Odbc"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"dsn=PostgreSQL35W"}},{"code":"Microsoft.Data.Mashup.ValueError.OdbcErrors","detail":{"type":1,"value":"#table({\"SQLState\", \"NativeError\", \"Message\"}, {})"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}
My requirement is not to enable the VPN

The connection of Powerbi Desktop to Private Azure Database Server is made using psql odbc driver. 
Secondly, I also tried using Virtual Data Gateway. For this I followed the steps mentioned in official document given below:
https://learn.microsoft.com/en-us/data-integration/vnet/create-data-gateways.

 

Here I was able to follow all the three steps. After this when I am configuring the dataset with the virtual data gateway, it says it cannot be added to gateway 

 

When I click on this and try to create the connection for Virtual Data Gateway, it says that the credentials are invalid; which is false.
Could you please suggest me on this

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi dinesh_jui ,

    It seems like you are facing issues while refreshing the datasets in Power BI service published from Power BI Desktop. You have tried using On-premises Data Gateway and Virtual Data Gateway, but you are facing issues with both.


    Regarding the issue with On-premises Data Gateway, it seems like you need to enable the VPN to access the private subnet Azure PostgreSQL server database. If you do not enable the VPN, you are getting an error. If you do not want to enable the VPN, you can try the following steps:

    • Check if the firewall rules are configured correctly to allow access to the private subnet Azure PostgreSQL server database.
    • Check if the ODBC driver is installed correctly on the machine where the On-premises Data Gateway is installed.
    • Check if the connection string is correct and the credentials are valid.

    Regarding the issue with Virtual Data Gateway,you can try the following steps:

    • Check if the credentials are correct and have the appropriate permissions to access the data.
    • Check if the Virtual Data Gateway is installed correctly and is running.
    • Check if the connection string is correct and the credentials are valid.

    If it does not help, please provide more details.

     

    Best Regards
    Community Support Team _ Rongtie

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.