Get Data from Power BI Dataset in Power Apps | Power BI and Power Apps

[@jacobparker6460]

My friend you are true hero. Thank you so much.

[@dstechmirror1396]

Glad it helped

[@carlosmagnosantossilva9920]

meu caro, você realmente fez a diferença hoje pra mim. Obrigado!

[@dstechmirror1396]

Glad to hear!!

[@rodrsturge663]

Very helpful. If you have lots of columns just replace the brackets with nothing. replace(replace(variables('myVariable'),'[',''),']','')

[@rodrsturge663]

That is actually a little messy, because then you have to add back the [ at the start and the ] at the end of the collection for the parser to work.

[@Havegoogday06]

@@rodrsturge663 Im bringing like 30 columns from my pbi dataset, do i need to do the replace function for every single one of them? :O

[@pw_extravaganza]

this is quite simple to add brackets and the beginning and the end: concat('[', concat( replace(replace(variables('varDataAsString'),'[',''),']',''),']' ))

[@JaimeGarcia-fj5by]

Hi, i had any problems, for example, in the power automate, I can´t to assig "string" type to the "Initialize variable" Object. I had to put in the "compose" object the next code: concat('[', replace( replace( join(variables('MS_ARTICULOS_2'),','), '[',''), ']',''),']') with this, in power app, don´t show a error in the PARSEJSON.

[@aldorosenfeldjr]

Great content, thanks for sharing

[@mihirsoni3035]

thanks for the informative video! btw is there any way to store the data coming here to a new /existing sharepoint list ?

[@manouk691]

Wow, thank you!

[@dstechmirror1396]

You're welcome!

[@matusjakubcin2765]

Hello . Thanks for material - based on that i was able to create sucessfully Power automate flow and then read data in Power apps via on select button ( instead of ID i am using mail , and under ''vrCustomerRecords'' it reads correctly mails from my Power BI report. ) . However later i do not have option : ,, Parse JSON function and untyped objects ,, available in settings. Could it be a problem ?...when i use ,, collData on properties for Gallery , it shows me no data then . Thanks in advance for response.

[@mrutuber4496]

Thank you🎉❤

[@viniscera-97]

Amazing! Thanks

[@piotrkuc8936]

Thank you!

[@nishaboby6213]

do we have to make the triggers separately ? I couldnt find the powerapps trigger.

[@vodias2007]

This flow will work for any user other than me? I mean, if I share my App to other users but not share my PowerBI dataset, they will be able to query my dataset?

[@benoymammenmathew825]

Hi DSTechMirror, insightful video. How do I filter the data in the power BI dataset, i tried taking an input from the Power Apps and passing it into to the DAX formula, however I am running into an error 502 code in Power Apps. Could you make a video on this as well?

[@North2World]

Nice!

[@MahaduMukir-k1j]

Can you please upload a video showing how to use an edit form in Power Apps with a Power BI dataset?

[@eduardodallabrida1976]

my data type "Table"....is it possible to work with this format?

[@parranoic]

Replace [ with '' and ] with ''