Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Analitika
Post Prodigy
Post Prodigy

How make double quotes in string in Power BI in advanced editor.

Hello,

How make double quotes in string like:

 

Source="adasda, "dad", sadasdadada". When I but double quotes getting error.

1 ACCEPTED SOLUTION
goncalogeraldes
Super User
Super User

Hello there @Analitika ! In Power Query, the escape character for a quotation mark inside a string is represented as ""(two quotation marks).

For example, a string containing a single quotation mark would be written as

"""" 

 

Hope this answer solves your problem! If you need any additional help please tag me in your reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️ or give it a kudoe 👍
Thanks!

Best regards,
Gonçalo Geraldes

View solution in original post

1 REPLY 1
goncalogeraldes
Super User
Super User

Hello there @Analitika ! In Power Query, the escape character for a quotation mark inside a string is represented as ""(two quotation marks).

For example, a string containing a single quotation mark would be written as

"""" 

 

Hope this answer solves your problem! If you need any additional help please tag me in your reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️ or give it a kudoe 👍
Thanks!

Best regards,
Gonçalo Geraldes

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.