Forum Discussion
Calculated column being cleared when loaded to powerbi.com
Community ChampionIf you edit the report in the service, create a table visualization and drop that column in there, what do you see?
The same. The data column appears to be empty.
A Count(distinct) on another column in the table shows a number = the number of rows in the table. (if that makes sense!)
- Greg_Deckler
Can you give me some sample data and the exact formula and I will try to replicate the issue, if I can, we should submit it as an issue.
This is completely bizarre.
I thought I'd found the answer when I discovered that the field I was using as Town was not marked as Category of Place. However even changing that to Place still led to the failure.
I made some changes to the script to use a different field for Town (internal reasons I won't go into here!) a week or two ago and I'm pretty sure it worked at the time, however if I change it back to the original field it works! AAAGGGHHHH!!!!!
I have placed all three fields (Original Town field, New Town field, Concatenated field) in a list on the Desktop and then exported it to Excel and there is NO DIFFERENCE between the two town fields!
This is what my debug page looks like on the Desktop
And this is what it looks like on the Service as soon as it has been uploaded and opened:
All three fields are defined as Text in the Query Editor and have the Place Data Category applied to them in the Visualisation panel.
I am completely flummoxed!
It's slightly difficult giving you sample data as the raw data lives on SharePoint lists and has some confidential data in it.
I can export some data to Excel but I'm not sure how to share that here.
- CahabaData
Memorable Member
I thought bing mapping - or any mapping for that matter - would need a stand alone country field.... not a string that contains other info.
