Forum Discussion

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago

It's not a problem with the gateway. The problem is that you host the database on a machine that is inaccessible to the gateway.

 

Move the database to an accessible location.

  • nlgupta's avatar
    nlgupta
    Regular Visitor
    1 year ago

    Thanks for the response.

    The PostgreSQL database is hosted on AWS. I created the report on my local machine and fetched the data in Power BI using tunneling (due to project security restrictions), which mapped the database host to my localhost.

    After publishing the report to Power BI Service, I set up a Power BI gateway on an AWS Windows machine that has direct access to the database. However, I am unable to map the dataset to the configured gateway cluster (data source).

    Do I need to publish the report again from the AWS Windows machine for the gateway to work correctly? Or is there another way to resolve this issue?

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      1 year ago

      Use parameters to modify the connection string in the semantic model. 

      • nlgupta's avatar
        nlgupta
        Regular Visitor
        1 year ago

        Yes Got it, replacing localhost connect details with the help of parameters. also do have any reference link or article for updating data source details with parameters.

        Thank you