Forum Discussion
Export to SQL on a Schedule
I have a SQL Server that feeds PowerBI. PowerBI also gets data from SalesForce. I would like to load the SalesForce data to SQL on a schedule, say every 15 minutes, from PowerBI. Is this possible? All of the solutions I've seen integrating SQL and Salesforce seem complicated.
Hi matthewspare,
You can export data from a Power BI dataset, by running DAX queries programmatically, using two methods:
1. The Execute Queries API
2. The AMO-TOM Assemblies
The second option requires Power BI Premium, which I assume you use since you mentioned a 15 minutes interval.
You can also consider the option to use Power BI dataflows (which can connect to salesforce) with a custom ADLS Gen2
This option will create CSV files with the exported salesforce data in an Azure storage account which you'll be able to connect to using standard methods.
1 Reply
Hi matthewspare,
You can export data from a Power BI dataset, by running DAX queries programmatically, using two methods:
1. The Execute Queries API
2. The AMO-TOM Assemblies
The second option requires Power BI Premium, which I assume you use since you mentioned a 15 minutes interval.
You can also consider the option to use Power BI dataflows (which can connect to salesforce) with a custom ADLS Gen2
This option will create CSV files with the exported salesforce data in an Azure storage account which you'll be able to connect to using standard methods.