Forum Discussion
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 where the dashboard fails to refresh, consistently returning an SQL timeout error. Despite multiple attempts, the problem persists.
As part of troubleshooting, I have also tried using an ODBC connection to upload the dashboard. While the data is visible upon upload, the refresh process still fails.
It's important to note that other dashboards connected to the same report server but utilizing different databases (e.g., AWS MySQL Aurora) are functioning without any issues. This problem appears to be specific to the Redshift connection.
Could you please provide insights or guidance on resolving this issue?
Thank you for your assistance.
Best regards,
Tayyab
5 Replies
Power BI Report Server OnlinePLease 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.
I am using Virtual Machine and The VM is using On Premises Data Gateway, the Data Gateway is configured in the Report Server
the Data Gateway is configured in the Report Serveroh 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?
