Error when pre-filtering data in Advance Editor

[Anonymous]

Hi, 

Having updated my version of Power BI desktop I'm now getting error messages on reports that have been working for the last year without issues. I'm unable to load data into any of my reports. 

The error I'm getting is 
Expression.Error: Invalid placeholder in format string.
Details:
Offset=1
Reference=0
Length=4

The error is occuring at my second line of code where filtering rows based on a particular field before Expanding the table. 

Source = DocumentDB.Contents("https://xxxxxx/", "CosmosDbName", "CollectionName"),
FilteredRows = Table.SelectRows(Source, each [Document][FieldName] = "xxxxxx"),
#"Expanded Document" = Table.ExpandRecordColumn(FilteredRows, "Document", {"Field1", "Field2", "Field3", "Field4",

[v-lili6-msft]

hi, @Anonymous 

If you could download a pbix file from power bi service and check if it works well.

No specific data for test, and if you could adjust the step in edit queries.

If you still have this issue for Power BI, you'd better create a support ticket in Power BI Support to get further help.

Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

submit a support ticket

https://community.powerbi.com/t5/Community-Blog/How-to-create-a-support-ticket-in-Power-BI/ba-p/683031?advanced=false&collapse_discussion=true&q=Scroll%20down%20and%20click%20%22CREATE%20SUPPORT%20TICKET%22.&search_type=thread

Best Regards,

Lin