Power bi to sql

Hi,

I am looking for ideas on how to get rows from power bi dataset (PBI web service. Not PBIX) to sql table using Microsoft flow or any other solution. The need is automation of the process. 

I tried but the flow failed.