How can we improve Power BI?

Allow Power Query to Export Data

Allow Power Query results to be written back to a flat file or SQL table.

Relivant forum thread:
http://community.powerbi.com/t5/Integrations-with-Files-and/Can-PowerQuery-write-data-back-out/m-p/1747

630 votes
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

Henson shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

26 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • KA commented  ·   ·  Flag as inappropriate

    Great idea!
    Why not use the same "Transform UI" for your Datawarehouse ETL experience?
    And use CDS-A / Data Flows as storge.
    Or add Power Query to Azure Data Factory / Azure DW, ...

  • Daniel Otykier commented  ·   ·  Flag as inappropriate

    Power Query is an incredibly powerful ETL tool. Opening it up, so that it could be used to load data outside of Excel/Power BI/SSAS Tabular would probably make it the best ETL tool in the WORLD! This is a must!

  • Sebastian Roling commented  ·   ·  Flag as inappropriate

    Yep, Powerquery is my preferred ETl tool but i still revert to other ETL tools whenever i need the output in a SQL table or csv. Please add this feature.

  • Andrew commented  ·   ·  Flag as inappropriate

    PowerBI (and Power Query) is getting very close to Killer App status. This would move it along that pathway significantly. There is limited use in a tool that can take data from almost anywhere, perform almost any transformation and then not externalise the result.

    Note that a lot of other suggestions on this site also arguably would be satisfied by taking this on - and so I feel this feature is under-represented in vote count.

  • Anonymous commented  ·   ·  Flag as inappropriate

    If Microsoft turned the Mashup engine into a data service and allowed people to turn Mashup queries into a data source via API to integrate into other systems, it would change everything.

  • BA commented  ·   ·  Flag as inappropriate

    this needs to happen! especially for large datasets (> 1M)

  • Mimoune Djouallah commented  ·   ·  Flag as inappropriate

    I use dax studio as a workaround, using dax query and export to a text file, i have test it with a 3 Million records and it works very well

  • Anonymous commented  ·   ·  Flag as inappropriate

    As with others, we think PowerBI can be the silver bullet, the BI slayer, if it writes back data to SQL Server.

  • Shaun Loughlin commented  ·   ·  Flag as inappropriate

    This is a must have function for me. Power BI is so close to being my complete data management solution but if I can't get the data back out then it's impossible!

  • Dave Schmidt commented  ·   ·  Flag as inappropriate

    This is a definite need. As others note, there are workarounds but they are really only effective with a small amount of data. Being able to easily export data (especially into a flat file format) is often requested by my users and would be a very welcomed enhancement!!!

  • Antoine Chamba commented  ·   ·  Flag as inappropriate

    Yes, this would make it way more versatile.

    For now you can export it to PPivot, and either:
    - Copy paste it into excel (small volumes, but anything within bare excel limitations with a good enough computer)
    - Use a macro to dump it into a csv. It crashes with large volumes though (> 5-10 Go).

← Previous 1

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.