Write Back in Power BI with Power Apps Visual | Input Data from Power BI Tutorial

[@RKTECH1021]

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.

[@RezaDorrani]

Thank You so much! Glad it was helpful!

[@subrahmanyamgurram4469]

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.

[@mattmauren9287]

This is HANDS DOWN one of the very best Microsoft Power Suite demonstrations I have ever seen. Thank you for sharing this!

[@RezaDorrani]

Wow, thanks!

[@lannieplannie]

This was the best, most comprehensive look at how to push data into your data source using PBI and PowerApps. Thank you!

[@RezaDorrani]

Wow! Thanks Lannie

[@tonykuiper9127]

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!

[@RezaDorrani]

Great to hear that!

[@johng5295]

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++

[@RezaDorrani]

Wow! Thanks so much for all the compliments.

[@JanHavlis-ri8wn]

🎯 Key points for quick navigation: 00:28 *📊 Power BI reports can visualize data from various sources, including SharePoint lists for tracking issues.* 01:53 *🔄 Power BI datasets are read-only, necessitating Power Apps for write-back operations like CRUD actions on SharePoint lists.* 04:24 *📱 Power Apps Visual in Power BI allows creating custom apps directly linked to Power BI data, enabling dynamic data interactions.* 07:47 *🎛️ Power Apps integrated with Power BI respects filters applied in Power BI visuals, ensuring synchronized data views.* 10:49 *🛠️ Power Apps can perform CRUD operations directly on data sources like SharePoint lists connected via Power BI.* 14:19 *🔄 Data refresh in Power BI is required to reflect changes made via Power Apps on SharePoint lists, especially in import query mode.* 16:10 *🗑️ Deleting records from SharePoint lists via Power Apps requires manual refresh in Power BI to reflect the changes.* 19:30 *🔄 For near real-time updates, use Power BI with Direct Query mode and Power Apps to update data dynamically.* 23:35 *🔄 Use `Power BI Integration.Refresh` function in Power Apps to dynamically refresh Power BI visuals after data updates for a real-time data experience.* Made with HARPA AI

[@RezaDorrani]

Thanks for sharing

[@davidrico8755]

I'm literally learning how to use these amazing tools off your videos. Keep on going Reza your amazing. A true pro.

[@RezaDorrani]

Happy to hear that!

[@irenepablo2971]

Wow, one video served me better than 2 Udemy courses. This is awesome, thank you!

[@RezaDorrani]

Glad it was helpful!

[@MrNarasimhakumar]

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.

[@RezaDorrani]

Glad to hear that! Thanks for watching

[@eagillum]

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)

[@RezaDorrani]

Thanks for bookmarks

[@datasapien]

Working on this today with your older video, great to have the new one...thanks

[@RezaDorrani]

Awesome! Thanks for watching both.

[@AnilKumar-fr9jo]

Simply ... Brilliant ... 5* ... Thanks Reza and Please make more videos , which show integration between Power App-BI-Automate....

[@RezaDorrani]

Thanks Anil! My playlist on integration is growing kzbin.info/aero/PLTyFh-qDKAiEUf5st2WhUzgoDRF-1hET0

[@xyxu4261]

Hi Reza, this is really awesome! Can you please also make a video to explain how the bulk update works?

[@RezaDorrani]

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.

[@harshshah5947]

Superb! Could’nt ask for anything more. Very well explained with a fantastic example. Thank you so much👍

[@RezaDorrani]

Most welcome!

[@harshshah5947]

I would like to know whether we can write back to SQL database as well as we can do it with spreadsheets

[@RezaDorrani]

@@harshshah5947 SQL is also possible

[@TheKermit2110]

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 :-))))))))

[@RezaDorrani]

Thanks so much. Feedback is noted. Much appreciated

[@moelmakrani7116]

Reza, this is such a great video, well done man! ❤

[@RezaDorrani]

Thanks a ton!

[@manoplaeli4027]

Thank Rena, think is what the world need 👏🏻👏🏻👏🏻

[@RezaDorrani]

👍

[@SandeepSingh-lg7bq]

Thanks Reza, since today I was started working the same 😂😂😂😂 what a coincidence ....

[@RezaDorrani]

I read minds :)

[@oluwatobiyusuf]

Thanks for this awesome video. I gained a lot as usual but I am more fascinated by the visual refresh function with direct query

[@RezaDorrani]

You're very welcome!

[@vikasrawat3752]

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. 👍👍👍🙏

[@RezaDorrani]

Glad it was helpful! Thank You so much for watching and liking the videos.

[@indeedmanish9990]

Hi Reza , I learned a lot via this video. However can you make a video on writeback to redshift via power app

[@RezaDorrani]

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.

[@susanclark1778]

Thank you for this video - I appreciate you!

[@RezaDorrani]

You are so welcome!

[@mahalakshmidevarajan6656]

Very nice video and good learning first time watching the integration with power bi. Your video made me to learn alot 🙂.

[@RezaDorrani]

Glad to hear that!

[@LuanNguyen-pl2wf]

What a gem. thank you Reza!

[@RezaDorrani]

Most welcome

[@helloranjan89]

This is a life saver and i can't thank you more 🙏 ❤️ plz keep educating us

[@RezaDorrani]

It's my pleasure

[@jjpp1970]

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.

[@RezaDorrani]

Dataverse for the win! I recently did a Dataverse intro video that might interest you kzbin.info/www/bejne/mKq4pnilebadn7c

[@syringan2.015]

You're a lifesaver Tqq 🎉

[@RezaDorrani]

Most welcome

[@gregoryb656]

Really good job

[@RezaDorrani]

Thanks

[@owlesymp]

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.

[@RezaDorrani]

2000 is a hard limit!

[@vasudevanjambulingam7635]

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

[@RezaDorrani]

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.

[@yaswanthkumar2239]

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

[@RezaDorrani]

I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

[@mahamkhan8314]

Woah this is so cool. Very thoroughly explained. Thank you so much Reza.

[@RezaDorrani]

Most welcome

[@utubedeven]

Superb thanks Reza 🇭🇰

[@RezaDorrani]

Thanks

[@imalkamadhushani4701]

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]

You should not have to build app again. Best to do a quick proof of concept to confirm the behavior.

[@imalkamadhushani4701]

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

[@RezaDorrani]

@@imalkamadhushani4701 I do not have a specific video reference on that

[@imalkamadhushani4701]

@@RezaDorrani No problem Thanks!

[@Carpaltunnelgadgets]

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?

[@RezaDorrani]

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

[@user-nm9rs6ge4q]

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?

[@RezaDorrani]

I am not aware of the ALM friendliness of power apps visual in power bi. I believe that story is still weak.

[@mtiedtke13]

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!

[@RezaDorrani]

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.

[@UU-ry6gt]

nice structured video! pls. keep posting!

[@RezaDorrani]

Thanks, will do!

[@chuyvarela3113]

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.

[@RezaDorrani]

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.

[@fernandofilloy3990]

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

[@RezaDorrani]

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.

[@fernandofilloy3990]

many thanks!!!! @@RezaDorrani

[@s.p.bigbird1719]

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?

[@RezaDorrani]

Power apps cannot filter power bi

[@PedroSilva-hc2el]

Nice video, thank you!

[@RezaDorrani]

Glad you liked it!

[@Amber-ds3jn]

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.

[@RezaDorrani]

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

[@UX_Reviews]

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?

[@RezaDorrani]

If you add/update data via power app visual to database and then refresh the power bi using formula shown in video then yes.

[@UX_Reviews]

@@RezaDorrani Cheers

[@Tubasnot]

Great video, very great tutorial on some really awesome features!

[@RezaDorrani]

Thanks so much!

[@alaa_mustafa]

I'm trying to complete this step however I'm facing issue with ID, although ID number format in power bi. they appear all with the value of 1

[@RezaDorrani]

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

[@TheQuotists]

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

[@RezaDorrani]

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.

[@jesl-pl4sh]

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.

[@RezaDorrani]

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

[@jesl-pl4sh]

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

[@RezaDorrani]

@@jesl-pl4sh I do not have a reference video on this scenario. You can try posting your query on forums powerusers.microsoft.com

[@imalkamadhushani4701]

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.

[@RezaDorrani]

Have you followed steps in video? You need to publish report to PBI service and then add power app from there

[@imalkamadhushani4701]

@@RezaDorrani Really sorry that was what I missed. Thank you very much!

[@JordivanKaam]

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?

[@RezaDorrani]

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

[@NANA-bt6ws]

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.

[@RezaDorrani]

Concept will work with data sources that one can write to from Power App. Power BI tables are read only.

[@abhijitsaran12]

When I select Default Mode as Edit for SP connection in screen 2, the screen never pulls up. Any where I am messing.

[@RezaDorrani]

Check how you are defining the item property for the Form control.

[@majdyazigi8185]

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!

[@RezaDorrani]

Power Apps Training - I am planning live training sometime this year. You would need to use expressions to convert the date field.

[@RezaDorrani]

Check channel memberships. I have gone live with a training tier that you can sign up for now. kzbin.infojoin

[@jesseli2574]

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

[@RezaDorrani]

We are refreshing the visuals not the dataset. This is for directquery mode.

[@mahmutolcaycelik1909]

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

[@RezaDorrani]

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.

[@mahmutolcaycelik1909]

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

[@RezaDorrani]

@@mahmutolcaycelik1909 Let me know!

[@deancoleman9829]

Great Video Reza

[@RezaDorrani]

Thanks

[@raj7sam]

Awesome case.... 👏

[@RezaDorrani]

Thanks

[@gaganbansal386]

For live refresh, I have my data coming from SQL Server database as direct query. But after updating the data from the app, my other visuals are not showing the updated data.

[@RezaDorrani]

I have not come across this issue & hence not sure what the resolution is. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

[@kennethgottfredsen767]

Hi Reza, At 23.56 you have TextInput1 in your patch function, should't that be refering to the drop down list name?

[@RezaDorrani]

I did this video a long time ago and hence do not remember the specifics.

[@StevenErnst-bk5zt]

Hi Reza, For some reason on my Power BI, after I select the Power Apps visualization then select items from fields view, the Power Apps won't change to "Choose App" or "Create New". Is there something I need to do with my Sharepoint List data for it to connect to the Power Apps in Power BI? I just can't figure out what I am doing wrong. Thank!

[@RezaDorrani]

I have not faced this issue hence not sure. It has nothing to do with data source. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

[@bc67]

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?

[@RezaDorrani]

Try following the video step by step again :) I have not come across that issue hence not sure.

[@bc67]

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

[@crazyforbike01]

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

[@RezaDorrani]

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

[@felixvalembois9596]

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 ?

[@RezaDorrani]

Can be done with SQL

[@helloranjan89]

This is treasure

[@RezaDorrani]

Thanks

[@yashankupadhyay4627]

Can we input data from our self after the dashboard with use of visuals

[@RezaDorrani]

What does after the dashboard mean?

[@unni9942]

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

[@RezaDorrani]

I have done multiple videos on bulk updating data using collections. Check kzbin.info/www/bejne/jKvVkqWZgp6Ka80

[@VickneshWaran]

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?

[@RezaDorrani]

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

[@magnolita999]

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?

[@RezaDorrani]

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

[@eloisamarieiniego1070]

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?

[@RezaDorrani]

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

[@ChandanKumar-qe8uo]

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.

[@RezaDorrani]

Not sure! Have not tried this before. As long as you can connect to it from power apps, I would say yes.

[@vijayvizzu1]

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

[@RezaDorrani]

One cannot pass the slicer values to Power Apps. Power Apps only gets the data set from Power BI.

[@vijayvizzu1]

@@RezaDorrani Thank you for quick reply :)

[@gabriellac.4894]

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?

[@gabriellac.4894]

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

[@RezaDorrani]

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.

[@fuzelshaikh3278]

Can I connect sharepoint list directly to on prem SLQ server? Didd't find any feasible solution

[@RezaDorrani]

I dont think that is possible. Not come across this scenario. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

[@tarunaneja7802]

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.

[@RezaDorrani]

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

[@tarunaneja7802]

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

[@RezaDorrani]

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

[@nasseralzeidi1043]

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

[@RezaDorrani]

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

[@lovenisarg]

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.

[@RezaDorrani]

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.

[@lovenisarg]

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

[@RezaDorrani]

@@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 :)

[@lovenisarg]

@@RezaDorrani Ohh ok. Thank you so much.

[@danielfoster3438]

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.

[@RezaDorrani]

kzbin.info/www/bejne/gabTq2pnmbyMr7s may help

[@natebig]

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?

[@RezaDorrani]

For Direct Query mode, you can initiate N number of PowerBIIntegration.Refresh() since all it does is refreshes the Visuals.

[@arshadshaik3020]

Thanks for this really helpful, instead of using page filters can we create same slicers visual on report page for filtering purpose?

[@RezaDorrani]

I believe Yes. I have not tried that scenario though.

[@HollyA.-go8lz]

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]

Wonderful! Here is a video on sorting kzbin.info/www/bejne/bHzPemSfj8R-epI

[@HollyA.-go8lz]

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

[@RezaDorrani]

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

[@s.p.bigbird1719]

Hi Reza, the Formula you show at 11:16 "LookUp('Issue Tracking', ID = Value(Gallerie1.selected.ID)) don't work if i use DataVerse as Datasource. I don't have a ID Column in Dataverse instead i use the DataVerse Key for each Row. But i dont get the Data via the LookUp Function

[@RezaDorrani]

Because I used SharePoint as a data source at 11:16 and not Dataverse. Please check the whole video.

[@s.p.bigbird1719]

Thx for your quick answer. I did , often :D But in the video there is only a explanation how to refresh data in case of Datasource Dataverse (Powerbi.refresh), but i dont find how to get the data from Dataverse in the form in PowerApps (LookUp?). In your Video there are already data in the App @@RezaDorrani

[@RezaDorrani]

@@s.p.bigbird1719 Check my playlist on Power BI. I may have shown that in some video.

[@user-jk3zb3up3y]

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

[@RezaDorrani]

Direct Query has no refresh limits since there is a direct call made to underlying data source each time user runs the report.

[@user-jk3zb3up3y]

@@RezaDorrani Thank you Reza

[@faizanzamir961]

Hi Reza, When I submit the form it gives me a patch function error as am not a Power Apps expert. Could you please help me how to fix this error? “Network error when using Patch function: The requested operation is invalid.”

[@RezaDorrani]

I have not come across this issue 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

[@serafinesalexon]

Hi, Reza, can you show me how to do it using SmartSheet? Thanks

[@RezaDorrani]

I dont plan to make a follow up video on this topic.

[@SuperJananie]

Hi Reza, I was trying to create report in Power Bi desktop. There i can see Power Apps visual but someone mentioned before, when i try to add, save, publish and close it, I couldn't see it updated in the Power BI desktop report. Even I tried just creating the report, publish it online and try to edit report in Power BI Service online. But i couldn't see Power apps visual under Visualization section, while editing in Power BI online. Any help would be highly appreciated!

[@RezaDorrani]

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

[@edwingarcia6390]

Hey Reza, I don’t know if you know the answer but when I try to look up the id from the gallery it says the form isn’t connected to any data yet but it’s connected to my share point list

[@RezaDorrani]

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

[@bhaskarlahari1666]

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.

[@RezaDorrani]

I have done multiple videos on bulk updates. You can check the logic in those videos and apply it to this technique

[@bhaskarlahari1666]

@@RezaDorrani Thank you so much for the reply.

[@natebig]

Is there a way for me to have my gallery empty unless a filter is applied? So in Power BI if a filter has not been selected, I don't want the Power App gallery to show anything.

[@RezaDorrani]

I don’t think there is a way to do that.

[@jennakuzyk3716]

Does this feature work with model driven apps?

[@RezaDorrani]

No

[@alejandrorodriguezgarcia4534]

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!

[@RezaDorrani]

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 kzbin.info/www/bejne/enKniKSigMl_adU

[@shafietullah993]

Hello sir. Since my data is coming from snowflake to power bi, i am unable to update data source. I have a custom column for comments. Is it possible to update only BI dataset?

[@RezaDorrani]

Power BI data set is read only and cannot be updated

[@yasaswibalaji7434]

Can we do bulk update for Sharepoint dataset instead of dataverse ??

[@RezaDorrani]

Yes

[@zhelinwang1716]

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.

[@RezaDorrani]

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

[@user-dq2fx1ow8e]

Why do I always get an error on my submit form functions - I checked all the resources and database and all spelled correctly. error text is: The data source supplied to the function is not valid

[@RezaDorrani]

Not sure as I would have to see your scenario in action. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

[@scharpealex4329]

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]

Not so sure about Dashboards. The refresh would be a limitation there.

[@scharpealex4329]

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

[@RezaDorrani]

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

[@selmifoued5768]

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

[@RezaDorrani]

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.

[@tombardsley3081]

Been trying to follow this and when I get to the editing of data, I’m getting a network error when using Patch function. The specified record was not found

[@RezaDorrani]

I have not faced this issue so not sure. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

[@tombardsley3081]

​@@RezaDorrani managed to fix it. My issue was with the data source

[@josephr2927]

HI Reza, For few power Bi reports the data is not flowing into power apps. What could be reason. I have created a new file then its flowing.

[@RezaDorrani]

Not sure why that would be the case as I have not experienced this.

[@ambarish360]

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?

[@RezaDorrani]

Check kzbin.info/www/bejne/hmfconymn9KDqNU

[@ambarish360]

@@RezaDorrani thanks a lot

[@ambarish360]

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.

[@RezaDorrani]

@@ambarish360 I do not have a video reference for those. I will recommend checking on the forums at powerusers.microsoft.com/

[@Filmy_recommends]

Great explanation Reza

[@RezaDorrani]

Thanks