How to export data from Power BI/Query to Azure SQL

In this video I will show you how to export data from Power BI (Power Query to be exact) to Azure SQL.

I have already shown you how to export data to :

Export data from Power BI to excel:

Keynotes:
02:00 Create an Azure SQL server and database
07:15 Create the R script to download Power BI data to Azure

Do you know how to download data without duplicates when appending the data? Let me know in the comment box

SUBSCRIBE to learn more about Power and Excel BI!

Our PLAYLISTS:

ABOUT CURBAL:

************

************

QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
► Twitter: @curbalen, @ruthpozuelo

#POWERBITIPS #CURBAL #POWERBI #MVP

[mrock]

Hi Ruth, you are doing amazing work. Listening you itself is a fun. Keep rocking!!!

[tanababa]

Taking my chances again... liking before seeing ;)

[JamesManjackalMSFS]

Thank you very much! I will try! Just a question. Is the Azure SQL Service one of the free Azure Services? In my company all have fear to use Azure... even I had to use my personal credit card for testing Azure Cognitive Services & show to my boss what I can get!... now when you finish your free time if you wish to go on with a free account you have to give your card. It's free for 750 transactions/month for cognitive services... This is why I ask you this question... I suppose some Gb/month will be free....

[gnanaprakash]

Hi Ruth Thanks for sharing many videos on Power BI. Can you please provide the sequence to be followed to watch your playlists.

[denissa]

Super cool.
Do you know if these data is going to refresh automatically? Or do we need to refresh manually?

[CortesdoRafaOficial]

Hi Ruth, if this dataset was in power bi service it Will Work at Every schedule refresh? Or it only work in power bi desktop?

[catty]

Hi Ruth, very good demo. Did you test it after publishing to Power BI Service? I wonder if this solution works only from Power BI Desktop. Once published the pbix file to Power BI Service, how do we know the IP address of the server in Microsoft data center? How do you set the firewall in that case? I would like to create a PBI solution using Google Maps Geocoding API (yes I saw your video), schedule a refresh and export the geocoded addresses back to a table in Azure SQL Database to complete a round-trip data flow back into the DW.

[berndhartmann]

Hi Ruth,
thank you very much for your very helpful videos!


I tried to do like you suggested - however there is alwas a failure-message:
DataSource.Error: ADO.NET: R script error.


Error in :
could not find function "odbcDriverConnect"


Is it a driver-problem? A problem regarding windows 32-bit or 64-bit-version?


Best regards,
Bernd

[shilpisinghal]

Hi, thanks for the video. I am not able to view ODBC string Azure for MySQL Database. Can we achieve this using other driver in R script or Python script?

[rikabchand]

9:21 You seems to be using SSMS from onprem not the AZURE SQL, Please correct me if I am wrong.

[vog]

Thanks! I will try this at the office. For someone who hasn't used Microsoft SQL Server Management studio, how do you do the part at 9:24 where you connect to the Azure server? Is it easy to find the Azure server connection details?

[mshparber]

Thanks! Is there a free or a very cheap account plan in Azure to play with?

[aravindgutta]

Hi Ruth, Is there any other way to export data from Power BI visuals to Azure SQL tables other than this R-Script

[qaisassef]

Hello, would it be possible to show how to export data and append it to an existing DB ? (only new or updated rows)

[jinjin]

Hello, May I consult why I follow the steps and the the error message below? can I know how to fix it?

error message:
DataSource.Error: ADO.NET: R script error.
Warning messages:
1: In :
[RODBC] ERROR: state IM002, code 0, message [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
2: In : ODBC connection failed
Error in sqlSave(myconn, dataset, tablename = "PowerBISQL", rownames = FALSE, :
first argument is not an open RODBC channel
Execution halted

Details:
DataSourceKind=R
DataSourcePath=R
Message=R script error.
Warning messages:
1: In :
[RODBC] ERROR: state IM002, code 0, message [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
2: In : ODBC connection failed
Error in sqlSave(myconn, dataset, tablename = "PowerBISQL", rownames = FALSE, :
first argument is not an open RODBC channel
Execution halted

ErrorCode=-2147467259

[dhirajr]

Hi I get an error. What to do?
Formula.Firewall: Query 'Professionals' (step 'Run R script') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.

[gopid]

Can i export the data from azure DB without using "Run R Script"?

[hoke]

Hi Ruth, do you know where to get from Azure the information about existing VMs in my tenant(several subscriptions)? information like hostname, primary ip, serial number. uuid, created by, created on, last updated by and so on? i would like to get this information to power bi. thx

[gopid]

How can i download the script that whatever in notepad?

[gopid]

How it will take the datatype of column?