North Dakota Power BI User Group

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
  • 1.  PBI Query Export to CSV

    Posted May 15, 2018 02:23 PM
    Edited by Ryan Jockers May 15, 2018 02:27 PM
      |   view attached
    Using the code in the attached text file, you can export any query that you create in Power BI to csv. I use this when I need use Query within Power BI to do some large and/or complex processes and I need an output for something else other than visualization; or someone wants to see the data I am using to visualize with. As far as I know, there is no row limitation.

    It is a combination of a query function and an R script, steps below.

    1) Within query, Go to New Query>Blank Query
    2) Copy and paste the attached code into the Advanced Editor for the blank query
    3) You should now be able to use your new csv export query by choosing the other query you want to export along with the export path you want the file to go.



    ------------------------------
    Ryan Jockers
    Strategic Analytics Coordinator
    Bismarck
    7012242708
    ------------------------------​

    Attachment(s)

    txt
    export to csv.txt   1K 1 version