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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
usrivastava
Regular 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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Kudoed Authors