Forum Discussion

tayyabvohra1's avatar
tayyabvohra1
New Member
1 year ago

Power BI Semantic Model Refresh using On Premises Data Gateway with Redshift

I have successfully deployed a Microsoft Power BI dashboard on Power BI Report Server Online, utilizing AWS Redshift through an On-Premises Data Gateway in Power BI. However, I am facing an issue whe...
@PowerBI Report Server
@redshift
lbendlin's avatar
lbendlin
Super User
1 year ago

 

Power BI Report Server Online

 

PLease clarify what you mean by that. Are you using a proxy service to allow outside users access to your Report Server?

 

Note that you are not refreshing dashboards. You are refreshing semantic models.

tayyabvohra1's avatar
tayyabvohra1
New Member
1 year ago

I am using Virtual Machine and The VM is using On Premises Data Gateway, the Data Gateway is configured in the Report Server

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago
    the Data Gateway is configured in the Report Server

    oh no no no - do not do that.  Do not install the gateway on a VM that is already doing something else.  All gateway cluster VMs need to be dedicated exclusively to the gateway.

     

    Still not clear on your original statement - what does "Report Server Online" mean?

    • tayyabvohra1's avatar
      tayyabvohra1
      New Member
      1 year ago

      I have few other dashboards there semantic models are refreshed through On Premises Data Gateway (their sources is mysql aurora)
      But in the same way when I wanted to setup automatic daily refresh scheduled on the semantic model which is connected to redshift its not happening

      • lbendlin's avatar
        lbendlin
        Super User
        1 year ago

        Do you get an error message? If yes, what is it?

         

        Where is the Redshift source located? In the same AWS instance as the MySQL db?