Power BI - Write Data to SQL

Great info. Tried to look for a simple explanation of Power BI data to SQL Server and you've done it! Thanks 🙂

Like it, but looks so complicated...

Wonderful, its a very helpful Idea, Thanks a lot

It's really cool and amazing! Excellent tips

Hi. Does anyone know if you can write to a SQL db from a power BI report that has been published to a workspace?

how did you do it can you share with me , thank you

how did you do it can you share with me , thank you

Has anyone tried this and works in the Desktop but not in the service? I have an example that works fine in both sides but a new report I am working on is writing to SQL from the Desktop but not in the service, so just checking if we know of any limitations on doing this?

Do you know how I can expand this to multiple rows on a tabel? Currently only getting 1 row to write when I need it to look through a number of rows.

Hi, thank you so much for this. I can get the query to run, however it only runs for the first row in my dataset. Do you know how to get the Native query to run for each row in the dataset?

This is great! However it only works in Import data mode

This is awfully hacky for something you can do with a stored procedure and an SQL job.

норм 🙈

Is it possible to writeback dax measure to sql server?

Which statement actually pulls data from the API data source

Hi, How do we do it if we have 1000 rows in a dataset table.

can you share this Power Bi file please for reference?

Hi, this is great. is there a way to do the same against oracle database? I get error ORA-00933 while running several sql statements in one value.nativequery. thx in advance

Amazing. This approach enable the usage of Power Query to one of the most useful cases of ETL. Thanks!

Very very helpful Thank you

What a mastermind trick Parker you show..
Millions Thanks

This is awesome !!! I just created process to read SharePoint Online Lists and sink the data to the SQL Data Warehouse. I did have to modify the code as I need to run an insert for each row however Text.Combine() was the unsung hero. Passing the sql scripts as one large text tuple set, with a group by transformation. Thanks for explaining this !!!

This is very useful. 😲 1 question. In this example, you are writing back the data as part of a scheduled refresh process. Can it be done in a non-scheduled manner (i.e., the user opens the dashboard at her own convenient time, and wants to write certain data back to SQL through Power BI). Is this possible?

missed SQL double check

Hey Parker, thanks a lot for this video! Very informative.

Woa can be this done with sharepoint list? or excel?

Luckily i stumbled upon your channel.. its just too good.. surprised u haven't got more subscribers.. i'm guessing this will work on oracle db too.. will try it out.. thanks..

Thanks Sir

I'm using Oracle as a database and I get errors like this "Native queries aren't supported by this value."
any suggestion?

Thanks for the video! Amazing. One quick question: I have created a dataflow in power bi. A colleague of mine needs this dataflow to feed its PIMS. Is there I way I can pass her this dataflow? Let's say like exporting this dataflow to MySQL? Your Idea will be much appreciated. Thanks.

i have multiple row to insert ,
it can work with text combine the list ,
but i got error if the data has single quotation mark in the text.
any advice ?

When I'm using INSERT I'm getting error i.e. Expression.Error: We cannot convert a value of type Table to type Text.
Could you please suggest correct solution? Thanks in advance!

Can we use this approach with sap data sources ?

Interesting! Why would you not use MS Flow for this?

Hello, and thanks for the video, but I'm looking to change a value in the table, give the user to privilege to click and modify the Value in the table, and updating it where it should reflect back to the SQL/Oracle Database.

Thanks!!! It's amazing!

How to insert the values to sql database, if we have mutliple records to be inserted?

Hi Parker,


How can I delete the current SQL Table before and then bulk insert all the data from Power Query ?

Please help..!!

Interesting!

Hi Parker, awesome video tried it out but got stuck on the Drill Down part as the values are not changing for new records, was only able to insert the one record. How can I get it to work?

Just want to call out to be very careful with doing any type of INSERT/UPDATE/etc... within Power Query. In the video he had a check to make sure to not insert if it already exists which is good. the statement can run one or more times - which could lead to problems. Be very very careful. 🙏

I was literally trying to do this using workaround R script (which I'm not good at). I can't believe this is so easy.... Thank you for your video!

Interesting .. would this be adaptable for a medium size table to be written back to SQL?

Thanks for the video.

BTW: That's true "How to lie with statistics" classic in the first pic (showing 1,3 M to ... 1,3 M views) 😂

Great video, just a question : does this work with MS Access database

this is crazy good!!! thanks alot!

Wow, this is very eyes-opening. I am wondering how we can insert multiple values at the same time? The drill down took only one row at a time.

Ah-Mazing! 😲 Thank you, Parker!

Hi! this is very useful solution. BTW which of the dataset is your source for the raport? As I know there is no possibility to use multiple datasets for one report.