Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
6 | |
4 | |
2 | |
2 | |
2 |