So I know that PowerQuery is great for consuming and transforming data, but are there any export options? If not, what's the least klugey way to get data out of a BI model and into SQL tables, or a CSV?
Solved! Go to Solution.
Yeah, it's just that we're often dealing with very, very large datasets.
There's no way to pull a data model into access is there? I'd say that we could take our workbook and pull it into Tabular Services, but I don't think on-prem SQL Server can refersh Power Query.
Thanks! If it gets approval, you can find it here:
With the December update you can use the workaround via R to export your data from Power BI to txt or SQL-server: http://www.thebiccountant.com/2015/12/28/how-to-export-data-from-power-bi-and-power-query/
You can use SSIS to connect to Power BI desktop and use SSIS to export the data to wherever you like.
The method described here: http://biinsight.com/connect-to-power-bi-desktop-model-from-excel-and-ssms/ can be used as well to connect from SSIS.
another option that does not require any third party is to use powershell, i tried the vba approach and it does not work with large data, R works very well, but in some environement it may not be available
the script is here
This is brilliant mim !!!
Re size-limitations: Change the export-format to txt (instead of csv) and these size-limits are gone 🙂
Thx a ton!
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!