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.
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
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 🤩
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.
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!
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....
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.
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 - th-cam.com/video/9gI9OscTLD0/w-d-xo.html
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.
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
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.
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.
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?
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?
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?
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++
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 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 Will deal with this at later phase. Your videos were inspirational and what I managed to do with your help now works. Much appreciated! 👍👌
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?
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!!
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/
@@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!
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
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
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!
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.
thanks a lot for the video, the user thats going to use the report has to have a licencing in power bi and power apps? could it be an external user to the company?
@@RezaDorrani thanks a lot for your answer! So it is only nedeed that the "owner" has the licensing, to external users whitout licensing use the report? If i understood correctly
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.
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)?
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
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?
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.
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.
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.
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?
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).
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....
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.
Hi Reza, great tutorial. I have a SharePoint list in my dashboard as the source. I add the powerapps visual and select the fields from my list, but when I select create a new app in the powerapps studio I cant see any fields passed to the app. I see the powerbi integration connector but when I add a gallery and select powerbiintegration.data in items property, no data is displayed
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 in case someone has experienced something similar.
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?
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
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.
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?
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?
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.
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
Update issue is because you are probably not connect to correct record context. My new video on this topic should have you covered. Check th-cam.com/video/5y2jJyH4Eu0/w-d-xo.html
@@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.
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/
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.
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 ?
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
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?
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
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)
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
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) ?
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."
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.
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
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/
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.
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.
@@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 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.
@@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
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?
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?
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.
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
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
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
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
Sir the power bi integration has limits it can shows up the data till 1k rows. Is there any workaround for this, my data has more than 2 lakh rows in power bi i want to fetch the data in power apps with power hi integration
It will only transfer over 1k. That is a limit. Ideally, user should filter the data in power bi and then work with the results of the limited data set in power apps.
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 I dont think anything has changed. Make sure you are adding power apps from the power bi service and not desktop. Check th-cam.com/video/5y2jJyH4Eu0/w-d-xo.html
@@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.
@@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/
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
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.
![F.HERO Ft. JSPKK x ลำไย ไหทองคำ x M-PEE - ไม่สนิทบิดหมด (Thai Riders Anthem) [Official MV]](http://i.ytimg.com/vi/kPJZ0UihBfk/mqdefault.jpg)
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.
Thank you Dan. Great point!
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
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 🤩
Thank You so much for your kind words.
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.
Awesome! You may like this one as well th-cam.com/video/5y2jJyH4Eu0/w-d-xo.html
3 years later still very helpful!
Glad to hear that!
Thanks so much
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!
😃 “Go ahead” and “Also” - I am trying to reduce the number of times I use these words.
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....
Thank you
Thank you so much man! You won part of my promotion!
Glad I could help!
You simply have the best well thought out PowerApps videos. Thank you
And I also have the most amazing viewers (hopefully subscribers) who give me such wonderful feedback.
Thank you 🙏
This is the most insightful and most underrated video ever on Power Apps and Power BI integration.
Kudos to you brother 🙌
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.
@@RezaDorrani it will pick up the traction soon.
Sharing this vid among my network.
Cheers 🥂
@@kartikwat Thanks for sharing
I never know powerBI and powerapps combo is so powerful. Your demo is outstanding Reza 👌👏👏 and thank you
Thanks for watching.
Your are most welcome and thanks for watching
Thanks! I saw many videos these days and this is the best one to explain everything clearly!
Wow! Thanks so much
Great job man. None of the known youtubers explained that as you do.
My goal always is to explain in simple way. Glad you liked the video.
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.
Thank you
Great video Reza! Thank you for putting so much work into your content, you make learning the power platform a lot easier.
My pleasure!
Thanks a million Reza! Fantastic demo!
My pleasure!
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.
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 - th-cam.com/video/9gI9OscTLD0/w-d-xo.html
Have to say, very good video in step by step , mentioning the reasons for the changes and their effects, appreciate the effort and sharing!
Glad it was helpful! Thank you for the feedback.
Great great video Reza, watching now. Thank you so much!
Enjoy!
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.
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
if this video alone wouldn't get me a fat raise and promotion, nothing will
👍
This is an amazing tutorial! Thank you Reza
Most welcome
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?
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.
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.
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.
@@RezaDorrani thanks alot for the confirmation! How can we copy screens?
@@luffygear5362 Right click copy and paste :)
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 ?
Landing screen to start with.
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?
Power BI - for sharing the report users will need the E5 license or Power BI premium license or pro license or per user license.
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?
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
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?
@@carlosgomez-df9cg You have to share the App with user
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++
Wow! Thank You so much for your kind words.
I do have a newer version of this video which you may like. Check th-cam.com/video/5y2jJyH4Eu0/w-d-xo.html
Another handy video. Thank you Reza
Glad it was helpful!
i could not thank you enough!!! this is what i need!!! thank you so much!!!
You're very welcome!
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
Check th-cam.com/video/5y2jJyH4Eu0/w-d-xo.html
@@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
@@assyabassya007 I have not come across this issue. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com/
@@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! 👍👌
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?
I have not run into an issue related to nbsp.
I will recommend you check on the forums at powerusers.microsoft.com/
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!!
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/
@@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!
@@bezen7808 Great 👍
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
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
wow! so well explained and the concept i was looking for but didnt know how to Thanks!!
You are most welcome
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!
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.
Thank you! For some reason the name isn’t loading when I transform the data only the guid.
@@Chubbs0804 Try posting your issue with screenshots on the forums at powerusers.microsoft.com/
thanks a lot for the video, the user thats going to use the report has to have a licencing in power bi and power apps? could it be an external user to the company?
Guest user Yes. But would need the licenses in either your tenant or theirs.
@@RezaDorrani thanks a lot for your answer! So it is only nedeed that the "owner" has the licensing, to external users whitout licensing use the report? If i understood correctly
@@readistreet9383 No - every user running power app needs a license.
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.
Embedded power apps have limitations. This could very well be one of them. Not something I have tried hence not sure of a workaround
@@RezaDorrani OK thanks!
Amazing video thank you!
Most welcome! Thank you for watching
Hi Reza! Thanks a lot for the video.
My pleasure!
Great video, very useful informations!
Thanks!
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)?
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
@@RezaDorrani What PBI license will suffice? free/pro/premium?
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?
I have done videos on multi screen forms and shown how to patch them. Search for that video on my channel.
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.
Data row limit (data coming from power bi dataset) is limited to 1000 for any data source.
Thanks alot for this video :)
My pleasure!
Thank you very much. You always do Interesting presentation!
Thank you!
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
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.
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.
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.
@@RezaDorrani Thank you
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?
Yes, every user accessing Power BI will need the Power BI license.
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!
You can use any data source of your choice. Check th-cam.com/video/5y2jJyH4Eu0/w-d-xo.html
great video
Thanks!
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).
Yes. I am actually showcasing a similar scenario Live tomorrow.
You can join me here: th-cam.com/video/0BuCpZMvhws/w-d-xo.html
@@RezaDorrani thanks looking forward for your session.
Thank you, That's a great effort
You are welcome!
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....
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.
Thank you
Thank you for watching
Hi Reza, great tutorial. I have a SharePoint list in my dashboard as the source. I add the powerapps visual and select the fields from my list, but when I select create a new app in the powerapps studio I cant see any fields passed to the app. I see the powerbi integration connector but when I add a gallery and select powerbiintegration.data in items property, no data is displayed
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 in case someone has experienced something similar.
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?
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
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?
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.
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?
Check community.powerbi.com/t5/Desktop/Date-Field-Time-Zone-Fix/m-p/402509
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?
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.
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
Update issue is because you are probably not connect to correct record context.
My new video on this topic should have you covered. Check th-cam.com/video/5y2jJyH4Eu0/w-d-xo.html
Thanks Reza
Most welcome
Hello Reza sir. Can we embed specific screens(not all) of the Power apps to Power BI? Please reply sir. Thank you.
I don't think so that is possible
Yes, it's not possible sir. I tried my best.
Can you please make a video on WordPress vs Power Apps. @@RezaDorrani
@@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.
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
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/
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.
Not sure why that would be the case. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
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 ?
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
Grt video.
One doubt, will power apps will fetch more than 2000 items from PowerBI integration data?
No
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?
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.
@@RezaDorrani thank you so much for the quick response. Do you have tutorial on auditing? 😊
@@kittydoes7600 I do not
Great video!
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
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)
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
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) ?
It does not give the filter value. It only provides the data set.
@@RezaDorrani Thank you for the quick answer king
very interesting :)
Thanks for the visit
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."
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.
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
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/
@@RezaDorrani I'm trying it Reza, if I manage to do it will let you know regards from Malta
What's maximum list size to make cds? Is it 30M items also?
It can as long as you have the storage capacity - docs.microsoft.com/en-us/power-platform/admin/capacity-storage
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.
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.
@@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?
@@rst5285 In that case just use First(PowerBIintegration.Data).colname and you should get the value.
@@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.
@@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
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?
Power BI data is passed as a whole and not page wise. I don’t believe there is any such option.
Can I use power bi Embed with a Power Apps visualization ?
I believe so. However, Power Apps would require user to sign in & a license.
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?
You could maybe be save a variable that has context of selected record and use that variable as selected record
Using powerbiintegration.refresh() function my visual is taking so long time to load the data .....does anyone has answer of this?
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.
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
Glad you found this video useful
How to remove the "PowerBIIntegration" from the PowerApp located at the Screen Tree View? (PowerApps)
Why would you want to remove that? Entire concept is based on that object.
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
In data set settings. I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
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.
A table in power apps would be created in dataverse. You need to ensure its in same environment as the app.
@@RezaDorrani do/can individuals have different environments from the business account that the individuals account is made from?
@@neiljavier7116 I do not understand your question
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
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
Sir the power bi integration has limits it can shows up the data till 1k rows. Is there any workaround for this, my data has more than 2 lakh rows in power bi i want to fetch the data in power apps with power hi integration
It will only transfer over 1k. That is a limit.
Ideally, user should filter the data in power bi and then work with the results of the limited data set in power apps.
@@RezaDorrani sir then is there any workaround that i can use more than 10k rows data from power bi dataset in power apps
@@ashishrawat8276 not that I’m aware of
@@RezaDorrani okay sir thanks
When i click on 'Edit' to edit my Powerapps from PBI, it just says "getting things ready" on the next webpage
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
Same here. I didn't manage to open Power Apps from within Power BI. Has it got sorted?
@@daniel92man I dont think anything has changed.
Make sure you are adding power apps from the power bi service and not desktop.
Check th-cam.com/video/5y2jJyH4Eu0/w-d-xo.html
How I can embed the mobil view to the app in my phone.
I did not understand the question
@@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.
@@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/
how the power app works in mobile phone?
App will need to run in context of power bi only.
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
That is true for datasets in import query mode. I believe you can go up-to 40 refreshes per day with additional licensing.
Sorry for misspelling your name. It's REZA of course 😖
:)
Not able to see the video, its like crashing
It's on TH-cam :)
Might have to do with your network bandwidth.
You can try reducing resolution of video while watching.
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.
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).