Help using Flow

[CoboleiroBr]

Hello guys!

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.

JSON output:

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.

Any tips?

Thanks!

[CoboleiroBr · Accepted 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...

https://www.youtube.com/watch?v=B4dCLtQ53pA

Thanks!

[v-jiascu-msft]

Hi @CoboleiroBr,

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. 

Best Regards!

Dale

[GilbertQ]

Hi @CoboleiroBr

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.