DataFormat.Error Power BI Desktop

0 votes

I'm using Power BI for analyzing Azure Search statistics. The raw data is gathered on storage account (blob) by Search traffic analytics tool. I’ve imported the date. But on applying query changes I'm getting error:

Failed to save modification to the server. Error returned ‘OLE DB or ODBC  error: [DataFormat.Error] We found invalid escape sequence in JSON input.’

How do I resolve it?

Sep 25, 2018 in Power BI by Hannah
• 14,070 points
839 views

2 answers to this question.

0 votes
As the error says “found invalid escape sequence in the json input”, check your json input. Probably its some silly typing error.

If you’re not able to find the mistake post your json file.
answered Sep 25, 2018 by Kalgi
• 40,460 points
0 votes
The invalid escape sequence is caused by unescaped backslashes () in the search terms of some queries.
answered Sep 25, 2018 by Nilesh
• 6,880 points

Related Questions In Power BI

0 votes
1 answer

Power BI Desktop : Npgsql 3.0.3 error

You can fix this issue by installing the ...READ MORE

answered Dec 14, 2018 in Power BI by Upasana
• 8,530 points
77 views
0 votes
1 answer

Display power bi report on my desktop application

Power BI has a new feature called ...READ MORE

answered Sep 27, 2018 in Power BI by Kalgi
• 40,460 points
39 views
0 votes
2 answers

Power BI service throwing 403 error when using token to embed Power BI report

To add to @Kalgi's answer, Also make ...READ MORE

answered Oct 3, 2018 in Power BI by Nilesh
• 6,880 points
610 views
0 votes
1 answer

Install Power BI Desktop

It’s a pretty simple process. All you ...READ MORE

answered Oct 9, 2018 in Power BI by Kalgi
• 40,460 points
41 views
0 votes
1 answer

Displaying Table Schema using Power BI with Azure IoT Hub

Answering your first question, Event Hubs are ...READ MORE

answered Aug 1, 2018 in IoT (Internet of Things) by nirvana
• 3,060 points
79 views
0 votes
1 answer

Unable to install connector for Power Bi and PostgreSQL

I think the problem is not at ...READ MORE

answered Aug 21, 2018 in Power BI by nirvana
• 3,060 points
607 views
+2 votes
2 answers

Migrate power bi collection to power bi embedded

I agree with Kalgi, this method is ...READ MORE

answered Oct 11, 2018 in Power BI by Hannah
• 14,070 points
115 views
0 votes
1 answer

Programmatically sign in - power bi

Basically: POST request to: https://login.microsoftonline.com/common/oauth2/token Body, form-url-encoded: grant_type: "password" scope: "openid" resource: "https://analysis.windows.net/powerbi/api" client_id: ...READ MORE

answered Sep 19, 2018 in Power BI by Kalgi
• 40,460 points
82 views
0 votes
1 answer

Connect power bi desktop to dataset and create custom reports

Yes using Power BI REST API to ...READ MORE

answered Sep 18, 2018 in Power BI by Kalgi
• 40,460 points
110 views
0 votes
1 answer

How to publish .pbix report from power bi desktop to power bi service directly?

To save powerbi file directly to report ...READ MORE

answered Sep 27, 2018 in Power BI by Kalgi
• 40,460 points
226 views