Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Connect PBI Service to AWS Snowflake

Hi all

 

We've got Power BI Service set up on Azure, and Snowflake is being set up on an AWS instance.  Is the On-Prem Data Gateway required to connect through?  Does it have to be set up on a VM in Azure, or can we put it on an EC2 on another AWS account?  Or is there anything that's managed by Azure (since our team is AWS focused, we don't really have any capability to support ongoing management and maintenance of Azure infrastructure)

 

Thanks!

Need Help
  • GilbertQ's avatar
    GilbertQ
    6 years ago
    Hi there

    You would need a Gateway to connect from the Power BI Service to AWS.

    The Gateway would need to be installed on a VM in AWS that would need to be able to connect outwards to the Power BI Service.

    In terms of the connection, you should be able to use the Snowflake connector in Power BI Desktop.

5 Replies

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    6 years ago
    Hi there

    You would need a Gateway to connect from the Power BI Service to AWS.

    The Gateway would need to be installed on a VM in AWS that would need to be able to connect outwards to the Power BI Service.

    In terms of the connection, you should be able to use the Snowflake connector in Power BI Desktop.
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      We did the same and published a report. The report is refreshing wothout a gateway.

      So we are able to connect power BI ( azure) with snowflake ( AWS) without a gateway. All we did was configured the credentials under data source management. Any idea on how this is working?

      • GilbertQ's avatar
        GilbertQ
        Icon for Super User rankSuper User
        6 years ago
        Would it be possible to how the data source that you used under the data source management?