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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
rishirajdeb
Advocate I
Advocate I

How to pass parameter to source using Redshift connector

Hi All,

I am looking for a solution to be able to pass parameters to the source (amazon redshift) using the power bi native redshift connector. The requirement is to import a subset of data instead of the entire data from a fact table (having more than 1 gb compressed data which is beyond the limitation of a Power BI dataset with a pro license).

Redshift.png

The same can be acheived using the ODBC connector (tested, works as expected) - however would like to use the redshift connector as it has a significant edge in terms of performance over ODBC.

ODBC.png

(Please excuse me for the paint work!)

Is there any way to do it or it is a limitation of the connector? Please can anyone help??

Regards,

Rishi

@amitchandak @v-luwang-msft @v-xuding-msft @ibarrau 

1 REPLY 1
lbendlin
Super User
Super User

It is currently a connector limitation. Not familiar with Redshift - does it support the concept of views? Could you do the filtering there?

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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