Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
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.
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.
User | Count |
---|---|
14 | |
4 | |
2 | |
1 | |
1 |
User | Count |
---|---|
22 | |
3 | |
3 | |
2 | |
2 |