topic Re: Power BI Semantic Model Refresh using On Premises Data Gateway with Redshift in Report Server

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

tayyabvohra1 — Sun, 22 Sep 2024 20:27:46 GMT

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

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

lbendlin — Sun, 22 Sep 2024 19:00:37 GMT

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.

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

tayyabvohra1 — Sun, 22 Sep 2024 20:28:57 GMT

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

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

lbendlin — Sun, 22 Sep 2024 20:38:49 GMT

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?

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

tayyabvohra1 — Sun, 22 Sep 2024 21:05:15 GMT

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

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

lbendlin — Sun, 22 Sep 2024 21:19:11 GMT

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?