Forum Discussion
Power BI Gateway Not Refreshing Dataset Due to Localhost Mapping
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.
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?
Use parameters to modify the connection string in the semantic model.
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