Gateway problem - multiple datasets - data is missing

[Anonymous]

Hello world,

I have a problem regarding various different data sets.

They are all connected to a Gateway fetching data from the same MySQL databases.

Data is being pulled, crunched and shown on the desktop level.

When upload, the data is still shown.

After the Gateway refresh, the data is missing.

Once this happens with a collumn from the MySQL db directly. Here the data type is being changed in Power Query.

The other incident is with an added collumn (in Power Query), which afterwards is being counted in a measure.

Similar processes work.

When the step of "changing data type" in query is removed, upload and tested it works. Therefore the mistake might lie somewhere here.

Gateway is up to date and working on other datasets.

Would be very grateful for any help.

All the best

DesktopWeb

[lbendlin]

Sounds like the credentials you use on the gateway have other (fewer) rights than the credentials you use on the desktop ?