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
Not able to connect to Redshift due to IP Restrictions
I am trying to connect to redshift through Power BI service, however our redshift needs IPs to be whitelisted. We have tried tracing the request hitting redshift and whitelisting that IP, however after some time we were unable to access redshift from power BI service. Is there any way I can know the list of IP addresses which has to be whitelisted on redshift to have uninterrupted access to the data on Power BI service(premium per user)?Kindly help me for conditional checkbox with action required on dropdown filter of below snapshot.
Case 1 : Filter beside below highlighted snapshot of red color highlighted check box how we will place? Case 2: And If you check the checkbox and select the dropdown, then it should show all the list of names. Case 3: If you uncheck the checkbox and select the dropdown, then it should show all the list of names. Kindly can you please suggest and do needfull for above cases!
unable to replace blank with zeros in matrix
im trying to replace blank values with zeros in the following matrix : the measure im using: total users = CALCULATE(DISTINCTCOUNT(canceled_then_returned_cohort[user_id]))+0 note that both columns im using in the matrix doesnt have blank values and my datasource is redshift is there any other solution than adding '+0' at the end of the measure since it's not workingError when adding AWS Redshift data source to existing PBI gateway
Hi, I've hit an error which seem to be at odds with, well, itself. I'm testing PBI integration with AWS Redshift. Redshift sits within a private VPC/Subnet so it's not publically accesible but according to documentation and PBI Gateway UI, this should be ok. All is working fine with Power BI desktop as I'm able to access the Redshift endpoint via a VPN connection. I can publish fine to my Workspace. As per documentation from both Microsoft and AWS, I've followed the steps to add a Redshift data source to my PBI gateway. Specifically, this: https://community.powerbi.com/t5/Service/Powerbi-Service-to-Amazon-Redshift-Private-cluster/td-p/963628 points to this: https://aws.amazon.com/blogs/big-data/integrate-power-bi-with-amazon-redshift-for-insights-and-analytics/ All works fine until the adding 'Applying' the new data source to the gateway. The following error is returned: ODBC: ERROR [IM003] Specified driver could not be loaded due to system error 126: The specified module could not be found. (Simba Amazon Redshift ODBC Driver, C:\Program Files\On-premises data gateway\m\ODBC Drivers\Simba Amazon Redshift ODBC Driver\AmazonRedshiftODBC_sb64.dll). Here's the odd bit. The file does exisit as I've installed the Simba Amazon Redshift driver. Any help would be appreciated
