cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
abarnett Regular Visitor
Regular Visitor

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

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 Online.jpgFrom OnlineOriginal.jpgFrom Original File

9 REPLIES 9
Super User
Super User

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

Has the dataset been refreshed in the Power BI Service?

Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Power BI Blog
abarnett Regular Visitor
Regular Visitor

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

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

Super User
Super User

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

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

Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Power BI Blog
abarnett Regular Visitor
Regular Visitor

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

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

Super User
Super User

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

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.

Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Power BI Blog
abarnett Regular Visitor
Regular Visitor

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

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

abarnett Regular Visitor
Regular Visitor

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

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

Super User
Super User

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

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!


Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Power BI Blog
abarnett Regular Visitor
Regular Visitor

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

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

Helpful resources

Announcements
Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 121 members 1,494 guests