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

Рет қаралды 134,882

Күн бұрын

In this video, I will show how to write back data to the data source from Power BI by using the Power Apps Visual.
Video tutorial shows how to add, update & delete data in data source directly from Power BI report by using the Power Apps Visual. The Power App will connect to the data source and perform the Write Back (CRUD) Operations.
We will leverage SharePoint as Data Source and perform the writeback.
I will also demonstrate how to leverage Dataverse for Write Back. Dataverse & SQL Support DirectQuery Import mode. This allows the Power App to initiate a near real time refresh of the Power BI Visuals from Power Apps by use the PowerBIIntegration.Refresh() function.
The Power App will get its data from the Power BI dataset.
Power BI DirectQuery mode Vs Import mode
docs.microsoft.com/en-us/powe...
Power BI Refresh Data
docs.microsoft.com/en-us/powe...
List of Power BI data sources and their supported refresh types
docs.microsoft.com/en-us/powe...
Table of Contents:
00:00 - Introduction to Power BI write back with Power Apps
00:46 - Can't input data from Powe BI as PBI datasets are Read-Only
02:19 - Power BI data Write Back with Power Apps
03:48 - Create Power App connected to Power BI
07:47 - Perform Update operation in Data Source from Power BI using Power Apps
16:38 - Add & Delete records in Data Source from Power BI using Power Apps
19:35 - Power BI WriteBack Data with Live Refresh (DirectQuery)
22:24 - Power BI Write Back Bulk Data with Live Refresh (DirectQuery)
23:58 - Subscribe to Reza Dorrani channel
🤝 Let’s connect on social:
🔗 LinkedIn: / rezadorrani
🐦 Twitter: / rezadorrani
#PowerBI #PowerApps #PowerPlatform #WriteBack

Пікірлер: 368

@RKTECH1021 2 жыл бұрын

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 2 жыл бұрын

Thank You so much! Glad it was helpful!

@subrahmanyamgurram4469 3 ай бұрын

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.

@lannieplannie 8 ай бұрын

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

@RezaDorrani 8 ай бұрын

Wow! Thanks Lannie

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

@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 2 жыл бұрын

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 2 жыл бұрын

Great to hear that!

@davidrico8755 2 жыл бұрын

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

@RezaDorrani 2 жыл бұрын

Happy to hear that!

@JanHavlis-ri8wn 12 күн бұрын

🎯 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 12 күн бұрын

Thanks for sharing

@jjpp1970 2 жыл бұрын

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 2 жыл бұрын

Dataverse for the win! I recently did a Dataverse intro video that might interest you kzfaq.info/get/bejne/mN-FqKigqbfOmYk.html

@datasapien 2 жыл бұрын

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

@RezaDorrani 2 жыл бұрын

Awesome! Thanks for watching both.

@MrNarasimhakumar 10 ай бұрын

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 10 ай бұрын

Glad to hear that! Thanks for watching

@vikasrawat3752 2 жыл бұрын

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 2 жыл бұрын

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

@irenepablo2971 5 ай бұрын

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

@RezaDorrani 5 ай бұрын

Glad it was helpful!

@manoplaeli4027 2 жыл бұрын

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

@RezaDorrani 2 жыл бұрын

👍

@susanclark1778 6 ай бұрын

Thank you for this video - I appreciate you!

@RezaDorrani 6 ай бұрын

You are so welcome!

@helloranjan89 Жыл бұрын

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

@RezaDorrani Жыл бұрын

It's my pleasure

@LuanNguyen-pl2wf Жыл бұрын

What a gem. thank you Reza!

@RezaDorrani Жыл бұрын

Most welcome

@harshshah5947 8 ай бұрын

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

@RezaDorrani 8 ай бұрын

Most welcome!

@harshshah5947 8 ай бұрын

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

@RezaDorrani 8 ай бұрын

@@harshshah5947 SQL is also possible

@oluwatobiyusuf 2 жыл бұрын

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 2 жыл бұрын

You're very welcome!

@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 kzfaq.info/sun/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

@mahamkhan8314 4 ай бұрын

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

@RezaDorrani 4 ай бұрын

Most welcome

@syringan2.015 Жыл бұрын

You're a lifesaver Tqq 🎉

@RezaDorrani Жыл бұрын

Most welcome

@moelmakrani7116 3 күн бұрын

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

@RezaDorrani 3 күн бұрын

Thanks a ton!

@mahalakshmidevarajan6656 2 жыл бұрын

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

@RezaDorrani 2 жыл бұрын

Glad to hear that!

@Tubasnot 2 жыл бұрын

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

@RezaDorrani 2 жыл бұрын

Thanks so much!

@utubedeven 2 жыл бұрын

Superb thanks Reza 🇭🇰

@RezaDorrani 2 жыл бұрын

Thanks

@PedroSilva-hc2el 8 ай бұрын

Nice video, thank you!

@RezaDorrani 8 ай бұрын

Glad you liked it!

@SandeepSingh-lg7bq 2 жыл бұрын

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

@RezaDorrani 2 жыл бұрын

I read minds :)

@UU-ry6gt 2 жыл бұрын

nice structured video! pls. keep posting!

@RezaDorrani 2 жыл бұрын

Thanks, will do!

@xyxu4261 10 ай бұрын

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

@RezaDorrani 10 ай бұрын

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.

@rthoughts7232 2 жыл бұрын

Awesome case.... 👏

@RezaDorrani 2 жыл бұрын

Thanks

@gregoryb656 Жыл бұрын

Really good job

@RezaDorrani Жыл бұрын

Thanks

@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

@Carpaltunnelgadgets 2 жыл бұрын

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 2 жыл бұрын

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

@binduhoney6717 Жыл бұрын

Great explanation Reza

@RezaDorrani Жыл бұрын

Thanks

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

@helloranjan89 Жыл бұрын

This is treasure

@RezaDorrani Жыл бұрын

Thanks

@vasudevanjambulingam7635 7 ай бұрын

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 7 ай бұрын

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.

@indeedmanish9990 2 ай бұрын

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

@RezaDorrani 2 ай бұрын

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.

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

@deancoleman9829 Жыл бұрын

Great Video Reza

@RezaDorrani Жыл бұрын

Thanks

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

@majdyazigi8185 2 жыл бұрын

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 2 жыл бұрын

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

@RezaDorrani 10 ай бұрын

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

@s.p.bigbird1719 10 ай бұрын

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 10 ай бұрын

Power apps cannot filter power bi

@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 kzfaq.info/get/bejne/bLGcfJSav8WvdGQ.html

@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

@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

@mtiedtke13 10 ай бұрын

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 10 ай бұрын

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.

@TheQuotists 8 ай бұрын

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 8 ай бұрын

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.

@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 kzfaq.info/get/bejne/jOCilNWUsp-7ZZ8.html

@alejandrorodriguezgarcia4534 2 жыл бұрын

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 2 жыл бұрын

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 kzfaq.info/get/bejne/eqd0itSdsMqwY6c.html

@danielfoster3438 2 жыл бұрын

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 2 жыл бұрын

kzfaq.info/get/bejne/gdugrZpiyb29qY0.html may help

@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

@mahmutolcaycelik1909 2 жыл бұрын

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 2 жыл бұрын

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 2 жыл бұрын

@@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 2 жыл бұрын

@@mahmutolcaycelik1909 Let me know!

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

@felixvalembois9596 4 ай бұрын

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 4 ай бұрын

Can be done with SQL

@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

@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 11 ай бұрын

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 11 ай бұрын

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

@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

@scharpealex4329 2 жыл бұрын

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 2 жыл бұрын

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

@scharpealex4329 2 жыл бұрын

@@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 2 жыл бұрын

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

@vijayvizzu1 2 жыл бұрын

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 2 жыл бұрын

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

@vijayvizzu1 2 жыл бұрын

@@RezaDorrani Thank you for quick reply :)

@user-jk3zb3up3y 8 ай бұрын

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 8 ай бұрын

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 8 ай бұрын

@@RezaDorrani Thank you Reza

@nirajbaraili7128 2 жыл бұрын

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 2 жыл бұрын

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.

@rahulhadapad5036 7 ай бұрын

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 7 ай бұрын

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

@rahulhadapad5036 7 ай бұрын

@@RezaDorrani Cheers

@imalkamadhushani4701 3 ай бұрын

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 3 ай бұрын

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

@imalkamadhushani4701 3 ай бұрын

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

@kennethgottfredsen767 2 ай бұрын

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

@RezaDorrani 2 ай бұрын

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

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

@imalkamadhushani4701 2 ай бұрын

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 2 ай бұрын

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

@imalkamadhushani4701 2 ай бұрын

@@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 2 ай бұрын

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

@imalkamadhushani4701 2 ай бұрын

@@RezaDorrani No problem Thanks!

@fernandofilloy3990 4 ай бұрын

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 4 ай бұрын

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 4 ай бұрын

many thanks!!!! @@RezaDorrani

@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

@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

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

@PavanKumar-eu5qg 2 жыл бұрын

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 2 жыл бұрын

Not sure. Might be something related to your environment.

@lovenisarg 2 жыл бұрын

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 2 жыл бұрын

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 2 жыл бұрын

@@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 2 жыл бұрын

@@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 2 жыл бұрын

@@RezaDorrani Ohh ok. Thank you so much.

@rubikarubi441 2 жыл бұрын

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

@RezaDorrani 2 жыл бұрын

to do what?

@rthoughts7232 Жыл бұрын

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!

@hibafatima7400 7 ай бұрын

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

@RezaDorrani 7 ай бұрын

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.

@user-nm9rs6ge4q 5 ай бұрын

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 5 ай бұрын

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

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

@fakharahmedkhan5157 2 жыл бұрын

Hey Reza, I was wondering if we have a video on How to connect a model driven app with SQL database / Relational database? Thanks

@RezaDorrani 2 жыл бұрын

I do not have one. As far as I know, model-driven apps requires your data to be in Dataverse.

@fakharahmedkhan5157 2 жыл бұрын

@Reza Dorrani Thanks reza. 😊

@rajendrakulkarni4815 2 жыл бұрын

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

@RezaDorrani 2 жыл бұрын

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

@ambarish360 2 жыл бұрын

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 2 жыл бұрын

Check kzfaq.info/get/bejne/hpyppKyhz9O0oqc.html

@ambarish360 2 жыл бұрын

@@RezaDorrani thanks a lot

@ambarish360 2 жыл бұрын

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 2 жыл бұрын

@@ambarish360 I do not have a video reference for those. I will recommend checking 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

@ritikawasthi2170 4 ай бұрын

Hi Raza, Is there anyway we can loadpowerBicontent of power bi tile used in power app on appstart?

@RezaDorrani 4 ай бұрын

Im not aware of a way to do that

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

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

@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

@yasaswibalaji7434 Жыл бұрын

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

@RezaDorrani Жыл бұрын

Yes

@yashankupadhyay4627 28 күн бұрын

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

@RezaDorrani 28 күн бұрын

What does after the dashboard mean?

@VickneshWaran 5 ай бұрын

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 5 ай бұрын

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

@prabhakaranshanmugam5295 2 жыл бұрын

Hi Please start a video series on Model Driven Apps and Portals.

@RezaDorrani 2 жыл бұрын

In my backlog. Will get to it in some time.

@eloisamarieiniego1070 8 ай бұрын

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 8 ай бұрын

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

@TheQuotists 8 ай бұрын

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

@RezaDorrani 8 ай бұрын

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 8 ай бұрын

can you share that video links@@RezaDorrani

@RezaDorrani 8 ай бұрын

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

@inspiretheworld6121 8 ай бұрын

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 8 ай бұрын

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

@bc67 3 ай бұрын

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 3 ай бұрын

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

@bc67 3 ай бұрын

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

@distishpothanah2266 7 ай бұрын

Any tutorial how to do bulk update?

@RezaDorrani 7 ай бұрын

Not for power bi as data source but here is a general video on bulk updates - kzfaq.info/get/bejne/jOCilNWUsp-7ZZ8.htmlsi=3me3HgZeyQ5aQoI0

@serafinesalexon 3 ай бұрын

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

@RezaDorrani 3 ай бұрын

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

@jennakuzyk3716 Ай бұрын

Does this feature work with model driven apps?

@RezaDorrani Ай бұрын

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