I want to use Power BI dataflows from Microsoft Flow.
for share data
and for use Power Query like SQL Server connector
Currently: SQL Server connector can Transform data using Power Query
Being able to automate department level jobs outside of a full fledged ETL tool would be a game changer for many organizations whose users deal with datasets smaller than the 1,048,576 row limit within Excel. Simply being able to automate a Power Query job stored inside of an Excel file would also be a huge step forward with adoption of both Power Query and Flow.