Forum Discussion

mnatarajan's avatar
mnatarajan
New Member
1 year ago
Solved

Connecting aws rds postgreSQL via PowerBi Network Gateway Adapter from PowerBI Premium workspace

Hi,    I want to connect to Powerbi premium Workspace to postgreSQL RDS hosted in aws. Having issue to connect to AWS PostgreSQL RDS from PowerBi Premium workspace.   Following steps were taken i...
  • v-sdhruv's avatar
    1 year ago

    Hi @mnatarajan ,
    Just wanted to check if you had the opportunity to review the suggestion provided?

    If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it.
    Thank You

  • mnatarajan's avatar
    1 year ago

    Thank you for the quick response. Yes, it worked with a few tweaks done. 

     

    1. I installed the npgsql 4.0.16 msi, i couldn't find the other MSI version like 4.0.10 etc
    2. The default path for npgsql.dll is under "C:\Windows\Microsoft.NET\assembly\GAC_MSIL\Npgsql\v4.0_4.0.16.0__5d8b90d52f46fda7\Npgsql.dl
    3. gautil runs only from developer command prompt via Visual Studio, i was not aware of this but figured it out. 

     

    Rest everything works good as expected, the connection was successful from PBI desktop to Workspace, and report was published. Only thing, i noticed after publishing the reports from powerbi desktop to workspace, next to the semantic model it shows: Processing error: We are unable to access some data source because the artifact is missing connection details. Please contact the artifact owner to bind the data source to a data connection or use default connection settings for the unbound data source. with the cluster uri, activity id etc. Another thing, if we open the report using the option like analyze report in excel, there it shows an error like data source unreachable, there is no gateway to access to data source, but gateway connection was successful both in gateway adapter and in workspace configuration using db server, credentials etc. Please let me know if you have any additional information for this error.

     

  • mnatarajan's avatar
    1 year ago

     

    1. Installed the npgsql 4.0.16 msi, i couldn't find the other MSI version like 4.0.10 etc
    2. The default path for npgsql.dll is under "C:\Windows\Microsoft.NET\assembly\GAC_MSIL\Npgsql\v4.0_4.0.16.0__5d8b90d52f46fda7\Npgsql.dl
    3. Used gautil command to register the GAC
    4. gacutil /i " C:\Windows\Microsoft.NET\assembly\GAC_MSIL\Npgsql\v4.0_4.0.16.0__5d8b90d52f46fda7\Npgsql.dl’”
    5. gautil runs only from developer command prompt via Visual Studio, i was not aware of this but figured it out. 
    6. Copied npgsql.dll to the gateway directory manually.
    7. With the above steps, it worked and gateway can connect to the rds and workspace configuration can connect to the rds.
    8. Rest everything works good as expected, the connection was successful from PBI desktop to Workspace, and report was published. Only thing, i noticed after publishing the reports from powerbi desktop to workspace, next to the semantic model it shows: Processing error: We are unable to access some data source because the artifact is missing connection details. Please contact the artifact owner to bind the data source to a data connection or use default connection settings for the unbound data source. with the cluster uri, activity id etc. Another thing, if we open the report using the option like analyze report in excel, there it shows an error like data source unreachable, there is no gateway to access to data source, but gateway connection was successful both in gateway adapter and in workspace configuration using db server, credentials etc. Please let me know if you have any additional information for this error.