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

Power BI streaming dataset turn columns to rows

Hello everybody,

 

Im a newbie.

I wanna know if i can turn my columns in my streaming dataset to rows.

 

and how can i achieve this?

I created a streaming dataset in Power BI that will be filled with answers from Microsoft forms. but the table is not the right output for the visual.

 

Regard,

C

12 REPLIES 12
ChristianAbata
Super User
Super User

hi @cbouichi  please see the example.

In the last part you need to add the squema that your PowerBI generates

powerbi.PNG



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

i did already,

 

But it will generate for each squema row a column.

i want as an output a table that contains one column filled with different answers.

I cant transpose the table in BI so i hope flows will do the trick.

 

Knipsel.JPG

 

So i tried to put al the answers with a numeriek score in one squema.

it generate a table with all the numeriek answer like this. 15734

 

And i need it like this

1

5

7

3

4

 

I hope i explained it good

 

@cbouichi  mm not complete but if you need to create a table first you need an array like this { 'Num' : '1', 'Num' : '2', 'Num' : '3', 'Num' : '4'} the use that output to create html table.



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

Hi @cbouichi ,

 

You could refer to screenshot below to create the flow:

1.png

And you could add 5 append to Array variable action in the flow for your 5 questions.

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Knipsel.JPG@v-alzhan-msft 

 

That looks good.

 

i end up with the following message;

BadRequest. The 'from'property value in the table action inputs is of type string. the value must be of type array

 

Knipsel.JPG

 

I try this with no luck

Hi @cbouichi ,

 

The error message told that the variable is String type and not the array type.

Please make sure that you have created the variable with Array type.

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@v-alzhan-msft 

 

Im still struggling.

 

Knipsel.JPG

 

the form should be an array, right?

 

I tried to play with the columns option but no succes still, hope you got more advice for me.

When i edit the Create HTML table advance option columns field.

Knipsel2.JPGThis is the outputThis is the output

Hi @cbouichi ,

 

Please don't create the HTML table with custom field:

 
 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

 

@v-alzhan-msft i change it too compose,

 

the flow runs succesfully,

Knipsel3.JPG

but the output isn't the desired outcome

Knipsel3.JPG

it should be like this i think;

["0"],

["1"],

 i think this because this is the outcome in power bi.

Knipsel3.JPG

 

Hi @cbouichi ,

 

Yes, and I'm afraid that there is no any other better solutions.

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events happening this month - don't miss out!

 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (2,437)