Hi Reza, This is awesome, I enjoyed every single of steps, clear explaination. I work with Power BI report but wanted to see how much value can be added with Power Apps. I like visual refresh function with direct query, definetly will try using it.
Hi Reza, it's great explanation for Power BI Tile usage. However I have multiple pages in the report. It's not showing pages. Is there any settings I miss.
Reza, hands down! Just finished watching you recommended video. Thanks in a million again Genius BOY! Where have you been all these years. I have decided to subscribe to your channel. Very well explained Power App + Power BI + CRUD = infinite possibilities. You got the best stuff on earth since the invention of slice bread. Great content. Awesome. “Great teachers are hard to find”. Grade: A++
Best video I have ever seen. This has changed how I will use Power Bi from now on. There's yet another reason to migrate from Sharepoint to Dataverse also even if it's only for this type of extension of Power Bi. Thanks Reza. Top video!
I was surprised to learn that Power BI has this feature; it's wonderful, and I'll try to use it. I appreciate you and will follow you since I enjoy the way you describe things.
You're up there with the best, Reza, but if i can offer one constructive criticism, it would be to to keep your cursor out the way of key parts of the formula bar text so we can understand the syntax :-))))))))
Thanks. I would like to. I make videos when I receive multiple requests on a topic. Every quarter I ask subscribers for topic suggestions on Community tab of my channel. Make sure to add this suggestion whenever I post the next topic suggestion post. If it gets max votes, I will plan a video on it.
Hi Reza - Thanks for making this video and it is very informative and pretty useful. I will surely create those integrations. I would like to thank you for sharing and creating these videos which gonna help in a real-time. I'm a big fan of your videos and hope you will be posting lot more interesting topics into your challen. Keep sharing your ideas and inputs. 👍👍👍🙏
Hi Reza, Thanks for the amazing video. I was wondering if you could confirm if i have connected with direct query then if i input any data throgh visual will that make any changes in database? will it update the database?
Hi Reza, great stuff!! Just curious to know unlike SharePoint, when we leverage Dataverse/SQL (Direct Query), are there any limits on PBI dataset refresh's still? (Premium 48/d, Pro 8/day).
Hi Reza!! You do a massive work, beleive me. I have one question that can not find anyone to answer. The function PowerBiIntegration.Refresh() doesnt't seem to work when selecting an existing app. Dou you know any other way or function to refresh the visuals when you make it from an existing app?..
Most welcome! I believe PowerBiIntegration.Refresh() is a limitation for existing app. One option would be to create a new app and then copy screens from existing app one by one.
This was exactly I was looking for a problem I am trying to solve. Thanks very much! I have 1 question. In a case where I need to do a change in the PBI report and republish it on to the service, how will it affect the process? Will I have to build the App again?
@@RezaDorrani Thanks for that. I encountered another challenge. I need to save the data in another list, not the source list. Is there any training you have done something related to that. What I need to do is exactly what you are showing here, but at the end I want the data to be stored in another separate list. If you have any training on that topic, I would be greatly appreciate. Thanks!
Hi Reza, appreciate the thorough video. I would like to eliminate the gallery step and just have the dataverse form - so when I click on a record in my power bi table the dataverse form picks up the ID in a new or edit mode. I have been able to do this successfully with my source as a sharepoint list but when following the same steps for a dataverse source, it's not working. Do you have any videos showing this? For me, the gallery is just an extra step, but now I'm wondering if it's a necessary step to get the form to work with dataverse sources. thank you!
I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Hi Reza, thx for this Video it helped me a lot in my actual Project. One question - is it possible that if i click on one issue in the PowerApp the PowerBI Report filters on this issue too?
Hi Rezo, the video is very useful.i would like understand the concept of bulk update. In this video you didn't show how to do the bulk upload. Can you please upload the video for bulk update
Thanks so much. I make videos when I receive multiple requests on a topic. Unfortunately did not receive a lot of requests for it. Every quarter I ask subscribers for topic suggestions on Community Tab of my channel. Most voted topic ideas get added to my backlog. Make sure to suggest this idea whenever the next topic suggestion post is out.
Hi Reza, This helped me a lot thanks for the amazing videos keep posting videos like you always does. I got stuck with LAUNCH function in power apps LAUNCH function is working fine but when clicking it from power bi that LAUNCH function is not working or responding not getting the issue can you please help me out on this. Many Thanks In Advance
Hi Rezi In your video in switch to bulk update button. What functions have you used .can you share with us. So we can able to recreate the same logic to update multiple records.that could help us a lot
Its been a while since I did this one and do not remember the specifics of the code. Probably - on Button click, set variable, switch to bulk update mode, user selects multiple items, added them to collection and then updated them in one go.
Hi Reza, thanks for the excellent video! I've made a successful Power BI report with a Power Apps Visual using this method. I now want to use Power Apps Solutions in order to deploy the whole solution from my Dev environment to Test. I add both the Power BI report and Power App that is used in the Power Apps Visual to a Solution. When I import that Solution into my Test environment, however, the Power Apps Visual still uses the Power App that is on the Dev environment. How can I implement Power Apps Solutions or Pipelines when dealing with a Power BI using a Power Apps Visual, please?
Hi Reza, this is really great. I have some questions. My PowerBI extracts multi excels on Sharepoint and combine into one table as dataset. So when I create APP, it can only connect to one of these Excels.....is there any way that I can select and edit one item, then App writes back to the excel contains the item; if I select another item from different Excel, App can re-direct to another Excel as data connection, and writes back to that Excel? Thanks.
Hi sir, thanks for this tutorial. Although the PBI data I am trying to work on comes from a built in Table from Visualization chart where data columns come from different tables and source files, and also with a 'new measurement' data. I see in this tutorial the data conveniently comes from just one table/source file. Anyway you can make a video with this more complex case?
I make videos when I get multiple requests on a particular topic. Every quarter I ask subscribers for topic suggestions on the Community Tab of my UA-cam channel. Subscribers vote for topics and the highest voted topics get added to my backlog. Make sure you post this in the next topic suggestion post. If it gets a lot of votes, I will add it to my backlog.
Hi Reza, Thank You so much for this nice and easy tutorial :) I'm able to make my very 1st Power App visual in my PBI, 100% from your help!! I encountered just 1 small issue when using LookUp function between Gallery1's selected ID to match with my Screen 2's Form's list of IDs. There are 9000+ IDs in the list to search and match but only the first/top 2000 IDs match well between the 2 screens. May I learn from you how to bypass the 2000 records limit? I tried with alternative functions such as First, Filter and StartsWith to replace LookUp but they also can't function over the 2000th record to load the data in the form to update. Many thanks in advance.
Hi Reza , thanks for all the great content you provided us , i have doubt in the last section in the patch function you used colData unable to understand what it is , is their any materials i can refer to understand how to implement this as i feel it very handy feature when you have to bulk update records above 10 which is true in my case or most use case of this app
Great tutorial!! few questions plz Do you have a setp by step training videos for Power Apps? In the form you created in Power Apps the date field shows time as well, how can I modify it to show only dates? Thank you again and again!
Hi Reza, Thank you very much for this video. I am very new to Power Apps. My issue power BI data integration is not showing up in the app at all. Should I have a subscription to Power APPs before using it.
Hi Reza, great video! I have a question. The Power app write back does work, and I work with dates in 1 column for example. However the Power app shows the correct date, but the table in the Power BI shows 1 day before the date entered in the Power App... Any idea how to fix this?
Hi Reza, great video! Microsoft documentation states that manual refreshes of Power BI datasets don't count towards the allotted refreshes of 8 per day for a Pro license. Wouldn't utilizing the PowerBIIntegration.Refresh() command constitute a manual refresh and therefore not count towards that total?
Hi Reza, thanks for the video. I watched it till the end without blink of an eye!! Great👏👏 Here is my question; consider a scenario, After write operation is complete on sharepoint, do you think that implementing a flow with power automate which update dataset is possible? And if it is possible, do you think that powerbi integration. Refresh() work on as well? Thanks
Awesome! Thank You. Great question. Something to try out. My guess would be Yes but the flow only will initiate the refresh. When the refresh completes, you would not know. So it may not be real-time.
@@RezaDorrani thanks for the reply. Maybe a work around solution would be a DQ over a simple table in the same dataset which make it possible to use refresh() function to make it possible on the powerbi.com. I will try it out and let you know, cheers good bye!
Hi Reza, nice video! Do you advise using the Canvas App visual within a Power BI dashboard as well? I've tried this a couple of times but notice that the Canvas App is not refreshing automatically within a dashboard, only within the reports.. Cheers!
@@RezaDorrani Thanks Reza! One final question on licensing, are "not power apps licensed" users able to interact with the app? I assume you need a certain Power apps license but can't find any documentation on this.. Cheers!
@@scharpealex4329 Power App needs a license per user that accesses the App. If App uses premium connectors (like sql or Dataverse) then premium licensing is needed. If App uses standard connectors like SharePoint then Office licenses will suffice.
hi Reza, thanks for the great video! Can I check how can we apply above if our data source in Power BI is from multiple files? Also, how can I write comments into individual cells in Power BI matrix table? Thank you!
Hi Reza, Thanks for this video. Very helpful. I'm stuck in a situation where I'm using Power BI data flows (For ETLs) and ingesting in Power BI Datamart ! Is there a Power Apps service that allows me to update records in Power BI data flows result set ?
Im not sure about this. Never came across this scenario. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Thanks Reza also for that tutorial. One question. Is it possible to show in power app some topics related to a power bi table without any possibility to edit + topics in sharepoint list to be modified?
I mean I would like to modyfied data in a sharepoint list linked to the main table in power bi, without working on this table directly but just using it as filter to select data in sharepoint list
Hi Reza, Love your stuff. I'm stuck on an issue in power automate (flow, not desktop) trying this work - email receives .xls file, create file, create table with dynamic range, update sharepoint list with new rows based off table. I keep getting item not found on the create table action. Any ideas? If not, that would be a great video sine I imagine there is a lot of use case in it for people.
Thanks Reza, Great Video. I have a doubt, how we can pass multiple conditions in the Lookup function. I have two tables connected with One to Many relationship, the page will going to show same ID multiple times. So how could i pass the ID and selected month (slicer) value to Power Apps app
Hi mr. Reza. thanks for these very informative videos. A question. It's possible with power apps, to import data from sharepoint and then save them in a table on Dataverse. Maybe with the same ID? Tks x all...
Hi Reza, Thank you for the great post. I have a power bi report for which the source data is SQL Server. One of my requirements is to write comments in power bi and while doing so, i don't want these comments to reflect on SQL database since i have only READ view in SQL. Do you have any suggestions how we can overcome this ?
Awesome video. Having one doubt, as everyone know PowerApps has limit as it can not get more than 2000 items. So now, if PowerBI has 7000 rows in data then all those rows will be visible in Powerapps gallery, or it will only show top 2000 rows only.
I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.
Thank you Reza for this awesome explanation. Just i would like to understand how to navigate to second screen (IssueTrackerForm) if the Gallery1 data source is not identical as the source(SP). I tried to navigate as explained but the navigation keep showing blank if the list (item) at gallery(from PBI service) is not on the list at SP . So how i can force to navigate to the 2nd screen and load the information to the form from the gallery instead of data source from SP list and then write back to the SP . ??
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
Hi Reza, great video! QQ, can we filter the powerbi with a power app? like having a gallery with different Titles and filtering the PowerBI list with the selected Title in gallery. Thanks again you are awesome!
I don’t think you can filter power bi from power apps (embedded in power bi). You could however add a power bi report in power App and filter if from gallery data in Apps. Check ua-cam.com/video/DADWqlKdL3s/v-deo.html
It is great! I enjoyed so much. I have a question . I want write a simple automate flow that "when a new item is created in sharepoint list ,add rows to a dataset in power bi",as I may have several users in different way to creat the items .some one use PowerApps ,some one may use Forms& Flow, etc . In my flow ,I finished the "When a new item is created " part ,then the action of "Add rows to a dataset" part ,I met trouble, For workspace ,I selected "My Workspace", however for "Dataset"& "Table" I got no iead how to fill in ? Thanks a lot.
I have no idea about your use case. Not something I have tried. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi Reza, I just start my journey with Power platform and this is my first video I watch from you Channel. Very informative. But I tried this in one of my user case when I update the data using the form or click the submit button, it shows an error that data source is locked. Could you please tell me what should I do? I would really appreciate your help? Thanks again for this insightful video.
Thanks for watching and liking the channel content. I have not come across an issue where “data source is locked”. I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani Hi Reza, I need an advise, I create a power BI report with Power app integration, where my data source is a excel which is located in the one drive.. Issue is that when I use that report in the power Bi desktop everything is working fine, power app, crud operation . But when I entered the input in the Power Bi service using the power app, the datasource is getting refreshed/updated but the visual on refreshing the data is not getting refreshed or updated.
@@tarunaneja7802 Im not sure since I have not tried with excel. Without trying it out I cannot advice. Best option would be to post your query on the forums.
I cannot grant access to my list :) Its a standard SharePoint List with dummy data. Idea of video is to show integration features of power apps with power bi.
Question: in order to create the new app in Power Apps using the visual in the Power BI report, do you need to have certain level of licensing on the Power Apps side? I am following all the steps you mentioned, but when creating the new app in Power Apps (coming from the Power BI report), the data points don't carry over the Power Apps canvas.
Data points should carry over. If you are able to get to power apps, then you do have the license. I’m not sure why your data points are not getting carried over though.
Reza thank you for amazing video. I have a question about the item on the gallery1. To identify a unique row in my data source, it’s 3 levels (FY (numeric), equip (text), region(text)) I adjusted the code as follows but it’s not work. Can you help me ? LookUp(FinalTable, FY = Gallery1.Selected.FY && equip = Gallery1.Selected.equip && region = Gallery1.Selected.region)
Hi raza, greate video, thank you! I have a question: I want to make an interactive report [ power bi , power apps and machine learning(ML) ] when the user changes a value in power apps this value will be sent to the ML and the result of (ML) must appear immediately on the report is there a method to refresh the dataset without exceeding the refresh limit [power automate, API...]
Video showcases how to write back and perform live refresh. Your data source will have to support Direct Query. If using Import Query mode, then you will be limited to number of refreshes.
Great video. I have embedded a Power App into Report that has a SQL view as a data source. There is no PowerBIIntegration.Refresh() available via intellisense, just the Data object☹. Is this a limit of the datasource or where we host SQL Server? Also are we able to show metadata such as Report If in the Power App if it is embedded in multiple reports?
Hi Reza, Could pls do a video on bulk upload of data from an Excel to SP List? Currently I'm doing it manually using edit in Grid mode, is it possible to upload whole excel data through PowerApp or anything?
Sorry to trouble you once again, Any attendance management system or leave tracker of employee video as such? When I look to format a column of dataType Date time in SP, its not allowing me to add multiple dates across a cell. Is there any workaround as such in order to track the leaves that an employee takes in particular month.
Hi Reza, this is perfect for something I needed to create and the explanation was so clear! I was able to implement with only a few minor hiccups. How do I change the default sort on the gallery? I want it to sort by an item code, not by the ID number.
@@RezaDorrani Thank you, I got a bunch of red errors saying I had a circular reference but it turned out I was choosing the wrong field and I needed the one with the apostrophes around it so your video helped narrow that down.
@@HollyA.-go8lz I will have to look at your app in action to know the reason. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Hi Reza, thanks for this video, when I click create New Power App it doesn't build the new app instead take me to the blank power app page ask to add an item from insert pane or connect to data
I have not experienced the mentioned behavior and hence not sure what the cause for it could be. I will recommend posting your query on forums in case someone has experienced something similar powerusers.microsoft.com
This is a great video. I tried replicating this for updating a SQL table but when I get to the part where we create Screen2 as a form and then join it to the dataset, it doesn't automatically generate the form for me. I have to manually insert the fields and they just appear as cards with the field name and no passthrough of data from screen1.
I will have to look at your Ap & BI report in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hello Reza, I have a question, will direct query work with business central, there is not a lot of info online regarding the Business Central - Power BI - Power apps, Thank you so much
I have done no work with business central and not sure if direct query is supported. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Hi Reza, This is really very good and awesome option. You have explained it really well and I enoyed every bit of it. Just one request if its possible. Can you share the pbix file used in thsi video. Another question is regarding the power apps licensing. Can you please cover that as well.
It is possible but I do not have a specific video on it with power bi. I have done videos on bulk update scenarios. You would need to merge logic between 2 videos.
Yeah now I have create same power app which you have created but in gallery screen I have created a buttons to update bulk records but I don’t know what function should use to update my records.could you help me out this.I am able to select multiple records but know I need to update that records With help of that bulk update button By clicking that button it should navigate to edit screen and there I will update. Could you help what function should I use in that button
@@inspiretheworld6121 I do not have a specific video reference on this and would have to try it out to provide guidance. It would be best to post your issue/query with screenshots on the forums at powerusers.microsoft.com
Hey Reza - I'm following your steps and see the PowerBIIntegration object, but the App isn't recognizing any of the fields I added to the Power Apps visualization in the Power BI report. Where would you start to diagnose this?
@@RezaDorraniI missed that the steps in Power BI need to be taken in the service, and not through the desktop app. That's a different experience than I'm used to, like how we can integrate Power Automate through the desktop app.
Reza, I wanted to do that but my source was a SQL server table, how do I do a Power Automate that will check and add new rows to Sharepoint? And update the existing ones with new data from SQL?
I do not have a video reference on SQL scenario and would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi Reza, This is very helpful. if you have explained how the bulk update is happened step by step then it will be very helpful for me. can you please explain step by step how you have updated in bulk.
Hi Reza, I have a question can we do same process if my data source is a CSV file. And I have created reports using CSV file and want to write back to csv file or dataset using a powerapp visual form in reports.
Hi Reza, so the whole dataset had to be refreshed to reflect the edited or new record? If I want to see the result of every record I add/edit, has to refresh whole dataset many many times…..one of the table in my dataset has more than 10mil records. The write back table actually only have about 1k records. Any suggestions? Thanks
Tha la for the video Reza Even after saving power app, I am not seeing the same in powerbi. Still showing like "Go to power app studio" ANY SUGGESTION PLEASE
Hi Reza, regarding creating relation between person type column in SharePoint list with user information list of sharepoint. I have challenges since i have two person type column, which needs separate relation. How to achieve this?
Not sure about that as I have not tried that. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Is there a way to do this if the datasource isn't a Sharepoint List? For example, if I create a manual table in PowerBI can I update that table with PowerApps? I see the data from that table, but it doesn't appear to allow me to change it when I add the EditForm.
Hi , I have a power BI report I've integrated with power apps the report has a column of date. i need the power apps to show this date exactly like it in the Power BI Please suggest
Whatever format power apps gets the date it, you can use formulas to convert it to same format as in power bi. I will recommend posting your query with screenshots on the forums at powerusers.microsoft.com
Hi Reza , Nice information but facing some issues . I have a Power BI Pro License and Power Apps with standard license designation . I followed the video and created Powerapp visual however after closing powerapp browser it does not refresh in BI report and shows blank . Any idea is it due to License issues or any other possible issue
Refresh has nothing to do with license. The datasource you are connecting to in power app drives the license. Im guessing something is not done correctly in your scenario that’s causing an issue. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@@mukhayyarmohammed5874 You will need to check it out. I dont have the link. Here is the general documentation link learn.microsoft.com/en-us/power-apps/
Hi Reza, thanks a ton. But in my case- Gallery is selecting the data from the first row by default. May I know how to avoid this. If i make screen as home screen, On the load everytime i am seeing the data for the first row. Is there a way to remove this or add text to selectl ?
Try setting default value of gallery to {} If it does not work, then I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
hi Reza, i created the same but i did the lookup in gallery since my scenario is "Role" be selected in PBI then multiple name should show in power apps Gallery but it is only showing "First result". Was wonsering if it is possible to do lookup but getting all result and not just first?
Lookup function only returns single row. Im not sure what Role means in your scenario. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Hi Reza, This is awesome, I enjoyed every single of steps, clear explaination. I work with Power BI report but wanted to see how much value can be added with Power Apps. I like visual refresh function with direct query, definetly will try using it.
Thank You so much! Glad it was helpful!
Hi Reza, it's great explanation for Power BI Tile usage. However I have multiple pages in the report. It's not showing pages. Is there any settings I miss.
This is HANDS DOWN one of the very best Microsoft Power Suite demonstrations I have ever seen. Thank you for sharing this!
Wow, thanks!
This was the best, most comprehensive look at how to push data into your data source using PBI and PowerApps. Thank you!
Wow! Thanks Lannie
Reza, hands down! Just finished watching you recommended video. Thanks in a million again Genius BOY! Where have you been all these years. I have decided to subscribe to your channel. Very well explained Power App + Power BI + CRUD = infinite possibilities. You got the best stuff on earth since the invention of slice bread. Great content. Awesome. “Great teachers are hard to find”. Grade: A++
Wow! Thanks so much for all the compliments.
I saw many videos on this exact topic, but you explained it the best out of everyone, thank you so much
😁
Awesome! Thanks so much
Wow, one video served me better than 2 Udemy courses. This is awesome, thank you!
Glad it was helpful!
I'm literally learning how to use these amazing tools off your videos. Keep on going Reza your amazing. A true pro.
Happy to hear that!
Best video I have ever seen. This has changed how I will use Power Bi from now on. There's yet another reason to migrate from Sharepoint to Dataverse also even if it's only for this type of extension of Power Bi. Thanks Reza. Top video!
Great to hear that!
I was surprised to learn that Power BI has this feature; it's wonderful, and I'll try to use it. I appreciate you and will follow you since I enjoy the way you describe things.
Glad to hear that! Thanks for watching
Simply ... Brilliant ... 5* ... Thanks Reza and Please make more videos , which show integration between Power App-BI-Automate....
Thanks Anil!
My playlist on integration is growing ua-cam.com/play/PLTyFh-qDKAiEUf5st2WhUzgoDRF-1hET0.html
You're up there with the best, Reza, but if i can offer one constructive criticism, it would be to to keep your cursor out the way of key parts of the formula bar text so we can understand the syntax :-))))))))
Thanks so much. Feedback is noted. Much appreciated
Hi Reza, this is really awesome! Can you please also make a video to explain how the bulk update works?
Thanks. I would like to. I make videos when I receive multiple requests on a topic. Every quarter I ask subscribers for topic suggestions on Community tab of my channel. Make sure to add this suggestion whenever I post the next topic suggestion post. If it gets max votes, I will plan a video on it.
Hi Reza - Thanks for making this video and it is very informative and pretty useful. I will surely create those integrations. I would like to thank you for sharing and creating these videos which gonna help in a real-time. I'm a big fan of your videos and hope you will be posting lot more interesting topics into your challen. Keep sharing your ideas and inputs.
👍👍👍🙏
Glad it was helpful! Thank You so much for watching and liking the videos.
Hi Reza, Thanks for the amazing video. I was wondering if you could confirm if i have connected with direct query then if i input any data throgh visual will that make any changes in database? will it update the database?
If you add/update data via power app visual to database and then refresh the power bi using formula shown in video then yes.
@@RezaDorrani Cheers
Hi Reza, great stuff!! Just curious to know unlike SharePoint, when we leverage Dataverse/SQL (Direct Query), are there any limits on PBI dataset refresh's still? (Premium 48/d, Pro 8/day).
Direct Query has no refresh limits since there is a direct call made to underlying data source each time user runs the report.
@@RezaDorrani Thank you Reza
Hi Reza!! You do a massive work, beleive me. I have one question that can not find anyone to answer. The function PowerBiIntegration.Refresh() doesnt't seem to work when selecting an existing app. Dou you know any other way or function to refresh the visuals when you make it from an existing app?..
Most welcome!
I believe PowerBiIntegration.Refresh() is a limitation for existing app.
One option would be to create a new app and then copy screens from existing app one by one.
many thanks!!!! @@RezaDorrani
This was exactly I was looking for a problem I am trying to solve. Thanks very much! I have 1 question. In a case where I need to do a change in the PBI report and republish it on to the service, how will it affect the process? Will I have to build the App again?
You should not have to build app again.
Best to do a quick proof of concept to confirm the behavior.
@@RezaDorrani Thanks for that. I encountered another challenge. I need to save the data in another list, not the source list. Is there any training you have done something related to that. What I need to do is exactly what you are showing here, but at the end I want the data to be stored in another separate list. If you have any training on that topic, I would be greatly appreciate. Thanks!
@@imalkamadhushani4701 I do not have a specific video reference on that
@@RezaDorrani No problem Thanks!
Working on this today with your older video, great to have the new one...thanks
Awesome! Thanks for watching both.
Hi Reza, appreciate the thorough video. I would like to eliminate the gallery step and just have the dataverse form - so when I click on a record in my power bi table the dataverse form picks up the ID in a new or edit mode. I have been able to do this successfully with my source as a sharepoint list but when following the same steps for a dataverse source, it's not working. Do you have any videos showing this? For me, the gallery is just an extra step, but now I'm wondering if it's a necessary step to get the form to work with dataverse sources. thank you!
I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Hi Reza, thx for this Video it helped me a lot in my actual Project. One question - is it possible that if i click on one issue in the PowerApp the PowerBI Report filters on this issue too?
Power apps cannot filter power bi
Superb! Could’nt ask for anything more. Very well explained with a fantastic example. Thank you so much👍
Most welcome!
I would like to know whether we can write back to SQL database as well as we can do it with spreadsheets
@@harshshah5947 SQL is also possible
Hi Rezo, the video is very useful.i would like understand the concept of bulk update. In this video you didn't show how to do the bulk upload. Can you please upload the video for bulk update
Thanks so much.
I make videos when I receive multiple requests on a topic. Unfortunately did not receive a lot of requests for it. Every quarter I ask subscribers for topic suggestions on Community Tab of my channel. Most voted topic ideas get added to my backlog. Make sure to suggest this idea whenever the next topic suggestion post is out.
Hi Reza,
This helped me a lot thanks for the amazing videos keep posting videos like you always does.
I got stuck with LAUNCH function in power apps LAUNCH function is working fine but when clicking it from power bi that LAUNCH function is not working or responding not getting the issue can you please help me out on this.
Many Thanks In Advance
I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi Rezi
In your video in switch to bulk update button. What functions have you used .can you share with us.
So we can able to recreate the same logic to update multiple records.that could help us a lot
Its been a while since I did this one and do not remember the specifics of the code.
Probably - on Button click, set variable, switch to bulk update mode, user selects multiple items, added them to collection and then updated them in one go.
Hi Reza, thanks for the excellent video!
I've made a successful Power BI report with a Power Apps Visual using this method. I now want to use Power Apps Solutions in order to deploy the whole solution from my Dev environment to Test. I add both the Power BI report and Power App that is used in the Power Apps Visual to a Solution. When I import that Solution into my Test environment, however, the Power Apps Visual still uses the Power App that is on the Dev environment.
How can I implement Power Apps Solutions or Pipelines when dealing with a Power BI using a Power Apps Visual, please?
I am not aware of the ALM friendliness of power apps visual in power bi. I believe that story is still weak.
Hi Reza, this is really great. I have some questions. My PowerBI extracts multi excels on Sharepoint and combine into one table as dataset. So when I create APP, it can only connect to one of these Excels.....is there any way that I can select and edit one item, then App writes back to the excel contains the item; if I select another item from different Excel, App can re-direct to another Excel as data connection, and writes back to that Excel? Thanks.
You would need a column that has the file path in your power bi data set. Use that column value to define the item to update in excel file
@@RezaDorrani I do have that in dataset. Just not sure how to connect to it. Can you please point me how to search a solution for this? Thanks
@@jesl-pl4sh I do not have a reference video on this scenario. You can try posting your query on forums powerusers.microsoft.com
Hi sir, thanks for this tutorial. Although the PBI data I am trying to work on comes from a built in Table from Visualization chart where data columns come from different tables and source files, and also with a 'new measurement' data. I see in this tutorial the data conveniently comes from just one table/source file. Anyway you can make a video with this more complex case?
I make videos when I get multiple requests on a particular topic.
Every quarter I ask subscribers for topic suggestions on the Community Tab of my UA-cam channel.
Subscribers vote for topics and the highest voted topics get added to my backlog.
Make sure you post this in the next topic suggestion post. If it gets a lot of votes, I will add it to my backlog.
Thanks for this awesome video. I gained a lot as usual but I am more fascinated by the visual refresh function with direct query
You're very welcome!
Hi Reza, Thank You so much for this nice and easy tutorial :) I'm able to make my very 1st Power App visual in my PBI, 100% from your help!!
I encountered just 1 small issue when using LookUp function between Gallery1's selected ID to match with my Screen 2's Form's list of IDs. There are 9000+ IDs in the list to search and match but only the first/top 2000 IDs match well between the 2 screens. May I learn from you how to bypass the 2000 records limit?
I tried with alternative functions such as First, Filter and StartsWith to replace LookUp but they also can't function over the 2000th record to load the data in the form to update. Many thanks in advance.
2000 is a hard limit!
Hi Reza , thanks for all the great content you provided us , i have doubt in the last section in the patch function you used colData unable to understand what it is , is their any materials i can refer to understand how to implement this as i feel it very handy feature when you have to bulk update records above 10 which is true in my case or most use case of this app
I have done multiple videos on bulk updating data using collections.
Check ua-cam.com/video/VzrarcM9W5k/v-deo.html
Great tutorial!! few questions plz
Do you have a setp by step training videos for Power Apps?
In the form you created in Power Apps the date field shows time as well, how can I modify it to show only dates?
Thank you again and again!
Power Apps Training - I am planning live training sometime this year.
You would need to use expressions to convert the date field.
Check channel memberships. I have gone live with a training tier that you can sign up for now.
ua-cam.com/users/rezadorranijoin
Thanks for this really helpful, instead of using page filters can we create same slicers visual on report page for filtering purpose?
I believe Yes. I have not tried that scenario though.
Hi Reza, Thank you very much for this video. I am very new to Power Apps. My issue power BI data integration is not showing up in the app at all. Should I have a subscription to Power APPs before using it.
Have you followed steps in video?
You need to publish report to PBI service and then add power app from there
@@RezaDorrani Really sorry that was what I missed. Thank you very much!
Thank Rena, think is what the world need 👏🏻👏🏻👏🏻
👍
Hi Reza, great video! I have a question. The Power app write back does work, and I work with dates in 1 column for example. However the Power app shows the correct date, but the table in the Power BI shows 1 day before the date entered in the Power App... Any idea how to fix this?
I have not come across this issue hence not sure. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Thank you for this video - I appreciate you!
You are so welcome!
Very nice video and good learning first time watching the integration with power bi. Your video made me to learn alot 🙂.
Glad to hear that!
Hi Reza, great video! Microsoft documentation states that manual refreshes of Power BI datasets don't count towards the allotted refreshes of 8 per day for a Pro license. Wouldn't utilizing the PowerBIIntegration.Refresh() command constitute a manual refresh and therefore not count towards that total?
For Direct Query mode, you can initiate N number of PowerBIIntegration.Refresh() since all it does is refreshes the Visuals.
Woah this is so cool. Very thoroughly explained. Thank you so much Reza.
Most welcome
14:48- number of refreshes allowed per day
15:15- SQL supports DirectQuery Mode (instant refreshes)
19:35- Live refresh in Power BI (Direct Query)
Thanks for bookmarks
Hi Reza, thanks for the video. I watched it till the end without blink of an eye!! Great👏👏
Here is my question; consider a scenario,
After write operation is complete on sharepoint, do you think that implementing a flow with power automate which update dataset is possible?
And if it is possible, do you think that powerbi integration. Refresh() work on as well?
Thanks
Awesome! Thank You.
Great question. Something to try out. My guess would be Yes but the flow only will initiate the refresh. When the refresh completes, you would not know. So it may not be real-time.
@@RezaDorrani thanks for the reply. Maybe a work around solution would be a DQ over a simple table in the same dataset which make it possible to use refresh() function to make it possible on the powerbi.com. I will try it out and let you know, cheers good bye!
@@mahmutolcaycelik1909 Let me know!
Hi Reza,
Great video as usual.
Thank you for sharing your knowledge.
Your lessons point out that Dataverse should be the core of our BI projects.
Dataverse for the win!
I recently did a Dataverse intro video that might interest you ua-cam.com/video/byUuEoDQjiU/v-deo.html
This is a life saver and i can't thank you more 🙏 ❤️ plz keep educating us
It's my pleasure
Hi Reza, nice video! Do you advise using the Canvas App visual within a Power BI dashboard as well? I've tried this a couple of times but notice that the Canvas App is not refreshing automatically within a dashboard, only within the reports.. Cheers!
Not so sure about Dashboards. The refresh would be a limitation there.
@@RezaDorrani Thanks Reza! One final question on licensing, are "not power apps licensed" users able to interact with the app? I assume you need a certain Power apps license but can't find any documentation on this.. Cheers!
@@scharpealex4329 Power App needs a license per user that accesses the App. If App uses premium connectors (like sql or Dataverse) then premium licensing is needed.
If App uses standard connectors like SharePoint then Office licenses will suffice.
hello great video thank you,
I have a question, is it possible to do so with a sql server source ? or just sharepoint list will do ?
Can be done with SQL
Reza, this is such a great video, well done man! ❤
Thanks a ton!
hi Reza, thanks for the great video! Can I check how can we apply above if our data source in Power BI is from multiple files? Also, how can I write comments into individual cells in Power BI matrix table? Thank you!
Power Apps can write data back to data source only. Not power bi matrix.
Hi Reza, Thanks for this video. Very helpful. I'm stuck in a situation where I'm using Power BI data flows (For ETLs) and ingesting in Power BI Datamart ! Is there a Power Apps service that allows me to update records in Power BI data flows result set ?
Im not sure about this. Never came across this scenario. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Thanks Reza also for that tutorial. One question. Is it possible to show in power app some topics related to a power bi table without any possibility to edit + topics in sharepoint list to be modified?
I mean I would like to modyfied data in a sharepoint list linked to the main table in power bi, without working on this table directly but just using it as filter to select data in sharepoint list
You have full control in power app to decide if you want to give edit features. I do not have a specific video reference on your scenario though.
Hi Reza, Love your stuff. I'm stuck on an issue in power automate (flow, not desktop) trying this work - email receives .xls file, create file, create table with dynamic range, update sharepoint list with new rows based off table. I keep getting item not found on the create table action. Any ideas? If not, that would be a great video sine I imagine there is a lot of use case in it for people.
ua-cam.com/video/Kupz71dWYyY/v-deo.html may help
Thanks Reza, Great Video. I have a doubt, how we can pass multiple conditions in the Lookup function. I have two tables connected with One to Many relationship, the page will going to show same ID multiple times. So how could i pass the ID and selected month (slicer) value to Power Apps app
One cannot pass the slicer values to Power Apps.
Power Apps only gets the data set from Power BI.
@@RezaDorrani Thank you for quick reply :)
Hi mr. Reza. thanks for these very informative videos. A question. It's possible with power apps, to import data from sharepoint and then save them in a table on Dataverse. Maybe with the same ID? Tks x all...
Power Apps is not meant for importing and pushing data. It is not an ETL too.
Use dataflows for that.
@@RezaDorrani ok txs x all
Hi Reza,
Thank you for the great post.
I have a power bi report for which the source data is SQL Server. One of my requirements is to write comments in power bi and while doing so, i don't want these comments to reflect on SQL database since i have only READ view in SQL. Do you have any suggestions how we can overcome this ?
You would need write access in order to write to SQL through Power Apps. power Apps cannot update power bi data set. It is read only.
Awesome video.
Having one doubt, as everyone know PowerApps has limit as it can not get more than 2000 items.
So now, if PowerBI has 7000 rows in data then all those rows will be visible in Powerapps gallery, or it will only show top 2000 rows only.
2000 is a hard limit!
Hi Reza , I learned a lot via this video. However can you make a video on writeback to redshift via power app
I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.
Thank you Reza for this awesome explanation. Just i would like to understand how to navigate to second screen (IssueTrackerForm) if the Gallery1 data source is not identical as the source(SP). I tried to navigate as explained but the navigation keep showing blank if the list (item) at gallery(from PBI service) is not on the list at SP .
So how i can force to navigate to the 2nd screen and load the information to the form from the gallery instead of data source from SP list and then write back to the SP . ??
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
Hi Reza, great video! QQ, can we filter the powerbi with a power app? like having a gallery with different Titles and filtering the PowerBI list with the selected Title in gallery. Thanks again you are awesome!
I don’t think you can filter power bi from power apps (embedded in power bi).
You could however add a power bi report in power App and filter if from gallery data in Apps.
Check ua-cam.com/video/DADWqlKdL3s/v-deo.html
It is great! I enjoyed so much. I have a question . I want write a simple automate flow that "when a new item is created in sharepoint list ,add rows to a dataset in power bi",as I may have several users in different way to creat the items .some one use PowerApps ,some one may use Forms& Flow, etc . In my flow ,I finished the "When a new item is created " part ,then the action of "Add rows to a dataset" part ,I met trouble, For workspace ,I selected "My Workspace", however for "Dataset"& "Table" I got no iead how to fill in ?
Thanks a lot.
I have no idea about your use case. Not something I have tried. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi Reza, I just start my journey with Power platform and this is my first video I watch from you Channel. Very informative. But I tried this in one of my user case when I update the data using the form or click the submit button, it shows an error that data source is locked.
Could you please tell me what should I do?
I would really appreciate your help?
Thanks again for this insightful video.
Thanks for watching and liking the channel content.
I have not come across an issue where “data source is locked”.
I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani Hi Reza, I need an advise, I create a power BI report with Power app integration, where my data source is a excel which is located in the one drive.. Issue is that when I use that report in the power Bi desktop everything is working fine, power app, crud operation . But when I entered the input in the Power Bi service using the power app, the datasource is getting refreshed/updated but the visual on refreshing the data is not getting refreshed or updated.
@@tarunaneja7802 Im not sure since I have not tried with excel. Without trying it out I cannot advice. Best option would be to post your query on the forums.
You're a lifesaver
Tqq 🎉
Most welcome
What a gem. thank you Reza!
Most welcome
Thanks Reza, since today I was started working the same 😂😂😂😂 what a coincidence ....
I read minds :)
Hi Raza, Thanks for explaining it so well. Can I get access to the sharepoint list you used?
I cannot grant access to my list :)
Its a standard SharePoint List with dummy data. Idea of video is to show integration features of power apps with power bi.
Question: in order to create the new app in Power Apps using the visual in the Power BI report, do you need to have certain level of licensing on the Power Apps side? I am following all the steps you mentioned, but when creating the new app in Power Apps (coming from the Power BI report), the data points don't carry over the Power Apps canvas.
Data points should carry over. If you are able to get to power apps, then you do have the license.
I’m not sure why your data points are not getting carried over though.
Reza thank you for amazing video. I have a question about the item on the gallery1. To identify a unique row in my data source, it’s 3 levels (FY (numeric), equip (text), region(text)) I adjusted the code as follows but it’s not work. Can you help me ? LookUp(FinalTable, FY = Gallery1.Selected.FY && equip = Gallery1.Selected.equip && region = Gallery1.Selected.region)
Most welcome! Not possible to guess an issue here on chat. Best place to post issues is the forums at powerusers.microsoft.com/
Hi raza,
greate video, thank you!
I have a question:
I want to make an interactive report [ power bi , power apps and machine learning(ML) ]
when the user changes a value in power apps this value will be sent to the ML and the result of (ML) must appear immediately on the report
is there a method to refresh the dataset without exceeding the refresh limit [power automate, API...]
Video showcases how to write back and perform live refresh. Your data source will have to support Direct Query.
If using Import Query mode, then you will be limited to number of refreshes.
nice structured video! pls. keep posting!
Thanks, will do!
Great video. I have embedded a Power App into Report that has a SQL view as a data source. There is no PowerBIIntegration.Refresh() available via intellisense, just the Data object☹. Is this a limit of the datasource or where we host SQL Server? Also are we able to show metadata such as Report If in the Power App if it is embedded in multiple reports?
Should not be the case. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com/
@@RezaDorrani thanks, I will do that.
Hi Reza,
Could pls do a video on bulk upload of data from an Excel to SP List?
Currently I'm doing it manually using edit in Grid mode, is it possible to upload whole excel data through PowerApp or anything?
Check ua-cam.com/video/P6yqIpjmPrs/v-deo.html
@@RezaDorrani thanks a lot
Sorry to trouble you once again, Any attendance management system or leave tracker of employee video as such?
When I look to format a column of dataType Date time in SP, its not allowing me to add multiple dates across a cell. Is there any workaround as such in order to track the leaves that an employee takes in particular month.
@@ambarish360 I do not have a video reference for those. I will recommend checking on the forums at powerusers.microsoft.com/
Hi Reza, this is perfect for something I needed to create and the explanation was so clear! I was able to implement with only a few minor hiccups.
How do I change the default sort on the gallery? I want it to sort by an item code, not by the ID number.
Wonderful!
Here is a video on sorting ua-cam.com/video/6KlI1iZ_KD0/v-deo.html
@@RezaDorrani Thank you, I got a bunch of red errors saying I had a circular reference but it turned out I was choosing the wrong field and I needed the one with the apostrophes around it so your video helped narrow that down.
@@HollyA.-go8lz I will have to look at your app in action to know the reason. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Hi Reza, thanks for this video, when I click create New Power App it doesn't build the new app instead take me to the blank power app page ask to add an item from insert pane or connect to data
I have not experienced the mentioned behavior and hence not sure what the cause for it could be.
I will recommend posting your query on forums in case someone has experienced something similar powerusers.microsoft.com
Superb thanks Reza 🇭🇰
Thanks
This is a great video. I tried replicating this for updating a SQL table but when I get to the part where we create Screen2 as a form and then join it to the dataset, it doesn't automatically generate the form for me. I have to manually insert the fields and they just appear as cards with the field name and no passthrough of data from screen1.
I will have to look at your Ap & BI report in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hello Reza, I have a question, will direct query work with business central, there is not a lot of info online regarding the Business Central - Power BI - Power apps, Thank you so much
I have done no work with business central and not sure if direct query is supported. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Nice video, thank you!
Glad you liked it!
Great video, very great tutorial on some really awesome features!
Thanks so much!
Hi Reza, This is really very good and awesome option. You have explained it really well and I enoyed every bit of it. Just one request if its possible. Can you share the pbix file used in thsi video. Another question is regarding the power apps licensing. Can you please cover that as well.
PBIX file is tied to my datasource so would cause issues if I share.
Licensing - both power bi and power apps licensing will be needed.
@@RezaDorrani Ok. Thank you so much. What kind of Power Apps license is needed? If possible can you put a short video w.r.t. this.
@@lovenisarg Power Apps license depends on connectors used.
I have a lot of videos lined up. Will not be getting to this one anytime this year :)
@@RezaDorrani Ohh ok. Thank you so much.
Hi Reza,
At 23.56 you have TextInput1 in your patch function, should't that be refering to the drop down list name?
I did this video a long time ago and hence do not remember the specifics.
hi looks good but i need to update multiple records now?
It is possible but I do not have a specific video on it with power bi. I have done videos on bulk update scenarios. You would need to merge logic between 2 videos.
can you share that video links@@RezaDorrani
@@TheQuotists A simple search on UA-cam will get you there “Reza Dorrani Bulk Updates Power Apps”
Yeah now I have create same power app which you have created but in gallery screen I have created a buttons to update bulk records but I don’t know what function should use to update my records.could you help me out this.I am able to select multiple records but know I need to update that records
With help of that bulk update button
By clicking that button it should navigate to edit screen and there I will update.
Could you help what function should I use in that button
@@inspiretheworld6121 I do not have a specific video reference on this and would have to try it out to provide guidance.
It would be best to post your issue/query with screenshots on the forums at powerusers.microsoft.com
Hey Reza - I'm following your steps and see the PowerBIIntegration object, but the App isn't recognizing any of the fields I added to the Power Apps visualization in the Power BI report. Where would you start to diagnose this?
Try following the video step by step again :)
I have not come across that issue hence not sure.
@@RezaDorraniI missed that the steps in Power BI need to be taken in the service, and not through the desktop app. That's a different experience than I'm used to, like how we can integrate Power Automate through the desktop app.
Really good job
Thanks
Hi Reza, can we use oracle sql server as Data Source and perform the writeback.
May be but not something I have tried
Reza, I wanted to do that but my source was a SQL server table, how do I do a Power Automate that will check and add new rows to Sharepoint? And update the existing ones with new data from SQL?
I do not have a video reference on SQL scenario and would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Great Video Reza
Thanks
Hi Reza, This is very helpful. if you have explained how the bulk update is happened step by step then it will be very helpful for me. can you please explain step by step how you have updated in bulk.
I have done multiple videos on bulk updates. You can check the logic in those videos and apply it to this technique
@@RezaDorrani Thank you so much for the reply.
Hi Reza,
I have a question can we do same process if my data source is a CSV file.
And I have created reports using CSV file and want to write back to csv file or dataset using a powerapp visual form in reports.
Not sure! Have not tried this before. As long as you can connect to it from power apps, I would say yes.
Hi Reza, so the whole dataset had to be refreshed to reflect the edited or new record? If I want to see the result of every record I add/edit, has to refresh whole dataset many many times…..one of the table in my dataset has more than 10mil records. The write back table actually only have about 1k records. Any suggestions? Thanks
We are refreshing the visuals not the dataset. This is for directquery mode.
Tha la for the video Reza
Even after saving power app, I am not seeing the same in powerbi.
Still showing like
"Go to power app studio"
ANY SUGGESTION PLEASE
Not sure. Might be something related to your environment.
Hi Reza, regarding creating relation between person type column in SharePoint list with user information list of sharepoint. I have challenges since i have two person type column, which needs separate relation. How to achieve this?
Not sure about that as I have not tried that.
I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Awesome case.... 👏
Thanks
This is treasure
Thanks
Is there a way to do this if the datasource isn't a Sharepoint List?
For example, if I create a manual table in PowerBI can I update that table with PowerApps?
I see the data from that table, but it doesn't appear to allow me to change it when I add the EditForm.
Concept will work with data sources that one can write to from Power App. Power BI tables are read only.
Great explanation Reza
Thanks
Hi Raza,
Is there anyway we can loadpowerBicontent of power bi tile used in power app on appstart?
Im not aware of a way to do that
Hi ,
I have a power BI report I've integrated with power apps the report has a column of date. i need the power apps to show this date exactly like it in the Power BI
Please suggest
Whatever format power apps gets the date it, you can use formulas to convert it to same format as in power bi. I will recommend posting your query with screenshots on the forums at powerusers.microsoft.com
Hi Reza , Nice information but facing some issues . I have a Power BI Pro License and Power Apps with standard license designation . I followed the video and created Powerapp visual however after closing powerapp browser it does not refresh in BI report and shows blank . Any idea is it due to License issues or any other possible issue
Refresh has nothing to do with license. The datasource you are connecting to in power app drives the license. Im guessing something is not done correctly in your scenario that’s causing an issue. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Hi reza,
is it compulsory a primary key in a table to write back functionality ?
SharePoint Lists and Dataverse Tables already have that.
If its a SQL table, then a primary key is needed.
@@RezaDorrani thanks for replied
@@RezaDorrani can you please send a link Microsoft documentation
It's very helpful
@@mukhayyarmohammed5874 You will need to check it out. I dont have the link.
Here is the general documentation link
learn.microsoft.com/en-us/power-apps/
Hey Reza,
I was wondering if we have a video on How to connect a model driven app with SQL database / Relational database?
Thanks
I do not have one. As far as I know, model-driven apps requires your data to be in Dataverse.
@Reza Dorrani Thanks reza. 😊
Hi Reza, thanks a ton. But in my case- Gallery is selecting the data from the first row by default. May I know how to avoid this. If i make screen as home screen, On the load everytime i am seeing the data for the first row. Is there a way to remove this or add text to selectl ?
Try setting default value of gallery to {}
If it does not work, then I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani Thanks Much Reza. It did't worked for me.
@@hemanthu9018 Then please post on forums
@@RezaDorrani yes Reza I have posted. Hope i can get answer.
@@hemanthu9018 Forums is a free platform. You may or may not get a response and you have to be patient.
hi Reza, i created the same but i did the lookup in gallery since my scenario is "Role" be selected in PBI then multiple name should show in power apps Gallery but it is only showing "First result". Was wonsering if it is possible to do lookup but getting all result and not just first?
Lookup function only returns single row.
Im not sure what Role means in your scenario.
I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com