Can I use the Flow Execute a SQL query as a dataset for a PowerBi

[Frans1959]

Hello, everybody,

Can I use the Flow "Execute a SQL query" as a dataset for a PowerBi report? That would be very useful.

Of course I can link directly to the tables of an SQL server and use Transform Data. That works perfectly. 

But in a Flow "Execute a SQL query" I make in a few seconds a selection of a number of tables and records with a filter. 

and

Of course I can also use a Query on the SQL server as a dataset, but I prefer to solve it outside the SQL server.

The performance of such a Flow is fantastic!

Anyone have an idea? ThankYou

[lbendlin]

This would only work in two scenarios

1.  your Power BI dataset is a hybrid streaming dataset

2. you save the result of the SQL query to a CSV file and then point Power BI to that CSV file.

In either case you need to realize that there is no bulk capability in Flow.  You will need to loop through each row of your query result set and stuff that either into the streaming dataset or the CSV file.   None of this will be remotely fast. It will be agonizingly slow.

What's wrong with using a Direct Query dataset pointing to your SQL server query?

[Frans1959]

Dear Ibendin,
I don't have a lot of experience with SQL server and that's why I prefer to stay away from it. Therefore the work around with Flow. The Query's i can make in Access.

I understand that I cannot create a dataset for PowerBI from Flow.

For PowerApps I very often use Flow to retrieve data for a collection and that works very well and with a great performance.

Thank you very much,

All the best.