cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CoboleiroBr Regular Visitor
Regular Visitor

Help using Flow

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:

Flow1.png

 

Everything ok in the first two steps, but when adding lines to a dataset I got an error.

 

JSON output:Flow2.png

 

Error:Flow3.png

 

My dataset in PowerBI:Flow4.png

 

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!

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
CoboleiroBr Regular Visitor
Regular Visitor

Re: Help using Flow

@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!

3 REPLIES 3
Super User
Super User

Re: Help using Flow

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.


Did I answer your question? Mark my post as a solution!

"Proud to be a Datanaut!"


Power BI Blog
v-jiascu-msft Super Contributor
Super Contributor

Re: Help using Flow

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
CoboleiroBr Regular Visitor
Regular Visitor

Re: Help using Flow

@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!

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 283 members 3,041 guests
Please welcome our newest community members: