Desktop Versus Web Different Data

[brendanaus]

Hi everyone. I'm new to this forum and hoping you can help me. I have setup a new Power BI PBIX file on Server 2012 R2 connecting to an ODBC datasource as System DSN. The data pulls in nicely into the desktop application. 

My issue arises when publishing to the web. I can log in to the web application and use the "Get Data" option. This connects fine and the data matches the desktop version. However if anything changes on the desktop version it will not refresh on the web. .I have tried connecting both the standard gateway and personal gateways but no luck. They both showed up as connected in the Gateway Connections section when logged in. 

I feel like I have exhausted most angles at this stage and would really appreciate some troubleshooting assistance. Thank you in advance!

[v-yulgu-msft · Accepted solution]

Hi @brendanaus,

"However if anything changes on the desktop version it will not refresh on the web"

Power BI esktop does not synchronize Power BI service. After publishing report to service, any change in desktop won't reflect in service. You have to re-publish the report to service to overwrite the original one.

"I have tried connecting both the standard gateway and personal gateways but no luck. They both showed up as connected in the Gateway Connections section when logged in."

The aim to configure gateway for data source, is to update data displayed on report page, which reflects the change to data in data source, rather than in desktop.

Best regards,

Yuliana Gu