Forum Discussion
abarnett
7 years agoHelper I
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...
GilbertQ
7 years agoSuper User
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?
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?
- abarnett7 years agoHelper I
GilbertQ It seems a custom column's data disapears once the refresh happens, do you think this would happen with a calculated column?
- GilbertQ7 years agoSuper UserThat 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.