Forum Discussion
Anonymous
9 years agoNot applicable
Calculated column being cleared when loaded to powerbi.com
I have a calculated field that comprises of the town a property is in with ", England" appended to the end to enable me to map the number of properties in each town on a Map. This was working fin...
v-haibl-msft
Microsoft Employee
9 years agoAnonymous
Could you enter some random data into a excel file with same table structure as the SharePoint table, then get data from this excel file and use the command which can cause this issue to repro it? If it can be done, you can share the excel file which contains the sample data to me to repro it locally.
Best Regards,
Herbert
Anonymous
9 years agoNot applicable
Hi!
Unfortunately that's not possible. The reason we have the structure we have is because we are using linked SharePoint tables.
I don't think we can reproduce that in Excel.
Thanks for your help.
Ian