cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
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.
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
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 233 members 2,703 guests
Please welcome our newest community members: