Forum Discussion
Automate Export of PowerBI table to SQL Server
You will find that the Power Automate SQl connector is a premium connector. It has no support for bulk operations. They expect you to pull and push individual rows. Good luck with that.
To add insult to injury, Power Automate has some ridiculous message and file size limitations. Any normal sized Power BI dataset is too much for these limits.
Thank again. Yes it does seem strange that a product with such rich capabilities to automate intake and transformation has very limited ability to automate export for consumption downstream. I'm still a big fan of the product.
Power BI was positioned as a reporting tool. That is purely a one way street - ingest data and display it. There was never a plan to make it an ETL tool, like SSIS. (Incidentally the same is true for VBA - it was never intended for ETL but it's being used for that since forever)
Only very recently have the Power BI designers caught on to the "new" trend of business decision support which doesn't stop at looking at pretty charts - it requires you to take your insights and do changes in your process based on them, ie "write back".
There's a crude way of doing it with the Power Apps visual, and there are even more crude ways of abusing the R scripting abilities to do these writebacks.
It's a big question - should Power BI stay focused on data consumption and reporting, or should it become part of the business decision cycle?