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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
lgendrot
Regular Visitor

Redshift with Direct Query and PowerBI Embedded

I understand that the Redshift connector is in preview at the moment, and as such only supports Direct Query from within the desktop application.

 

I also understand that support for the redshift connector from within the powerbi service, and through a gateway is planned, but my knowledge of the powerbi ecosystem is quite lacking so my question is:

 

Would the upcoming support for these two cases also imply that using PowerBI Embedded + Redshift w/ Direct Query will be supported as well? Will such a thing be possible ever?

 

Is there a tenable workaround for securely embedding reports fed via Redshift into a web app?

1 REPLY 1
Eric_Zhang
Employee
Employee


@lgendrot wrote:

I understand that the Redshift connector is in preview at the moment, and as such only supports Direct Query from within the desktop application.

 

I also understand that support for the redshift connector from within the powerbi service, and through a gateway is planned, but my knowledge of the powerbi ecosystem is quite lacking so my question is:

 

Would the upcoming support for these two cases also imply that using PowerBI Embedded + Redshift w/ Direct Query will be supported as well? Will such a thing be possible ever?

 

Is there a tenable workaround for securely embedding reports fed via Redshift into a web app?


@lgendrot

So far Power BI Embedded only supports DirectQuery to Azure SQL DB/DW.

 

The status of this idea Support other data sources Direct Query using Gateway on Embedded Power BI shows started, so I think there will be more options, either direct query to a on-premise data source via gateway or directly connect to a cloud service afther the feature implemented.

 

I don't quite get your last question, maybe you're looking for Row level security with Power BI Embedded.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.