Data in a Custom Column pulled from a Query disappears when pushed

[abarnett]

Hello! I am having issues with some data that doesn't hold when pushed into the online service. The data comes from a custom column that is pulled in a ODBC Query, and it works on the desktop file, but not in service. Attached are photos of the original desktop file with data in the column, and the downloaded file from the service. Any ideas to why  this would happen? From OnlineFrom Original File

[GilbertQ]

Has the dataset been refreshed in the Power BI Service?

[abarnett]

Yes it has, it was refereshed when I pushed it up. I refereshed it again and no luck. 

[GilbertQ]

That is interesting, are you using the latest version of the On-Premise Data Gateway?

[abarnett]

Looks like it isn't updated. Let me get this fixed. 

[GilbertQ]

Cool, I am hoping that there is a new DAX function that you are using in your PBIX that is not part of the On-Premise Gateway

The updated version should hopefully resolve this.

[abarnett]

Well I hope so, waiting for IT to help with this. They put it on a different computer than mine. 

[abarnett]

So far this seems to be the solution. But I said this last time I had this issue and it came back lol. 

[GilbertQ]

Hi @abarnett 

Hopefully this will resolve it

I do hope that they installed the Gateway on a seperate Server that can be managed by IT!

[abarnett]

@GilbertQ  It did not solve it sadly..it worked for a little but refreshed the data this morning and the data is gone again. No ideae why this continues to happen.