CODEWITHSUNDEEP
azureazure-blob-storagepowerbiazure-cognitive-search
Roman Borovets
Roman Borovets

Reputation: 858

DataFormat.Error Power BI Desktop

I'm using Power BI for analyzing Azure Search statistics. The raw data is gathered on storage account (blob) by Search traffic analytics tool. To import date I've used this tutorial. But on applying query changes I'm getting error. enter image description here

Any ideas how to solve it?

Upvotes: 1

Views: 1172

Answers (1)

Berni
Berni

Reputation: 510

The invalid escape sequence is caused by unescaped backslashes () in the search terms of some queries.

See this question on how to create a power bi query that ignores the errors: Azure Search statistics Power BI

Upvotes: 2

Related Questions