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  Nope no Parameters, double chekced to be sure. 

GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
7 years ago
Hmmm I am not sure what else could be affecting the change then.

The only thing I could think of is once it has refreshed on the Power BI Service, if you download that version of the PBIX and compare the differences between the 2 PBIX files?
  • 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.