Forum Discussion

wshalex123's avatar
wshalex123
Helper III
3 years ago

Run a query against a dataset, create .csv

 
Hey,

... i didn't get any help in the Power Automate community, so i'll try it here:

 

Whereever i look, this should work for everyone accept me haha. I Just want to get a .csv table out of my PowerBI table.

 

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

 

 

Results of the flow:

 

 

Question:

Why doesn't it seperate it in two columns? Instead, it seperates the entries with a comma ","

In DAX editor it's seperating the results in 2 columns, like i'd wish it to be in my .csv file.

 

What am i doing wrong?

Would be happy if someone can help me out. 🙂 

Need Help

5 Replies

  • ImkeF's avatar
    ImkeF
    Community Champion
    3 years ago

    Hi wshalex123 ,
    csv is a comma separated text format, so the result looks as expected to me.
    When openening it in Excel, you can split it by this delimiter: Go to DAta -> Data Tools -> Text to Columns 
    and then choose the comma as a separator.
    Or open it via Power Query, that's a bit more reliable.

    • wshalex123's avatar
      wshalex123
      Helper III
      3 years ago

      Hey ImkeF,

       

      thanks you for your response. 

       

      Iam deleting this file once per day and save it again there via this flow, so a Solution in Power querry would be fitting more in my case.

       

      Can you help me with this? 🙂 Or do you have any other idea how i could automattically export the table from Power BI in another table or make in change it in one?

       

      Thanks a lot. 

       

      Cheers, Alex

      • jbwtp's avatar
        jbwtp
        Memorable Member
        3 years ago

        Hi wshalex123,

         

        I think what Imke is suggesting is to import the csv file that you create using the Automation via Power Query in Excel.

         

        on the Data tab in the Excel's main menu.

         

        P.S. Sorry, in your case this is of course would be another connector - Sharepoint Folder - but the idea remains the same.

         

         

        This way you can then import it from PQ to one of the tabs in the Excel workbook as a table and then just refresh when required.

         

        Cheers,

        John