Forum Discussion

Anonymous's avatar
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...
Need Help
Anonymous's avatar
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's avatar
v-haibl-msft
Icon for Microsoft Employee rankMicrosoft 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's avatar
    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