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

Подписаться 131 тыс.

Просмотров 140 тыс.

50% 1

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

Опубликовано:

1 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 371

@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 4 месяца назад

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 9 месяцев назад

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

@RezaDorrani 9 месяцев назад

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

@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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-byUuEoDQjiU.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 11 месяцев назад

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 11 месяцев назад

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 6 месяцев назад

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

@RezaDorrani 6 месяцев назад

Glad it was helpful!

@susanclark1778 8 месяцев назад

Thank you for this video - I appreciate you!

@RezaDorrani 8 месяцев назад

You are so welcome!

@LuanNguyen-pl2wf Год назад

What a gem. thank you Reza!

@RezaDorrani Год назад

Most welcome

@manoplaeli4027 2 года назад

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

@RezaDorrani 2 года назад

👍

@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 ru-vid.com/group/PLTyFh-qDKAiEUf5st2WhUzgoDRF-1hET0

@harshshah5947 9 месяцев назад

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

@RezaDorrani 9 месяцев назад

Most welcome!

@harshshah5947 9 месяцев назад

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

@RezaDorrani 9 месяцев назад

@@harshshah5947 SQL is also possible

@helloranjan89 Год назад

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

@RezaDorrani Год назад

It's my pleasure

@moelmakrani7116 Месяц назад

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

@RezaDorrani Месяц назад

Thanks a ton!

@mahamkhan8314 5 месяцев назад

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

@RezaDorrani 5 месяцев назад

Most welcome

@syringan2.015 Год назад

You're a lifesaver Tqq 🎉

@RezaDorrani Год назад

Most welcome

@utubedeven 2 года назад

Superb thanks Reza 🇭🇰

@RezaDorrani 2 года назад

Thanks

@Tubasnot 2 года назад

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

@RezaDorrani 2 года назад

Thanks so much!

@UU-ry6gt 2 года назад

nice structured video! pls. keep posting!

@RezaDorrani 2 года назад

Thanks, will do!

@PedroSilva-hc2el 9 месяцев назад

Nice video, thank you!

@RezaDorrani 9 месяцев назад

Glad you liked it!

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

@raj7sam 2 года назад

Awesome case.... 👏

@RezaDorrani 2 года назад

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

@SandeepSingh-lg7bq 2 года назад

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

@RezaDorrani 2 года назад

I read minds :)

@gregoryb656 Год назад

Really good job

@RezaDorrani Год назад

Thanks

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

@Filmy_recommends 2 года назад

Great explanation Reza

@RezaDorrani 2 года назад

Thanks

@deancoleman9829 Год назад

Great Video Reza

@RezaDorrani Год назад

Thanks

@vasudevanjambulingam7635 8 месяцев назад

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 8 месяцев назад

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 3 месяца назад

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

@RezaDorrani 3 месяца назад

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.

@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

@helloranjan89 2 года назад

This is treasure

@RezaDorrani 2 года назад

Thanks

@arshadshaik3020 2 года назад

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

@RezaDorrani 2 года назад

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

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

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

@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

@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 11 месяцев назад

Check channel memberships. I have gone live with a training tier that you can sign up for now. ru-vid.comjoin

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

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

@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

@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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-6KlI1iZ_KD0.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

@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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-DADWqlKdL3s.html

@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

@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

@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

@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 года назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Kupz71dWYyY.html may help

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

@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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-VzrarcM9W5k.html

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

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

@TheQuotists 9 месяцев назад

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 9 месяцев назад

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.

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

@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

@imalkamadhushani4701 3 месяца назад

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 3 месяца назад

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

@imalkamadhushani4701 3 месяца назад

@@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 3 месяца назад

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

@imalkamadhushani4701 3 месяца назад

@@RezaDorrani No problem Thanks!

@user-jk3zb3up3y 9 месяцев назад

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 9 месяцев назад

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 9 месяцев назад

@@RezaDorrani Thank you Reza

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

@imalkamadhushani4701 4 месяца назад

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 4 месяца назад

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

@imalkamadhushani4701 4 месяца назад

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

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

@felixvalembois9596 5 месяцев назад

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 5 месяцев назад

Can be done with SQL

@rahulhadapad5036 8 месяцев назад

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 8 месяцев назад

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 8 месяцев назад

@@RezaDorrani Cheers

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

@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

@gabriellac.4894 2 месяца назад

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 2 месяца назад

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 2 месяца назад

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.

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

@fernandofilloy3990 5 месяцев назад

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 5 месяцев назад

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 5 месяцев назад

many thanks!!!! @@RezaDorrani

@user-nm9rs6ge4q 6 месяцев назад

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 6 месяцев назад

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

@kennethgottfredsen767 3 месяца назад

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

@RezaDorrani 3 месяца назад

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

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

@chuyvarela3113 6 дней назад

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 6 дней назад

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.

@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

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

@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

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

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

@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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-P6yqIpjmPrs.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

@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

@VickneshWaran 6 месяцев назад

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 6 месяцев назад

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

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

@hibafatima7400 8 месяцев назад

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

@RezaDorrani 8 месяцев назад

May be but not something I have tried

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

@eloisamarieiniego1070 10 месяцев назад

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 10 месяцев назад

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

@jovennservant 2 года назад

This is amazing! Hoping you would be able to send me a copy of the power bi. Thanks!

@RezaDorrani 2 года назад

I probably do not even have the power bi report anymore + you would need the database configured. Best would be to build your own.

@bc67 5 месяцев назад

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 5 месяцев назад

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

@bc67 5 месяцев назад

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

@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

@rubikarubi441 2 года назад

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

@RezaDorrani 2 года назад

to do what?

@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

@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

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

@yashankupadhyay4627 2 месяца назад

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

@RezaDorrani 2 месяца назад

What does after the dashboard mean?

@tarunaneja7802 2 года назад

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 2 года назад

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 2 года назад

@@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 2 года назад

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