Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Forum members,
We have a requriement wherein we have to send a few columns' data from the Power BI dataset (which is built from various data sources) to AWS Redshift table and then merge this data to another important table to get the final sales reporting.
Can you please help me in understanding the solution that we can implement in our system to meet the above requirement most effectively. We came across a couple of names while searching for the solution - we can either use xmla endpoint or webhook. Any help here would be appreciated.
Solved! Go to Solution.
Use Power Automate to run a DAX query against the dataset / semantic model and then push the result into Redshift.
Obligatory note: Power BI is a downstream system. You should connect Redshift to the actual data source.
Use Power Automate to run a DAX query against the dataset / semantic model and then push the result into Redshift.
Obligatory note: Power BI is a downstream system. You should connect Redshift to the actual data source.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
5 | |
4 | |
3 | |
3 |
User | Count |
---|---|
11 | |
11 | |
7 | |
3 | |
2 |