Sending Data from Power BI to SQL

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

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

50% 1

In this video tutorial, I am showing how to write back or sending data from Power BI to SQL table with DAX Studio.
LinkedIn Group: / 10525659
Download Sample Data: link-target.net/248698/sample...
(Click on the link and once page opens, scroll down, and click on Free Access)
MY FAVOURITE POWER BI BOOKS
📗 Microsoft Power BI Cookbook - amzn.to/3NXVksH
📕 The Definitive Guide to DAX - amzn.to/3pD8x1C
📗 DAX Patterns - amzn.to/46CcBji
📕 Storytelling with Data - amzn.to/439VO4j
📗 Pro Data Mashup for Power BI - amzn.to/3D0pgz8
📕 Beginning DAX with Power BI - amzn.to/3D0e85m
📗 Pro Power BI Architecture - amzn.to/3rdz1Y3
📕 Supercharge Power BI - amzn.to/44gdJHV
MY GEAR
🪑 Fabric Gaming Chair - amzn.to/44bSDu7
🎙 Lavalier Microphone - amzn.to/44dRMt2
💻 Dell Laptop - amzn.to/43dnrJZ

Наука

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

19 дек 2020

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

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

Thank you. this video made my day. Absolutely loved it.

@Chris_87BC 3 года назад

This is amazing!! that means that you can import into Power BI data from an Oracle server or from a remote desktop server and then send the data to a different server from DAX studio

@pbiEnglish 3 года назад

yes, you are right but sending is limited to SQL

@vittalprasadkothapalli6358 7 месяцев назад

Thanks for the video. Can you throw some light how can schedule this process to run on it’s own ?

@pbiEnglish 7 месяцев назад

It can't be automated

@kunalr_ai 3 года назад

Can we automate this with dax studio

@margotperez3240 Год назад

I have 12 million rows and it always times out. :(

@user-yo2nb4ry7i 3 года назад

Молорик

@utkarshpandya3155 3 года назад

how about MYSQL?

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

What if we have fact and dim tables , can we generate a query with joins included??

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

It doesn't seem to be the context of this video. Could you please share more details

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

@@rakeshnag70 what i meant was, fact and dim tables will be connected automatically here ryt so is there a way i can generate a query giving away that relation ??

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

@@dhanushyadav8879 I am not sure

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

@@rakeshnag70 ok thanks Nag😀

@ManishSingh-ds3qn 11 месяцев назад

I have 1M records in one table, it's time out. please suggest?

@pbiEnglish 11 месяцев назад

Need to see error

@jakkojusatish9560 3 года назад

It's great ...!!!. How can we do it same when data is in server, datasource is postgresql....!!!

@rakeshnag70 3 года назад

sorry buddy, I have not tested this, so can't comment on this

@romeoneto4218 Год назад

How to convert DAX formulas to SQL? Anyone to help me

@dineshbathula4495 3 года назад

Does we require any connection?

@pbiEnglish 3 года назад

yes it requires connection between DAX studio and Power BI

@Rafian1924 3 года назад

How to automate it?

@rakeshnag70 3 года назад

it is a manual activity.

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

how can i save data in sql server when i working in power bi .I need data automatically saved in db.This is possible?

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

This is called "write back" which is not available in power bi but it is possible with powerApps.

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

@@pbiEnglish how can it work.please tell me the process

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

@@pbiEnglish how can i activate in power bi ?what is the step?

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

@@rijughosh6697 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-uPHwjPRnRwE.html

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

I have not yet made any video on this but you can use video to understand this functionality ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-uPHwjPRnRwE.html

@ijbarraza 3 года назад

I think this does not apply if your tables in power bi are a merge of different sources. If as you show the table is just plain txt it works fine, otherwise it is still very limited

@rakeshnag70 3 года назад

Till the time data is in Power BI from any source with Import mode, we can do write back to SQL