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
• 18,570 points
4,120 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
• 52,360 points
0 votes

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

If you are interested in learning Power BI, check out Power BI Syllabus now!

answered Sep 25, 2018 by Nilesh
• 7,050 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,620 points
797 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
• 52,360 points
495 views
+2 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
• 7,050 points
5,415 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
• 52,360 points
760 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,130 points
989 views
+1 vote
1 answer

Unable to install connector for Power Bi and PostgreSQL

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

answered Aug 22, 2018 in Power BI by nirvana
• 3,130 points
2,446 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
• 18,570 points
1,125 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
• 52,360 points
1,024 views
+1 vote
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
• 52,360 points
1,417 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
• 52,360 points
1,731 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP