Using PowerApps Visual in Power BI (Integration)
Рет қаралды 101,056
Күн бұрын#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...
@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
@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
@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.
@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 kzfaq.info/get/bejne/a99ina2qrZqppWQ.html
@DimaDimaWydady 3 жыл бұрын
You simply have the best well thought out PowerApps videos. Thank you
@RezaDorrani 3 жыл бұрын
And I also have the most amazing viewers (hopefully subscribers) who give me such wonderful feedback. Thank you 🙏
@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.
@viniciuscamilo7139 3 жыл бұрын
Thank you so much man! You won part of my promotion!
@RezaDorrani 3 жыл бұрын
Glad I could help!
@padmabairoju433 2 күн бұрын
Great great video Reza, watching now. Thank you so much!
@RezaDorrani 2 күн бұрын
Enjoy!
@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!
@dizhao4953 Жыл бұрын
Thanks! I saw many videos these days and this is the best one to explain everything clearly!
@RezaDorrani Жыл бұрын
Wow! Thanks so much
@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.
@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
@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.
@stlaurent26 9 ай бұрын
3 years later still very helpful!
@RezaDorrani 9 ай бұрын
Glad to hear that! Thanks so much
@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 kzfaq.info/get/bejne/a99ina2qrZqppWQ.html
@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
@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
@NYXthetherian11 2 жыл бұрын
i could not thank you enough!!! this is what i need!!! thank you so much!!!
@RezaDorrani 2 жыл бұрын
You're very welcome!
@hizke1 3 жыл бұрын
Thank you very much. You always do Interesting presentation!
@RezaDorrani 3 жыл бұрын
Thank you!
@OneTrueKind Жыл бұрын
This is an amazing tutorial! Thank you Reza
@RezaDorrani Жыл бұрын
Most welcome
@oluwatobiyusuf 2 жыл бұрын
Another handy video. Thank you Reza
@RezaDorrani 2 жыл бұрын
Glad it was helpful!
@nikolagrkovic8769 2 жыл бұрын
if this video alone wouldn't get me a fat raise and promotion, nothing will
@RezaDorrani 2 жыл бұрын
👍
@artemburov9456 3 жыл бұрын
Hi Reza! Thanks a lot for the video.
@RezaDorrani 3 жыл бұрын
My pleasure!
@rosieclancy5030 Жыл бұрын
Amazing video thank you!
@RezaDorrani Жыл бұрын
Most welcome! Thank you for watching
@sapnatekchandani8121 3 ай бұрын
Thanks alot for this video :)
@RezaDorrani 3 ай бұрын
My pleasure!
@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.
@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 - kzfaq.info/get/bejne/b815bLKkyLqwdGQ.html
@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!
@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.
@sundrapillay6668 4 жыл бұрын
Thank you
@RezaDorrani 4 жыл бұрын
Thank you for watching
@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.
@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 👍
@lamenlatimore4471 2 жыл бұрын
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 2 жыл бұрын
I have not run into an issue related to nbsp. I will recommend you check on the forums at powerusers.microsoft.com/
@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.
@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/
@mahsaamiri9243 2 жыл бұрын
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 2 жыл бұрын
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.
@francescovalente301 3 жыл бұрын
very interesting :)
@RezaDorrani 3 жыл бұрын
Thanks for the visit
@paolovr1970 Жыл бұрын
Thanks Reza
@RezaDorrani Жыл бұрын
Most welcome
@armstrongabebrese8310 2 жыл бұрын
great video
@RezaDorrani 2 жыл бұрын
Thanks!
@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
@luffygear5362 4 ай бұрын
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 4 ай бұрын
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 4 ай бұрын
@@RezaDorrani thanks alot for the confirmation! How can we copy screens?
@RezaDorrani 4 ай бұрын
@@luffygear5362 Right click copy and paste :)
@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.
@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.
@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
@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
@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 kzfaq.info/get/bejne/a99ina2qrZqppWQ.html
@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.
@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.
@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
@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
@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.
@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 kzfaq.info/get/bejne/a99ina2qrZqppWQ.html
@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
@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
@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
@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
@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.
@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 kzfaq.info/get/bejne/a99ina2qrZqppWQ.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! 👍👌
@samp_sampath9493 10 ай бұрын
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 10 ай бұрын
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 10 ай бұрын
@@RezaDorrani OK thanks!
@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
@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
@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
@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
@mangeshpg 2 жыл бұрын
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 2 жыл бұрын
Yes. I am actually showcasing a similar scenario Live tomorrow. You can join me here: kzfaq.info/get/bejne/ZqildtOLstzMp6c.html
@mangeshpg 2 жыл бұрын
@@RezaDorrani thanks looking forward for your session.
@rthoughts7232 Жыл бұрын
Grt video. One doubt, will power apps will fetch more than 2000 items from PowerBI integration data?
@RezaDorrani Жыл бұрын
No
@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
@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
@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
@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.
@jithiljohn2961 3 ай бұрын
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 3 ай бұрын
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.
@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.
@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
@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.
@michaels1813 Ай бұрын
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 Ай бұрын
You could maybe be save a variable that has context of selected record and use that variable as selected record
@rayanroque4269 11 ай бұрын
How to remove the "PowerBIIntegration" from the PowerApp located at the Screen Tree View? (PowerApps)
@RezaDorrani 11 ай бұрын
Why would you want to remove that? Entire concept is based on that object.
@neiljavier7116 Ай бұрын
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 Ай бұрын
A table in power apps would be created in dataverse. You need to ensure its in same environment as the app.
@neiljavier7116 Ай бұрын
@@RezaDorrani do/can individuals have different environments from the business account that the individuals account is made from?
@RezaDorrani Ай бұрын
@@neiljavier7116 I do not understand your question
@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/
@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
@erangadharmarathne861 Жыл бұрын
how the power app works in mobile phone?
@RezaDorrani Жыл бұрын
App will need to run in context of power bi only.
@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.
@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 kzfaq.info/get/bejne/a99ina2qrZqppWQ.html
@avinoamrothenberg1244 4 жыл бұрын
Sorry for misspelling your name. It's REZA of course 😖
@RezaDorrani 4 жыл бұрын
:)
@lekhasharma3795 2 жыл бұрын
Not able to see the video, its like crashing
@RezaDorrani 2 жыл бұрын
It's on KZfaq :) Might have to do with your network bandwidth. You can try reducing resolution of video while watching.
@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).
Reza Dorrani
Рет қаралды 135 М.
How to Power BI
Рет қаралды 270 М.
Curbal
Рет қаралды 61 М.