Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The 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.

Reply
usrivastava
Frequent Visitor

Load data from Power BI dataset into Redshift

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.

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

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.

View solution in original post

1 REPLY 1
lbendlin
Super User
Super User

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.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.

Top Kudoed Authors