Forum Discussion

akj2784's avatar
akj2784
Icon for Post Partisan rankPost Partisan
7 years ago

Power BI connectivity with Amazon EC2

Just wanted to check if it is feasible to connect Power BI to AWS EC2 and create visuals on top of that? I have Spark SQL setup on AWS EC2. Regards, Akash
Need Help

3 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar
    7 years ago

    Hi akj2784,

     

    If you want to connect to SQL Server in Amazon AWS from Power BI Desktop, you can use Amazon Redshift connector to connect to the instance. When you choose to Load data from Power BI Desktop Navigator , you'll prompted whether to use Import or DirectQuery mode to load the data. For more information, please review this article.

     

    In addition, you could have a reference of this similar threads.

     

    Best  Regards,

    Cherry

    • akj2784's avatar
      akj2784
      Icon for Post Partisan rankPost Partisan
      7 years ago

      Thank you for reply. I want to connect to file system in EMR. I don't have SQL Server on AWS.

       

      Regards,

      Akash

      • v-piga-msft's avatar
        v-piga-msft
        Icon for Resident Rockstar rankResident Rockstar
        7 years ago

        Hi akj2784,

         

        I'm not familiar with file system in EMR.

         

        Does this have rest api or backend database?

         

        Best Regards,

        Cherry