Тёмный

Power BI Write Back to Database | Write Back Query | Using Power Apps in Power BI| User Input in PBI 

Life of Business Analyst
Подписаться 2,7 тыс.
Просмотров 13 тыс.
50% 1

This is a short video explaining how to write back data to SQL server database using Power Apps in Power BI.
Using a Power Apps and Form , the PBI allows the users to input the data back to SQL Server. Please watch the video for more details.

Наука

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

 

9 июл 2022

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 29   
@asifmeo2081
@asifmeo2081 8 месяцев назад
ThanK you Boss You Make my Life Easy With the help Of this video
@anil1kuna
@anil1kuna Год назад
good Content, Thanks👍
@LifeofBusinessAnalystLoBA
@LifeofBusinessAnalystLoBA Год назад
Thank you !
@soy_leche
@soy_leche Год назад
YESSSSSSSSSSSSSS, thank you!!
@LifeofBusinessAnalystLoBA
@LifeofBusinessAnalystLoBA Год назад
Thank you for watching.
@crixcel8388
@crixcel8388 7 месяцев назад
Do you have a video with Dataverse as the dataset, or any direct query video
@sameerulhaq4066
@sameerulhaq4066 10 дней назад
what if I want it to detect order ID from the one selected from the filter and user email to be also detected automatically. Basically like the user cant change the email or order ID it detects that automatically and he only adds comments. I want to it to detect order ID based on filter selected or the row he selects from table graph, then time and date according to system dare and user email to be detected automatically and he can only add comments and it gets saved and then then he can add different comment and it adds another one in the file and doesnt delete the previous one?
@zingereli
@zingereli Год назад
Hey, Thanks for the explanation! Do I have to duplicate my table? Is it possible to simply insert identity into the existing table and have it perform the writing to the DB?
@LifeofBusinessAnalystLoBA
@LifeofBusinessAnalystLoBA Год назад
No need to duplicate if you are the admin of the table and have write permissions
@sowjanyam250
@sowjanyam250 Год назад
Great Video Bro
@LifeofBusinessAnalystLoBA
@LifeofBusinessAnalystLoBA Год назад
Thank you
@sowjanyam250
@sowjanyam250 Год назад
is their a way of write back data from Power BI Service to Data Source like SQL
@LifeofBusinessAnalystLoBA
@LifeofBusinessAnalystLoBA Год назад
@@sowjanyam250 you have to build in desktop and publish in service.. this is exactly what is explained here.. please watch once again because it’s slightly complex
@AbhijeetBehuriavlogs
@AbhijeetBehuriavlogs Год назад
Bro is that View Or Table, that you are using in power BI ? Whether the Power bi data source and Power app data source need to same or Not ??
@fullsunflower5431
@fullsunflower5431 3 месяца назад
Thank you for your sharing, is that app can run when the Power BI publish in web? So not only in desktop app?
@LifeofBusinessAnalystLoBA
@LifeofBusinessAnalystLoBA 3 месяца назад
Yes, it can run in web also..
@PraveenKumar-sk4qt
@PraveenKumar-sk4qt Год назад
Good one👏 once you pulish to cloud bi, can you make the changes and refresh from cloud from end user point of view? Please let me know
@LifeofBusinessAnalystLoBA
@LifeofBusinessAnalystLoBA Год назад
Yes, the end user can update records if you provision them write access to the table. The changes will reflect in pbi immediately if it’s a live query. If it’s not a live connection , then it will reflect once you schedule auto refresh in power bi using gateway.
@subhamdutta516
@subhamdutta516 Год назад
Really helpful and it would be more helpful if you just tell me how can we add a new comment for a non existing row of user table? Like whenever user comment Comment ID, Created Dated, Created by, Comments........like that will appear
@lekerov
@lekerov 7 месяцев назад
same request, did you find any solution?
@nileshnayak7553
@nileshnayak7553 8 месяцев назад
Do you have any video where we navigate between 2 or multiple screens when we click on "NextArrow1" ? How can we navigate between EditForm1 and EditForm2 based on some conditions?
@LifeofBusinessAnalystLoBA
@LifeofBusinessAnalystLoBA 8 месяцев назад
You can write custom functions using logical statements. Go to properties of button and select on click , type in your condition so that if a particular condition satisfies it navigates to a particular screen..
@riyaz2727
@riyaz2727 Год назад
can you provide that tables data type im having issue with data types
@satishkumar-ir9wy
@satishkumar-ir9wy 11 месяцев назад
hi, once i publish my dashboard having power app in it, is it required for all users to have access to database with write access? Also it is asking me to share the app with users.
@LifeofBusinessAnalystLoBA
@LifeofBusinessAnalystLoBA 11 месяцев назад
Hi, use service account instead of windows login while you configure data in power app so that it works for any users. Yes the users should have permission to use the app. Make it available at organization level.
@ASHUKUMAR-vq8vy
@ASHUKUMAR-vq8vy Год назад
Is it possible to remove filter in direct query mode?
@LifeofBusinessAnalystLoBA
@LifeofBusinessAnalystLoBA Год назад
I really haven’t tried direct query mode much because the server takes a lot of load and number of rows limitations
@user-tq2ki5gy9l
@user-tq2ki5gy9l 5 месяцев назад
It looks you are using Import mode... what if i use Direct query??
@LifeofBusinessAnalystLoBA
@LifeofBusinessAnalystLoBA 5 месяцев назад
Direct query does not support all the functions..
Далее
BULK Write Back to SQL from Power BI
11:40
Просмотров 31 тыс.
Power BI: Write back using Power Apps!
17:17
Просмотров 4,8 тыс.
Using PowerApps Visual in Power BI (Integration)
38:38
Просмотров 101 тыс.
Write-back with Power Apps in Power BI
46:51
Просмотров 7 тыс.
Auto refresh Power BI Controls inside Power Apps
16:55
Solving one of PostgreSQL's biggest weaknesses.
17:12
Просмотров 177 тыс.
Power BI - Write Data to SQL
9:49
Просмотров 60 тыс.
ПОКУПКА ТЕЛЕФОНА С АВИТО?🤭
1:00
ПОКУПКА ТЕЛЕФОНА С АВИТО?🤭
1:00