Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Refreshing in PBI Service changes data significantly

Hello everybody,   I am having issues with one of my datasets. I did some minor changes on it for a report I wanted to build; afterwards I published the dataset. At first there was no problem, I bu...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hello v-cherch-msft,

     

    thank you for answering. I was able to resolve the problem by now: I did not format the column containing the data in the query editor. When loaded into the dataset, it was auto converted to a text value - I do not know why this did not cause problems in PBI Desktop as one would expect, but only after refreshing via Service; anyway, properly formatting the column resolved the issue.

     

    Regards

    Moritz

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hello v-cherch-msft,

 

thank you for answering. I was able to resolve the problem by now: I did not format the column containing the data in the query editor. When loaded into the dataset, it was auto converted to a text value - I do not know why this did not cause problems in PBI Desktop as one would expect, but only after refreshing via Service; anyway, properly formatting the column resolved the issue.

 

Regards

Moritz

CogoraBI's avatar
CogoraBI
New Member
6 years ago

I just came across this issue in a similar situation, was tearing my hair out for 2 days!

 

Knew it would be something simple like this. Thanks for solving.