Using PowerApps Visual in Power BI (Integration)

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

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

50% 1

#PowerApps #PowerBI #PowerAppsVisual
In this video on Using PowerApps Visual in Power BI (Integration) we will use the PowerApps Custom visual in Power BI to add/update data in Microsoft Dataverse/CDS using Direct Query Mode.
The Power App will refresh the Power BI report instantaneously and provide a virtually unlimited refresh scenario. The Power BI report is using Microsoft Dataverse with direct query mode to not rely on scheduled refreshes or imports.
SharePoint Import Mode is also covered as part of this video.
Setup Dataverse for Direct Query
docs.microsoft.com/en-us/powe...
Direct Query Vs Import Vs Live Connection
docs.microsoft.com/en-us/powe...
• Power BI Get Data: Imp...
radacad.com/directquery-live-...
List of data sources and their supported refresh types
docs.microsoft.com/en-us/powe...

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

1 авг 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

@DanielChristian19 4 года назад

Well done, Reza! I like how you've used CDS entity to demonstrate the deep-integration between Power Apps and Power BI. I'm also glad you pointed out that SharePoint isn't a Direct Query data source, however, you can use Power Automate flow to refresh the Power BI report.

@RezaDorrani 4 года назад

Thank you Dan. Great point!

@chapysvp 3 года назад

Is there a tutorial that you know of that explains how to use Power Automate flow to refresh the Power BI report? I'm using SharePoint as my data source and would like to have it as "Direct Query", thanks

@ingridsfeeds4526 2 года назад

Last year I wrote in one of your videos that you're the best guy for power platforms. One year later, i must confess that not only i view the new video but also review the old ones because I always find sth relevant. You have no idea how you've been helping me. May god bless you even more 🤩

@RezaDorrani 2 года назад

Thank You so much for your kind words.

@DanielADamico 4 года назад

Reza, you're the best! Excellent demo! I think this integration is really awesome and it's a game-changer. Using Power BI as the main tool along with Power Apps integration only to perform CRUD, our apps are going to be much more analytical focused because Power BI is really powerful to perform complex calculations and build awesome data-driven visualizations....

@RezaDorrani 4 года назад

Thank you

@vladsamoilov897 Год назад

Reza, you are a savior! I was looking to expand PowerBI Integration in existing PowerApp and these small tricks are not covered on the web. I should've start straight with your videos. Thank you so much.

@RezaDorrani Год назад

Awesome! You may like this one as well ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-5y2jJyH4Eu0.html

@DimaDimaWydady 4 года назад

You simply have the best well thought out PowerApps videos. Thank you

@RezaDorrani 4 года назад

And I also have the most amazing viewers (hopefully subscribers) who give me such wonderful feedback. Thank you 🙏

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

Great great video Reza, watching now. Thank you so much!

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

Enjoy!

@estampacionesfuerte299 3 года назад

Your favorite word is definitely "Go ahead". Lost count of how many times you say it. But I will go ahead and say that your video is very informative. Thank you!

@RezaDorrani 3 года назад

😃 “Go ahead” and “Also” - I am trying to reduce the number of times I use these words.

@kadirkkkk 3 года назад

Great job man. None of the known youtubers explained that as you do.

@RezaDorrani 3 года назад

My goal always is to explain in simple way. Glad you liked the video.

@danoakhill4679 2 года назад

Great video Reza! Thank you for putting so much work into your content, you make learning the power platform a lot easier.

@RezaDorrani 2 года назад

My pleasure!

@stlaurent26 10 месяцев назад

3 years later still very helpful!

@RezaDorrani 10 месяцев назад

Glad to hear that! Thanks so much

@viniciuscamilo7139 3 года назад

Thank you so much man! You won part of my promotion!

@RezaDorrani 3 года назад

Glad I could help!

@dizhao4953 Год назад

Thanks! I saw many videos these days and this is the best one to explain everything clearly!

@RezaDorrani Год назад

Wow! Thanks so much

@saeedsm57 4 года назад

Thanks a million Reza! Fantastic demo!

@RezaDorrani 4 года назад

My pleasure!

@sultanSurya 3 года назад

I never know powerBI and powerapps combo is so powerful. Your demo is outstanding Reza 👌👏👏 and thank you

@RezaDorrani 3 года назад

Thanks for watching.

@RezaDorrani 3 года назад

Your are most welcome and thanks for watching

@farishta2008 3 года назад

Good work Reza. I was kind of working on the same effort. Your video has been helpful especially from direct query standpoint. Appreciate all your work.

@RezaDorrani 3 года назад

Thank you

@kartikwat 3 года назад

This is the most insightful and most underrated video ever on Power Apps and Power BI integration. Kudos to you brother 🙌

@RezaDorrani 3 года назад

I appreciate that! This video was one that never got its due. I had worked very hard in building this one. Thank you for watching.

@kartikwat 3 года назад

@@RezaDorrani it will pick up the traction soon. Sharing this vid among my network. Cheers 🥂

@RezaDorrani 3 года назад

@@kartikwat Thanks for sharing

@jacksonhz 2 года назад

Have to say, very good video in step by step , mentioning the reasons for the changes and their effects, appreciate the effort and sharing!

@RezaDorrani 2 года назад

Glad it was helpful! Thank you for the feedback.

@johng5295 Год назад

Reza, thanks in a million Genius! Very well explained. This is the best thing since slice bread + Power BI at a click of a button. This is the nth time that I am watching this again. Great content. Awesome. I couldn't find this explanation--simply put anywhere else. “Great teachers are hard to find”. Grade: A++

@RezaDorrani Год назад

Wow! Thank You so much for your kind words. I do have a newer version of this video which you may like. Check ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-5y2jJyH4Eu0.html

@nikolagrkovic8769 2 года назад

if this video alone wouldn't get me a fat raise and promotion, nothing will

@RezaDorrani 2 года назад

👍

@Ta-mq3wb 3 года назад

wow! so well explained and the concept i was looking for but didnt know how to Thanks!!

@RezaDorrani 3 года назад

You are most welcome

@oluwatobiyusuf 2 года назад

Another handy video. Thank you Reza

@RezaDorrani 2 года назад

Glad it was helpful!

@OneTrueKind Год назад

This is an amazing tutorial! Thank you Reza

@RezaDorrani Год назад

Most welcome

@rosieclancy5030 Год назад

Amazing video thank you!

@RezaDorrani Год назад

Most welcome! Thank you for watching

@hizke1 3 года назад

Thank you very much. You always do Interesting presentation!

@RezaDorrani 3 года назад

Thank you!

@artemburov9456 3 года назад

Hi Reza! Thanks a lot for the video.

@RezaDorrani 3 года назад

My pleasure!

@NYXthetherian11 2 года назад

i could not thank you enough!!! this is what i need!!! thank you so much!!!

@RezaDorrani 2 года назад

You're very welcome!

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

Thanks alot for this video :)

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

My pleasure!

@sundrapillay6668 4 года назад

Thank you

@RezaDorrani 4 года назад

Thank you for watching

@hemaeliraqy 2 года назад

Thank you, That's a great effort

@RezaDorrani 2 года назад

You are welcome!

@Mateusz_92 2 года назад

Great video, very useful informations!

@RezaDorrani 2 года назад

Thanks!

@andieoconnell4922 Год назад

Hi Reza! Great video, you always explain everything so well! Quick question, I am trying to create a multi-screen form, but am having trouble using "Defaults" on the Lookup formula. Any advice on how to patch together all my screens?

@RezaDorrani Год назад

I have done videos on multi screen forms and shown how to patch them. Search for that video on my channel.

@armstrongabebrese8310 2 года назад

great video

@RezaDorrani 2 года назад

Thanks!

@vinayayinapurapu 3 года назад

such a unique requirement and presented nicely. quick question? All the things related to Power BI reports you explained can be done with Power BI free licenses that comes with M365 (E1, E3, E5 etc) subscriptions?

@RezaDorrani 3 года назад

Power BI - for sharing the report users will need the E5 license or Power BI premium license or pro license or per user license.

@monojitpaul479 3 года назад

Many Thanks Reza for the demonstration. Can you tell if I can use same button to add and edit form in the same form control avoiding duplicate entry.

@RezaDorrani 3 года назад

Yes you can by changing the form mode depending upon the button selection. I have a video planned on form control that will explain all the basics. I also did a video on splitting large forms (it has the concept of the form mode in there). You can check it out here - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-9gI9OscTLD0.html

@csgexec 16 дней назад

Great video!

@RezaDorrani 16 дней назад

Works fine to date! I have not come experienced this and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

@raheelkhursheed6435 3 года назад

Hi Reza Thanks for sharing an excellent video. The last part of the video explaining about data refresh for the sharepoint list using the Power automate/PowerBI data source refresh within the power apps was skipped quickly and was not clear for me. Can you please point to any of your videos or blog which explains it in more detail?

@RezaDorrani 3 года назад

I do not have any other supporting video or blog. SharePoint does not support direct query. Hence we can use flow to refresh the dataset however we are limited to how many refreshes we can make based on licensing. Video description has all the supporting links.

@avinoamrothenberg1244 4 года назад

Raza, you're the MAN 😎 So, it seems that for heavy duty PowerBI querying the real answer is CDS (or SQL server, which I believe in the long run will have less and less use of). My query is, what type of PA license do I need to achieve this PowerBI-CDS-PA integration? will a Microsoft 365 be enough? or do I need one of the standalone plans (per user/per app)?

@RezaDorrani 4 года назад

CDS requires Power Apps premium licensing ( so does SQL ). Every user accessing the Power App would need the premium license. Also, for the PBI PA CDS combination, the user would also need a Power bi license

@avinoamrothenberg1244 4 года назад

@@RezaDorrani What PBI license will suffice? free/pro/premium?

@ivancuervo777 Год назад

Hello Reza! As always great video! quick question: If my existing powerapp has more than one screen, which will be displayed by default in PowerBI ?

@RezaDorrani Год назад

Landing screen to start with.

@bezen7808 2 года назад

Hi @ Reza!! Thank you! clear and awesome video as usual!! I have just built a demo following your guidance but with sharepoint online as the source. The only trouble now I'm facing is : how can you export BI service report which with embedded Powerapps , and import it to BI desktop report? Cuz normally a BI service report needs to be updated from BI desktop report , and unfortunately since Nov. the new version of BI desktop have trouble supporting building or choosing an existing app to embed (have reported this issue to MS). That's why I'm trying to build the embedded powerapps in BI service..but now don't see a way to import it back to BI desktop, any advice is appreciated!!

@RezaDorrani 2 года назад

I did notice a few issues raised on this on the forums. I'm not sure of what the fix is. Something that I would have to try out. I will recommend you check on the forums at powerusers.microsoft.com/

@bezen7808 2 года назад

@@RezaDorrani Thanks for your reply, I've downloaded completed version of BI desktop and enable preview feature: PowerBI desktop infrastructure update, then it works fine!

@RezaDorrani 2 года назад

@@bezen7808 Great 👍

@francescovalente301 3 года назад

very interesting :)

@RezaDorrani 3 года назад

Thanks for the visit

@lattie84 3 года назад

Reza, this is fantastic. I used this information to build me an powerapp that talks to sharepoint in Powerbi. I do have a question though; When I enter a new comment and the app saves the commentary to my sharepoint list, I get these icons in the commentary " and $nbsp:" each time. I changed the column setting in sharepoint to plain text but I keep getting those icons at the beginning and end of the commentary. Do you happen to know how to correct this so when I enter a comment, it will not do this when transporting to the sharepoint?

@RezaDorrani 3 года назад

I have not run into an issue related to nbsp. I will recommend you check on the forums at powerusers.microsoft.com/

@paolovr1970 2 года назад

Thanks Reza

@RezaDorrani 2 года назад

Most welcome

@user-lf1iq6to5c Год назад

Great tutorial, what is the preferred remedy if my data source has more than 2000 records and I'm getting the "Getting your Data..." message in my Powerapp? Also, I do not have access to direct query.

@RezaDorrani Год назад

I have not come across the issue for "getting your data" hence not sure what the remedy for it would be. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

@mahsaamiri9243 3 года назад

Thanks for the video, do you have any idea why i can't change my environment while i opening the power apps in the report?

@RezaDorrani 3 года назад

Not sure. You may not have access to those environments would be my guess. I will recommend you check on the forums at powerusers.microsoft.com/ in case anyone has run into a similar issue.

@Chubbs0804 3 года назад

Thank you! This video was easy to follow. A few questions. 1. if I add a trash icon what should my onselect formula be? I am having issues. 2. In my data verse that I am using to create my app to integrate with power bi. I have a choice option. In PowerBI it’s showing me the value instead of the name of the choice menu I selected. In power apps it shows me the name. What can I do to fix this? Thanks again for this video!

@RezaDorrani 3 года назад

1 - Remove(data source name, ThisItem) 2 - For choice columns in Power BI, you will have a name 2 fields for choice column, one which gives guid and other which gives name.

@Chubbs0804 3 года назад

Thank you! For some reason the name isn’t loading when I transform the data only the guid.

@RezaDorrani 3 года назад

@@Chubbs0804 Try posting your issue with screenshots on the forums at powerusers.microsoft.com/

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

Best tutorial as always! Just had one question : If I choose an existing app instead of creating a new one, will this existing app not interact with my Power BI filters and slicers? If no, how can I make it so that it interacts with the filters and slicers? Because I am having a pre built app which I just need to replicate for another Power BI report, and I don't want to create a new app from scratch. I just want to choose the existing pre built app and make sure it interacts with the Power BI slicers and filters.

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

Thanks! I believe that is a limitation. One option can be to build a new app and copy screens from old app to new one.

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

@@RezaDorrani thanks alot for the confirmation! How can we copy screens?

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

@@luffygear5362 Right click copy and paste :)

@suhaimiabdazais 2 года назад

Thanks Reza, this is what I'm looking for.. Integration between Power Apps and Power BI.. My next project, my boss is looking dashboard view on Power Apps instead of accessing Power BI. Preliminary question, if I'm the only one who has the license of Power BI, if my boss need to check the dashboard view via Power Apps (after shared).. It's my boss need to have Power BI license as well?

@RezaDorrani 2 года назад

Yes, every user accessing Power BI will need the Power BI license.

@avinoamrothenberg1244 4 года назад

BTW Reza, I didn't get it, regarding the CDS integration here. Does editing or adding data with the PA app actually update the data in the CDS entity?

@RezaDorrani 4 года назад

Hi Avinoam, The editing and adding data does indeed take place directly in the CDS entity. In the video within the Power App I do connect to CDS and then use the form control to submit data. In this video I leverage CDS as a data source. However the same concept works with any other data source - Sql, SharePoint etc.

@whdea3426 2 года назад

What an awesome video ! While implementing this via data verse DQ source , it is working successfully . Just one Q @reza , every time while I am updating a record from the power bi service , it is actually producing a new row altogether , however the thought process was to alter the existing row .Any comments on WHY this has been happening? Again many thanks for this video

@RezaDorrani 2 года назад

Update issue is because you are probably not connect to correct record context. My new video on this topic should have you covered. Check ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-5y2jJyH4Eu0.html

@josephlim2064 2 года назад

Hi Reza, Does the data row limit still apply for non-delegable data source like Excel when passing data into Powerapps from Power BI this way? Thank you.

@RezaDorrani 2 года назад

Data row limit (data coming from power bi dataset) is limited to 1000 for any data source.

@alexaroberto900 2 года назад

Hi Reza!, thanks a lot! actual in my power apps dosen't permit use Select(Parent);Navigate. It dosent´t recognize Navigate and (;). Do you know why? thanks

@RezaDorrani 2 года назад

Mostly, it is a syntax issue on your side. I will have to look at your App in action to provide any guidance. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com

@farishta2008 3 года назад

Also, wondering if i have to limit this to a certain section of audience using row level security. Can you demonstrate that in a session.

@RezaDorrani 3 года назад

In Power BI, if you implement RLS, the same would also apply to the data in Power Apps as the PowerBIIntegration object will pass the data from Power BI to Power Apps and respect RLS.

@farishta2008 3 года назад

@@RezaDorrani Thank you

@whdea3426 2 года назад

Hey, Thanks Reza for another awesome video. My Power Bi source is Azure Cosmos , can i use the same for this purpose in place of MS Dataverse

@RezaDorrani 2 года назад

My guess would be Yes but have not tried it. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

@carlosgomez-df9cg Год назад

Spectacular!!!. Thank you!.. I have a question. I followed your instructions to show in my PBI the comments entered by the users in an HTML LABEL, but in PBI they are seen with a very small font size if the user enters a long text and is displayed in a 16PT font size if the entered text is short. Can a fixed font (16 PT) be assigned regardless of the size of the entered text?

@RezaDorrani Год назад

Thanks. I have not tried with html hence not sure if there is a way around it. I’ll recommend posting your query on forums at powerusers.microsoft.com

@carlosgomez-df9cg Год назад

Ok. Thank you.. Other Question I published the PBI when the PowerAPPs forms is embedded. But when an user with rigths over the PBI try to use the powerApps an error is showed because the user is not authorized to use the PowerApps. I can't find where it can be setup?. do you know?

@RezaDorrani Год назад

@@carlosgomez-df9cg You have to share the App with user

@nanma8903 2 года назад

QQ, in this power app/power bi integration, is dataverse the only DB option for direct query/instant refresh? Or sql server also works? Thx!

@RezaDorrani 2 года назад

You can use any data source of your choice. Check ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-5y2jJyH4Eu0.html

@creativeluf 3 года назад

Great job Reza. I launched the template file but it says "Unable to parse data source file. The given data source reference is not a valid data source". Also, How can I upgrade my environment if mine is earlier than 9.1.0.17....

@RezaDorrani 3 года назад

Hello Isaacs, Please work with your IT Team. I have not tried this so be sure to check every aspect and backup your environment. Upgrade CDS environment - powerapps.microsoft.com/en-us/blog/upgrade-your-previous-version-common-data-service-database-apps-and-flows/#:~:text=Upgrade%20your%20database%2C%20apps%2C%20and,and%20an%20Upgrade%20now%20button. Not sure about your data source file issue. It may be related to the environment upgrade.

@LapaConsult_Ex_Macraris 2 года назад

Hello Reza and thank you again for this insightful video. I have gone through everything and I was able to replicate all what you demonstrated but one thing I cannot find answer about is how to change the timezone in powerbi service. In the gallery the date shows in UTC time in label control which is different from my local time. In the form however it shows correctly because i set the date control Timezone in Local. Let's say that in PowerApps everything show as it should but in PowerBi date is shown in UTC; Any ideas?

@RezaDorrani 2 года назад

Check community.powerbi.com/t5/Desktop/Date-Field-Time-Zone-Fix/m-p/402509

@assyabassya007 2 года назад

Hi Raza, Thank you very much for the helpful video!!! Around min 19-21 in this video… in Screen2 / EditForm1 you setup Item = LookUp(Power_Devices,Name = Gallery1.Selected.crc05_name). Can you please explain the logic here? Why you have Name and at the end "crc05_name", i.e. specific data column name? Tried to reperform that step but don’t understand why you have Name = and if I put a specific data column from my data source (it’s a SharePoint List) I have error "Delegation warning. The highlighted part of this formula might not work correctly with column "Name" on large datasets". Any idea how to solve this? You have another video or article explaining this setting? Appreciating your advice! Assya

@RezaDorrani 2 года назад

Check ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-5y2jJyH4Eu0.html

@assyabassya007 2 года назад

@@RezaDorrani Thanks a million, Reza! And sorry for misspelling your name.🙈 The formula from the video you sent me works - am so happy! 😁 Unfortunately, the order in which I see the Power BI items is not in the same order as the items in the embedded PowerApp window. Suspect the order in PowerBI report is alphabetical and the order in PowerApps is per the Id number via which I connect to my data source. You came across such problem too? Any idea (video) how to solve that? Your new fan 👍, Assya

@RezaDorrani 2 года назад

@@assyabassya007 I have not come across this issue. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com/

@assyabassya007 2 года назад

@@RezaDorrani Will deal with this at later phase. Your videos were inspirational and what I managed to do with your help now works. Much appreciated! 👍👌

@johanynavarro8065 2 года назад

As usual amazing video legend!!! A question... How to navigate to another page when an item is selected on a list in Power BI? for instance... I select an item on a list on Page 1 and navigate to Page 2 which includes a PowerApps edit form... I think that would be a good one legend

@RezaDorrani 2 года назад

Thanks for liking the video. I am not sure how would one do that. I would have to try it out to learn if there is a function which does that. I will recommend you check on the forums at powerusers.microsoft.com/

@johanynavarro8065 2 года назад

@@RezaDorrani I'm trying it Reza, if I manage to do it will let you know regards from Malta

@samp_sampath9493 11 месяцев назад

Thanks for this video Reza. We've a button and Launch("mailto:") logic is opening an outlook email In powerapps which is working fine In a standalone powerapps environment. But when we embed the same visual to power bi report, it doesn't work. Any ideas or limitations here? Thanks.

@RezaDorrani 11 месяцев назад

Embedded power apps have limitations. This could very well be one of them. Not something I have tried hence not sure of a workaround

@samp_sampath9493 11 месяцев назад

@@RezaDorrani OK thanks!

@raj7sam Год назад

Grt video. One doubt, will power apps will fetch more than 2000 items from PowerBI integration data?

@RezaDorrani Год назад

@atulyadav1159 Год назад

Hey, I am saving my canvas app and then publishing and refresh the powerbi report also but canvas app does not update in powerbi nothing happens but if i create new power app and select choose app and instead create new everything working fine but when i try to edit the canvas app by selecting edit option from powerbi (which you mentioned in the video) all the information is blank (title, subtitle, etc)

@RezaDorrani Год назад

I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

@Lagging69 4 года назад

Love you, sir. This is exactly what I have been looking for. I want to make a PowerApp containing game heroes/characters and then on click of a hero I want to filter out report data of that particular hero stats or abilities. I could do this within Power BI only but I am not sure if I can use images as filtering options on Power BI

@RezaDorrani 4 года назад

Glad you found this video useful

@barnakovacs2339 3 года назад

Hi Reza! How do I delete a record? Very beautiful video!

@RezaDorrani 3 года назад

Add delete icon in gallery and on select of it Use remove(thisItem) and then refresh the power bi data set

@SuperBigben8 3 года назад

I think you are not right when you say that the number of refresh will be limited at 33:50. The limit is only applied to schedule refresh (Pro = 8 refreshes per day for example) but not to On-demand refresh. I can read that on the microsoft website : "It is also important to call out that the shared-capacity limitation for daily refreshes applies to both scheduled refreshes and API refreshes combined. You can also trigger an on-demand refresh by selecting Refresh now in the dataset menu, as the following screenshot depicts. On-demand refreshes are not included in the refresh limitation."

@RezaDorrani 3 года назад

That's correct. I was referring to the fact that SharePoint does not support direct query so refreshing the visuals using PowerBIIntegration.Refresh() from Power Apps will not work in case of SharePoint and one will be limited to x number of refreshes per day . One would have to schedule the refreshes or use flow to do so.

@ent8619 Год назад

Hi Reza Nice and detail video Thanks for that Still i m unable to have the power bi data columns in power app Is there any property that I can write and fetch the columns

@RezaDorrani Год назад

I will have to look at your App in action to know the cause of your issue. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

@atulyadav1159 Год назад

Hey, I am using DirectQuery and using PowerBiIntegration.Refresh() but still my powerbi visuals are not updating i have to manually refresh the powerbi report.

@RezaDorrani Год назад

Not sure why that would be the case. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

@mangeshpg 3 года назад

Hi, How did you connected data source to Form in the screen 2 which you added, when i searched my data source which i connected to power bi, it is not appearing there (Data source of Form).

@RezaDorrani 3 года назад

Yes. I am actually showcasing a similar scenario Live tomorrow. You can join me here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-0BuCpZMvhws.html

@mangeshpg 3 года назад

@@RezaDorrani thanks looking forward for your session.

@jaysizmir9432 2 года назад

Can we get, in Powerapps, the value that was sent to filter the gallery (case where the value doesn't exist, so the gallery shows zero row but i still want to get the value sent) ?

@RezaDorrani 2 года назад

It does not give the filter value. It only provides the data set.

@jaysizmir9432 2 года назад

@@RezaDorrani Thank you for the quick answer king

@masgitz 3 года назад

What's maximum list size to make cds? Is it 30M items also?

@RezaDorrani 3 года назад

It can as long as you have the storage capacity - docs.microsoft.com/en-us/power-platform/admin/capacity-storage

@kittydoes7600 2 года назад

Wow this is great! thank you for this. Is dataverse has versioning feature as well similar to Sharepoint? I'd like to create an app that shows historical changes on columns/fields and use dataverse as my data source so I can also use Direct Query. Is it possible with Dataverse?

@RezaDorrani 2 года назад

Dataverse Auditing - docs.microsoft.com/en-us/powerapps/developer/data-platform/auditing-overview#:~:text=Dataverse%20supports%20an%20auditing%20capability%20where%20table%20and,all%20custom%20and%20most%20customizable%20tables%20and%20columns.

@kittydoes7600 2 года назад

@@RezaDorrani thank you so much for the quick response. Do you have tutorial on auditing? 😊

@RezaDorrani 2 года назад

@@kittydoes7600 I do not

@collin428 Год назад

Hi Reza, excelent vodeo, I really love it. I got some problems. When Powerapps Connect to powerbi and got the PowerBIintegration. I built a data table in powerapps and everthing is fine. But once I close the powerapps(I already saved and published it) and open the apps again, every table number is gone.I used PowerBIIniegration.Refresh(), still miss all data. Did you have this experience before, any solution for that?

@RezaDorrani Год назад

I will have to look at your App/dashboard in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

@roopalawasthi2794 Год назад

Hi Reza , I am unable to add new columns in Powerapp though I tried the method suggested by you. Can you please let me know what could be the possible reason ?

@RezaDorrani Год назад

I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

@janurbanek1127 Год назад

can you somehow leverage the Pbi pages in order to navigate to screens within powerapp ? I have a multipage PowerBi report and I want to leverage only one PowerApp, but I want it to reflect the data that is on the given page of Pbi. Is that possible?

@RezaDorrani Год назад

Power BI data is passed as a whole and not page wise. I don’t believe there is any such option.

@kushagramishra2648 2 года назад

Using powerbiintegration.refresh() function my visual is taking so long time to load the data .....does anyone has answer of this?

@RezaDorrani 2 года назад

The timing depends on a lot of factors Amount of data, number of visuals, license etc. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has run into something similar.

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

Hi Reza, power app license required for this?? I can create power app but power bi integration code is not working for me. Please suggest

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

Yes, power app license needed. I have not come across any issues with integration code. I will recommend posting your issue on forums at powerusers.microsoft.com/

@jancarlosascencioacuna9182 2 года назад

Can I use power bi Embed with a Power Apps visualization ?

@RezaDorrani 2 года назад

I believe so. However, Power Apps would require user to sign in & a license.

@vishaljhaveri7565 2 года назад

Hello Reza sir. Can we embed specific screens(not all) of the Power apps to Power BI? Please reply sir. Thank you.

@RezaDorrani 2 года назад

I don't think so that is possible

@vishaljhaveri7565 2 года назад

Yes, it's not possible sir. I tried my best. Can you please make a video on WordPress vs Power Apps. @@RezaDorrani

@RezaDorrani 2 года назад

@@vishaljhaveri7565 Wordpress is not something I am an expert on. I make videos when I get many requests of a similar topic. This is the first one on this topic.

@yashpalsingh5106 3 года назад

Hello Reza , this is excellent Demo , I am trying to do CRUD opertation Azure Data explorer , but in second screen my data source and entity is not appering , though i am trying to edit through power BI , however first read only screen is working perfectly , it would be great if you plz help me here

@RezaDorrani 3 года назад

For that I would have to look at your code base. Your best bet will be to post your query with screenshots on the community forum at powerusers.microsoft.com/t5/Building-Power-Apps/bd-p/PowerAppsForum1

@rst5285 3 года назад

Hello Reza, thanks for the great video. I have one question: How can i get a value from my PowerBI Dataset as default value in a NewForm Textbox. Thanks for your response.

@RezaDorrani 3 года назад

Power BI sends a array of data to Power Apps (your dataset + any filters if applied to dataset). You would need user to first select a single record from Power Apps, either via gallery or data table and then you can use that single record context, get the value you need from it and set it to Default property of your textbox.

@rst5285 3 года назад

@@RezaDorrani Thanks for the fast response. This is a very bad user experience because my Power BI Report is filtered by one Customer, so i want to add a new entry for this customer via Power Apps. I dont want do be select this customer in der Power App. Is there any other option?

@RezaDorrani 3 года назад

@@rst5285 In that case just use First(PowerBIintegration.Data).colname and you should get the value.

@rst5285 3 года назад

@@RezaDorrani Thanks this works but only if i have at least one Record in my SQL Table. If i started with one customer that hat no item added, the textbox remains empty. The PowerBI ist still filted by one customer.

@RezaDorrani 3 года назад

@@rst5285 I would have to look at your app to provide further guidance. Difficult to do so here on chat. I will recommend you post your issue with screenshots on the forums at powerusers.microsoft.com

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

Hello, When I refresh the PowerBI Visuals I loose the selected record. Is there a way to refresh PowerBI but also not loose the selected record in a table?

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

You could maybe be save a variable that has context of selected record and use that variable as selected record

@rayanroque4269 Год назад

How to remove the "PowerBIIntegration" from the PowerApp located at the Screen Tree View? (PowerApps)

@RezaDorrani Год назад

Why would you want to remove that? Entire concept is based on that object.

@vamshikommineni1647 2 года назад

I have imported data from SharePoint as you did but am unable to perform refresh.Its showing "your data source can't be refreshed bcoz credentials are invalid.Where do I correct the credentials? Pls provide me solution

@RezaDorrani 2 года назад

In data set settings. I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

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

How do i connect to a table that was created in power apps? I don't see it as an option in the list of data sources.

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

A table in power apps would be created in dataverse. You need to ensure its in same environment as the app.

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

@@RezaDorrani do/can individuals have different environments from the business account that the individuals account is made from?

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

@@neiljavier7116 I do not understand your question

@selwynvanrooyen9432 2 года назад

When i click on 'Edit' to edit my Powerapps from PBI, it just says "getting things ready" on the next webpage

@RezaDorrani 2 года назад

I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

@daniel92man 2 года назад

Same here. I didn't manage to open Power Apps from within Power BI. Has it got sorted?

@RezaDorrani 2 года назад

@@daniel92man I dont think anything has changed. Make sure you are adding power apps from the power bi service and not desktop. Check ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-5y2jJyH4Eu0.html

@jreyesvega 3 года назад

How I can embed the mobil view to the app in my phone.

@RezaDorrani 3 года назад

I did not understand the question

@jreyesvega 3 года назад

@@RezaDorrani Create the mobile version of the power bi report, but I can't place it inside my mobile app. I can only link the report and open it from the external power bi application.

@RezaDorrani 3 года назад

@@jreyesvega I believe that is a limitation. I am not a Power BI expert so I may not be the best person to answer this. Try posting your query on the Power BI forum - community.powerbi.com/

@kadirkkkk 3 года назад

Just an extra info: For both powerBI dateset refresh and dateset refresh via power automate refresh you can only use 8 times a day. so poor :( after 8 times you get an error message for dateset refresh

@RezaDorrani 3 года назад

That is true for datasets in import query mode. I believe you can go up-to 40 refreshes per day with additional licensing.

@erangadharmarathne861 Год назад

how the power app works in mobile phone?

@RezaDorrani Год назад

App will need to run in context of power bi only.

@avinoamrothenberg1244 4 года назад

Sorry for misspelling your name. It's REZA of course 😖

@RezaDorrani 4 года назад

@hugomancera9330 2 года назад

What if the PowerBIIntegration it doesn´t get created? how can I force it to get created?? I have press the new app button and also the choose an app button and the PowerBIIntegration function is not showing up in the Power Apps Studio.

@RezaDorrani 2 года назад

There is an ongoing bug with this feature. I read about it on the forums. Are you trying this on Power BI Desktop? Try on Power BI browser (web).