Forum Discussion

yosefmaru's avatar
yosefmaru
New Member
3 years ago

Get Data from AWS Redshift on PowerBI Service

I am new to PowerBI. I might be missing something obvious here. How do I connect to AWS Redshift from PowerBI Service (Pro)? I was able to do that from PowerBI desktop by using the Get Data option.  ...
Need Help
GilbertQ's avatar
GilbertQ
Super User
3 years ago

Hi yosefmaru 

 

What you need to do is to connect via Power BI Desktop.

 

Then you need to install and configure the Power BI Gateway with a data source to Redshift. Finally upload your Power BI desktop file to the Power BI Service. Then you connect it to your data source.

 

You can view all the details here (Specifically from the section "Installing and configuring a Microsoft on-premises data gateway")

Integrate Power BI with Amazon Redshift for insights and analytics | AWS Big Data Blog

yosefmaru's avatar
yosefmaru
New Member
3 years ago

I guess my question is, can I pull data from AWS redshift on Power BI Service (browser) without using Power BI desktop? I don't want authors to download PowerBI Desktop on their machine. I am wondering if they will be able to create reports/visualization solely on the browser. Much like what you can do on AWS QuickSight.

  • GilbertQ's avatar
    GilbertQ
    Super User
    3 years ago

    Hi yosefmaru 

     

    You could do this in Fabric if you wanted to. Otherwise you would need a gateway to refresh the datasets.