Semantic model refresh Data source error: The PostgreSQL source doesn't support encrypted connection
i am losing my brain cells with this power bi service crap, my data source is a postgresql database hosted on a server, in power bi desktop it connects perfect, when i check the connection in connections it says online, but when i try to refresh the semantic model i get this error: The cloud connection in settings is online:Data source error: The following system error occurred: Type mismatch. Table: Encuesta_de_Mercado
Best regard, I hope they are fine. Please give your valuable help with this error that I present on the Power Bi Service platform. Data source error: The following system error occurred: Type mismatch. Table: Market_Survey. Cluster URI: WABI-SOUTH-CENTRAL-US-redirect.analysis.windows.net Activity ID: bf3ef27d-3585-437e-a88b-fe741f7ec9f0 Request ID: e626db79-6854-ba42-3a00-41e72a53e6a5 Time: 2024-05-23 18:19:46Z I have done the following: * The data table in question (Market_Survey) when I updated the data and the report did not present any errors, everything was successful. * I have already validated the data in each column and I do not have empty or hidden data that could generate the error. * The data type according to the variable is correctly assigned. * I delete the report from the Power BI Service, update locally, Publish the report, configure the Gateway and when updating it in the powerBi Service I present the same error again. I appreciate any help you can give me.
Reports Not Loading in Production Environment
I used a Web API for a Power BI report, published it, and deployed it in our Production setup. However, among 47 reports, only two face an 'InvalidOrMalformedSemanticQueryDefinition' error. These reports act inconsistently, sometimes loading data and visuals and sometimes not thus giving an error, especially when refreshed or opened. This inconsistency in loading poses a challenge in ensuring consistent accessibility and functionality for these particular reports. Reports are working fine in Power BI Desktop and Power BI Service. If somebody can help on this issue, I'd greatly appreciate it.
Unable to update this data source's credentials. Unknown error
I have successfully publish a test pbix file to my powerbi web~ however, when I set the data source authentication. this error pop out~ Unable to update this data source's credentials. Unknown error Details: Please have this information handy if you choose to create a support ticket. ActivityId: 94640c9c-faba-469c-8d70-6ffe8fcb5bb5 RequestId: 1644bbba-25ef-4443-ab1e-4e496fd4555b Cluster URI: https://api.powerbi.com Status code: 500 Time: Wed Mar 01 2023 17:03:14 GMT+0800 (Singapore Standard Time)
