Forum Discussion

abarnett's avatar
abarnett
Icon for Helper I rankHelper I
7 years ago

Measure doesn't work when Data Set Refreshes

Hello! I have a measure that on desktop, works great. When I publish to service, everything also works great. But when the data refreshs on the service, through the on-demand refresh the measure does...
Need Help
abarnett's avatar
abarnett
Icon for Helper I rankHelper I
7 years ago

GilbertQ  It seems a custom column's data disapears once the refresh happens, do you think this would happen with a calculated column?

GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
7 years ago
That should not happen on a calculated column

I would suggest always creating the column in the Query editor, it allows for better compression and faster refreshes.
  • abarnett's avatar
    abarnett
    Icon for Helper I rankHelper I
    7 years ago

    GilbertQ  I prefer creating it in the Query too..but this is where it is already and for some reason the refresh is erasing that data.

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    7 years ago
    Hi there

    The refresh will only apply the steps that it has in the PBIX, I have never seen anything deleted by the refresh process.

    I would suggest comparing the PBIX files to see the difference.
  • abarnett's avatar
    abarnett
    Icon for Helper I rankHelper I
    7 years ago

    I didn't do anything but the issue is now resolved for some reason.

     

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    7 years ago

    That is really interesting, glad that it now is working!