Export PowerBI Desktop and PowerPivit Tables Directly to SQL Tables

jeckste

You can also try to use R scripts to export data from Power BI back to SQL, please refer to links below:

http://www.thebiccountant.com/2015/12/28/how-to-export-data-from-power-bi-and-power-query/

http://stackoverflow.com/questions/19190744/how-to-quickly-export-data-from-r-to-sql-server

*Note: R visuals in Power BI Desktop has a few limitations.

1. Data size limitations – data used by the R visual for plotting is limited to 150,000 rows. If more than 150,000 rows are selected, only the top 150,000 rows are used and a message is displayed on the image.
2. Calculation time limitation – if an R visual calculation exceeds 5 minutes the execution times out, resulting in an error.

Best Regards,

Herbert