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

Подписаться 8 тыс.

Просмотров 19 тыс.

50% 1

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: contactdstechmirror@gmail.com
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! :)

Наука

Опубликовано:

8 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 24

@carlosmagnosantossilva9920 5 месяцев назад

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

@dstechmirror1396 5 месяцев назад

Glad to hear!!

@jacobparker6460 5 месяцев назад

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

@dstechmirror1396 5 месяцев назад

Glad it helped

@aldorosenfeldjr 8 месяцев назад

Great content, thanks for sharing

@viniciuscg12ba 8 месяцев назад

Amazing! Thanks

@mrutuber4496 2 месяца назад

Thank you🎉❤

@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 11 месяцев назад

@@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 2 месяца назад

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

@user-cd2hg1fg7s 26 дней назад

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

@North2World 9 месяцев назад

Nice!

@manouk691 Месяц назад

Wow, thank you!

@dstechmirror1396 Месяц назад

You're welcome!

@jdduf 4 месяца назад

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!

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

@mihirsoni3035 5 месяцев назад

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

@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 2 месяца назад

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

@vodias2007 8 месяцев назад

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?