Forum Discussion

Anonymous

Not applicable

9 years ago

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...

Anonymous

Not applicable

9 years ago

Expanding two fields doesn't work either.

I'm pretty sure this is an issue with the Service. How do I report that?

Icon for Microsoft Employee rank

Microsoft Employee

9 years ago

Anonymous

Could you please describe this issue more clearly? Which .csv file you shared can be used to repro it? If you can provide the detailed repro steps, I can try to repro it locally and help to report it.

Best Regards,

Herbert

Anonymous
Not applicable
9 years ago
Hi!

The issue is that the query itself (see the code above) actually uses a SharePoint list. I think the issue is with this command:

#"Expanded SupportOffice" = Table.ExpandRecordColumn(#"Changed Type", "SupportOffice", {"Centre"}, {"Centre"}),

It is therefore pretty well impossible to give anybody access to the data I am using, particularly as much of the data is confidential.
v-haibl-msft
Microsoft Employee
9 years ago
Anonymous

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
Not applicable
9 years ago
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