Anyone used Flow to refresh a dataset in Power BI?
I've created a new flow using a recurrent time (each 5 minutes), to get rows in SQL Server and update a dataset in Power BI, this way:
Everything ok in the first two steps, but when adding lines to a dataset I got an error.
My dataset in PowerBI:
Observation: I'm getting only the column "cod_solicitacao" from the table, but how the output written these two other columns, I put them in the dataset definition, but I got the same error.
Go to Solution.
@v-jiascu-msft and @GilbertQ, thanks for your answers!
This was my first time testing Flow and I had not associated the selected column to the respective field in the dataset.
I found this cool tutorial where I could see where was the problem...
The first thing that I would ask is to ensure that the data types from SQL Server and then after you modify the data are the same as what is set in your Streaming data set?
Then it appears in your image that there are possibly 4 columns whilst in the json below it only has 3 rows.
According to my test, the other two columns will be null if they can't be fetched from the database. Maybe you should check the number of the fields of your table and the dataset as @GilbertQ said.
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.