web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Power Automate - DAX Q...
Power Automate
Unanswered

Power Automate - DAX Query formatting

(0) ShareShare
ReportReport
Posted on by 10

Hello,

I'm having an issue with using a DAX Query in one of my flows. Here is the process :

I need to run a DAX Query on a Power BI dataset. So I create it in DAX Studio, format it to have indentation, line breaks, etc... and then I want to just have to copy paste it in the Query text part of the "Run a query against a dataset" action.

I create the query :

Antoine_C_0-1701957269973.png

 

But when I copy/paste it in the query text section, it goes from this :

Antoine_C_1-1701957364638.png

 and then I save, which turns the query into this :

 

Antoine_C_3-1701957449182.png

 

As you see, the line breaks are no longer here, and some key words are now concatenated (ex: DEFINEVAR), which breaks the query and fails the run.

Is there any way to avoid this behaviour and keep indentation as I have it originally ? I have tried putting the query in a variable but same thing happens.

Thanks a lot for your help.

Best regards



Categories:
I have the same question (0)
  • Verified answer
    ScottShearer Profile Picture
    25,270 Most Valuable Professional on at

    @Antoine_C 

    Have you tried correcting the query after you [paste it in?

    Also, have you tried reverting back to the original editor for Power Automate?

     

     

     

  • Antoine_C Profile Picture
    10 on at

    Hello @ScottShearer 
    I was trying to avoid to have to fix it everytime, so switching back to the original editor is a good workaround, thank you 🙂
    Hopefully this will be fixed in the new designer.
    Best regards

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard