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

In this video, you will learn how you can fetch data from the power bi dataset into power apps.
Power Automate Code:
EVALUATE SELECTCOLUMNS(TOPN(10,Customer),"ID",[ID],"Product",[Product])
replace(replace(variables('vrCustomerRecords'),'[ID]','ID'),'[Product]','Product')
DAX Queries: learn.microsoft.com/en-us/dax...
---------------------------------------------------------------------------------------------------------------------------
Follow me on Twitter to get Office 365 updates:
Twitter:
/ sagarsharma94​
Gmail: [e-mail]
Facebook:
Join the Facebook group to collaborate with SharePoint Community
/ 52910​. .
---------------------------------------------------------------------------------------------------------------------------
Like, Share, and Subscribe to our channel for more informative and development-related videos. Much Love! Keep Learning! :)

[@jacobparker6460]

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

[@dstechmirror1396]

Glad it helped

[@piotrkuc8936]

Thank you!

[@carlosmagnosantossilva9920]

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

[@dstechmirror1396]

Glad to hear!!

[@viniciuscg12ba]

Amazing! Thanks

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

[@pablopapis]

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

[@aldorosenfeldjr]

Great content, thanks for sharing

[@mrutuber4496]

Thank you🎉❤

[@manouk691]

Wow, thank you!

[@dstechmirror1396]

You're welcome!

[@North2World]

Nice!

[@user-cd2hg1fg7s]

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

[@jdduf]

Many thanks for this tutorial! For the most part, this worked for me, but I found that my dataset is returning to PowerApps with a LOT of empty rows. Do you have any suggestions for getting the empty rows out? I attempted to filter these out in my PowerBI query but this didn’t change the results. Thank you!

[@mihirsoni3035]

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

[@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.

[@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?

[@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?

[@eduardodallabrida1976]

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

[@parranoic]

Replace [ with '' and ] with ''