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

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

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

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

[@BhBh995]

I saw many videos on this exact topic, but you explained it the best out of everyone, thank you so much 😁

[@RezaDorrani]

Awesome! Thanks so much

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

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

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

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

[@shijujohn9969]

Excellent Tutorial ! Thank you

[@RezaDorrani]

You are most welcome!

[@LuanNguyen-pl2wf]

What a gem. thank you Reza!

[@RezaDorrani]

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

[@susanclark1778]

Thank you for this video - I appreciate you!

[@RezaDorrani]

You are so welcome!

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

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

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

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

[@manoplaeli4027]

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

[@RezaDorrani]

👍

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

[@mahamkhan8314]

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

[@RezaDorrani]

Most welcome

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

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

[@SandeepSingh-lg7bq]

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

[@RezaDorrani]

I read minds :)

[@Tubasnot]

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

[@RezaDorrani]

Thanks so much!

[@UU-ry6gt]

nice structured video! pls. keep posting!

[@RezaDorrani]

Thanks, will do!

[@moelmakrani7116]

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

[@RezaDorrani]

Thanks a ton!

[@helloranjan89]

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

[@RezaDorrani]

It's my pleasure

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

[@utubedeven]

Superb thanks Reza 🇭🇰

[@RezaDorrani]

Thanks

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

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

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

[@NikolasHunt-g4h]

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.

[@ShashiKotkar]

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.

[@ShashiKotkar]

@@RezaDorrani Thank you Reza

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

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

[@PedroSilva-hc2el]

Nice video, thank you!

[@RezaDorrani]

Glad you liked it!

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

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

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

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

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

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

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

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

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

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

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

[@nirajbaraili7128]

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 ?

[@RezaDorrani]

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.

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

[@raj7sam]

Awesome case.... 👏

[@RezaDorrani]

Thanks

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

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

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

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

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

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

[@helloranjan89]

This is treasure

[@RezaDorrani]

Thanks

[@deancoleman9829]

Great Video Reza

[@RezaDorrani]

Thanks

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

[@rohitpuri2634]

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 ?

[@RezaDorrani]

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.

[@adelinwong9918]

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!

[@RezaDorrani]

Power Apps can write data back to data source only. Not power bi matrix.

[@Filmy_recommends]

Great explanation Reza

[@RezaDorrani]

Thanks

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

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

[@gregoryb656]

Really good job

[@RezaDorrani]

Thanks

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

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

[@lubhit]

Hi Raza, Thanks for explaining it so well. Can I get access to the sharepoint list you used?

[@RezaDorrani]

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.

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

[@luigisir6893]

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

[@RezaDorrani]

Power Apps is not meant for importing and pushing data. It is not an ETL too. Use dataflows for that.

[@luigisir6893]

@@RezaDorrani ok txs x all

[@colgreg90]

Hi Reza, I am trying to create the app but when I get to the 4:55 point in the video my app does not have the fields that I selected under Title. If I try to enter ID after ThisItem. it does not work. My report is saved and published to the service so not sure what is missing. Are you able to please advise on how I could fix this, thank you

[@RezaDorrani]

I have not come across this issue hence not sure what the reason is.

[@colgreg90]

@@RezaDorrani thank you for your quick response. Is there a way I can write data to a Sharepoint list based on what is selected from the Gallery screen. At the moment I have created a sharepoint list with the 3 columns to match what is passed into the Power App Gallery. One field is always blank and needs to be updated within the app while the other is the ID and name column. Since there is no data in the SharePoint list, how would I create a new row based on the users selection. I am trying to figure out how I can modify from 11:00 but can't get it to work. Please advise, thank you

[@RezaDorrani]

@@colgreg90 I would have to try it out to provide the steps or know the options. I recommend checking or posting your query on forums in case someone has done something similar 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.

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

[@raj7sam]

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.

[@RezaDorrani]

2000 is a hard limit!

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

[@DanielWesterdale]

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?

[@RezaDorrani]

Should not be the case. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com/

[@DanielWesterdale]

@@RezaDorrani thanks, I will do that.

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

[@TheQuotists]

hi looks good but i need to update multiple records now?

[@RezaDorrani]

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.

[@TheQuotists]

can you share that video links@@RezaDorrani

[@RezaDorrani]

@@TheQuotists A simple search on KZbin will get you there “Reza Dorrani Bulk Updates Power Apps”

[@inspiretheworld6121]

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

[@RezaDorrani]

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

[@hibafatima7400]

Hi Reza, can we use oracle sql server as Data Source and perform the writeback.

[@RezaDorrani]

May be but not something I have tried

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

[@PavanKumar-eu5qg]

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

[@RezaDorrani]

Not sure. Might be something related to your environment.

[@mukhayyarmohammed5874]

Hi reza, is it compulsory a primary key in a table to write back functionality ?

[@RezaDorrani]

SharePoint Lists and Dataverse Tables already have that. If its a SQL table, then a primary key is needed.

[@mukhayyarmohammed5874]

@@RezaDorrani thanks for replied

[@mukhayyarmohammed5874]

​@@RezaDorrani can you please send a link Microsoft documentation It's very helpful

[@RezaDorrani]

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

[@cmlibin]

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

[@RezaDorrani]

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

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

[@aria4280]

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)

[@RezaDorrani]

Most welcome! Not possible to guess an issue here on chat. Best place to post issues is the forums at powerusers.microsoft.com/

[@BhBh995]

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

[@RezaDorrani]

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

[@yasaswibalaji7434]

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

[@RezaDorrani]

Yes

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

[@rubikarubi441]

Hi Reza Dorrani, What can I use Instead of refresh () function?

[@RezaDorrani]

to do what?

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

[@yashankupadhyay4627]

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

[@RezaDorrani]

What does after the dashboard mean?

[@distishpothanah2266]

Any tutorial how to do bulk update?

[@RezaDorrani]

Not for power bi as data source but here is a general video on bulk updates - kzbin.info/www/bejne/jKvVkqWZgp6Ka80si=3me3HgZeyQ5aQoI0

[@mattg1502]

Hi Reza, Is there a way to match the order of the items in the Power app gallery with the sort on the table in Power Bi?

[@RezaDorrani]

You would need to define your own order in apps by using sort function on items property of gallery.

[@mattg1502]

@@RezaDorrani Thank you so much for the response! I’ve become a member today! I understand the sorting (after the data is passed in). I suppose, my issue is from a UX point of view. I have created an PBI layout with a Power App on the right and tables, charts and filters on the left. All great (thanks to you). I've also used the prev/next record approach as I don't want to have list of items in the table and in the app. This is all working. But, let’s say the, table is filtered to 10 records. The prev/next record navigation works great for those 10 records. But, if I click a column and spot, changing the order, browsing prev and next remains in the same (Id Desc) order instead of the order of the table (now that I’ve clicked the column). I’m stumped. I thought maybe use Dax to add a column that holds a text value of the current sort or something. I really need to pass in the sort/order of the table so that my prev and next works correctly. I’m not a great communicator, so I’ve made a 90 second clip to demo my struggle: kzbin.info/www/bejne/fojGmoRtqaahbKM

[@RezaDorrani]

@@mattg1502 Hi Matt, thanks for sharing the details. Sadly, I do not have any bandwidth to review or provide the solution. It would be best to post your issue with screenshots on the forums at powerusers.microsoft.com/