Forum Discussion
Advocate IIGateway source doesn't update following refresh from desktop
hi PaisleyPrince
you need to add a new sql erver data source to the gateway nd enter the same values - Server, databasse , authentication, and credentials. and map your dataset to this new gateway entry and refresh the dataset. becausse powerbi service is caching the gatewaay mapping and it doesn't update automatically. downloading the newpbix shows the new server because powerbi ddesktop reads your actual model, not the gateway mapping.
Analytic Pulse Blog
Docynx Productivity Tools
Tool to Generate Realistic Sample Data Instantly online
Hi PaisleyPrince,
The issue happened because the original dataset in the Power BI Service was still holding on to an old, cached gateway connection, even though the PBIX had been updated. Some datasets refresh this connection automatically, but this one didn’t. When you saved the file as a new version (v2) and uploaded it, Power BI treated it as a brand new dataset, forcing it to recheck the data source and correctly match it to the new gateway.
Thanks & Regards,
Prasanna Kumar