Forum Discussion
How to import data from PowerBI dataset into the SQL database automatically.
To automatically import data from a PowerBI dataset into a SQL database, you can use the Power BI Dataflows feature. This feature allows you to extract, transform, and load (ETL) data from various sources, including PowerBI datasets, into a dataflow and then export the data to an Azure SQL database. Here are the steps to achieve this:
Connect to your PowerBI dataset: In Power BI Desktop, select the "Get Data" option from the Home ribbon, and then choose the "Power Platform" category. From the list of options, select "Power BI dataflows."
Load the data into a dataflow: In the Power BI dataflows screen, select the PowerBI dataset you want to import into your SQL database, and then click "Load" to load the data into a dataflow.
Export the data to an Azure SQL database: After the data is loaded into the dataflow, go to the "Dataflow" tab in the Power BI Desktop, and select the "Export data" option. From the list of options, select "Azure SQL Database." Enter the connection details for your Azure SQL database, and then select the tables you want to export.
Set up automatic refresh: Once the data is exported to your Azure SQL database, you can set up automatic refresh to ensure that the data in your SQL database is always up-to-date. To do this, go to the "Manage Dataflows" option in the PowerBI service, select your dataflow, and then choose the "Refresh" option. In the "Refresh" screen, select the "Automatically refresh" option, and set the refresh frequency as required.
Note: The Power BI Dataflows feature requires an Azure Power Platform license to use. If you do not have an Azure Power Platform license, you will need to purchase one before you can use the feature.
To automatically import data from a PowerBI dataset into a SQL database, you can use the Power BI Dataflows feature. This feature allows you to extract, transform, and load (ETL) data from various sources, including PowerBI datasets, into a dataflow and then export the data to an Azure SQL database. Here are the steps to achieve this:
Connect to your PowerBI dataset: In Power BI Desktop, select the "Get Data" option from the Home ribbon, and then choose the "Power Platform" category. From the list of options, select "Power BI dataflows."
Load the data into a dataflow: In the Power BI dataflows screen, select the PowerBI dataset you want to import into your SQL database, and then click "Load" to load the data into a dataflow.
Export the data to an Azure SQL database: After the data is loaded into the dataflow, go to the "Dataflow" tab in the Power BI Desktop, and select the "Export data" option. From the list of options, select "Azure SQL Database." Enter the connection details for your Azure SQL database, and then select the tables you want to export.
Set up automatic refresh: Once the data is exported to your Azure SQL database, you can set up automatic refresh to ensure that the data in your SQL database is always up-to-date. To do this, go to the "Manage Dataflows" option in the PowerBI service, select your dataflow, and then choose the "Refresh" option. In the "Refresh" screen, select the "Automatically refresh" option, and set the refresh frequency as required.
Note: The Power BI Dataflows feature requires an Azure Power Platform license to use. If you do not have an Azure Power Platform license, you will need to purchase one before you can use the feature.
Hi MAwwad, I've never seen a "Dataflow" tab in Power BI Desktop as described in Step 3. Am I missing something? For years I have wanted a SIMPLE solution to get data from PBI dataflows and/or dataset TO Azure SQL. Is this really a thing?
Note: I use PBI Dataflows everyday but have never found a way to get data out of them (expect to PBI).
Did you ever find a solution?
