Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! 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...
https://www.youtube.com/watch?v=B4dCLtQ53pA
Thanks!
@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!
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.