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.
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.