web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Run a query against a ...

Power Automate

Unanswered

Run a query against a dataset

(0) Share

Report

Report

Posted on by wshalex123

160

Hey,

i got a flow where i a table out of my Power BI report and save it as a .csv in a Sharepoint folder.

This is my query text:

DEFINE
VAR _ma1 =
SUMMARIZECOLUMNS(
"Urlaub", SUM(PersonnelManagement_EmployeeDayBalances[Offene Urlaubsstunden]),
"Zeitausgleich", SUM(PersonnelManagement_EmployeeDayBalances[Offener Zeitausgleich])
)
EVALUATE
_ma1

-> I researched the web a lot and imo the query text should be correct.

Results:

Question:

Why doesn't it seperate it in two columns?

In DAX editor it's seperating the results in 2 columns...

Would be happy if someone can help me out 🙂

Categories:

Using connectors

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

lbendlin 8,726 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
This is working as designed . (you can simplify it by
EVALUATE SUMMARIZECOLUMNS( "Urlaub", SUM(PersonnelManagement_EmployeeDayBalances[Offene Urlaubsstunden]), "Zeitausgleich", SUM(PersonnelManagement_EmployeeDayBalances[Offener Zeitausgleich]) )
Your next step (Csv-Tabelle erstellen) is converting the result of the DAX query into a table. Make sure you specify the right column separator.

Was this reply helpful? Yes No
wshalex123 160 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @lbendlin,

thanks for you help. How do i change the delimiter in the "create csv" action? There aren't any dynamic values here

Was this reply helpful? Yes No

Join the conversation