Forum Discussion
Gateway issue with StrongDM suffix
Hi Bhargava_B - Power BI Service cannot be forced to recreate the data source identity.single pbix cannot be used when Desktop and Gateway must connect using different hostnames.this behavior is by design, not a bug.
Recommendation should be maintain two pbix files: for development you can Uses StrongDM alias (for local modeling). Once you move to production maintain another pbix ses the real SQL Server hostname (opened and published from a Gateway-accessible VM or jump box).This is the only fully supported and reliable pattern.
ref:
https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem-tshoot
Hope this helps.
Hello Bhargava_B
Parameters do not redefine this identity, and the Gateway binding relies exclusively on the persisted data source metadata.
As a result, using different hostnames for Power BI Desktop and the On-Premises Data Gateway is not supported for Import mode models.
The only supported approaches are developing on a gateway-accessible machine or maintaining separate PBIX files for development and publishing.