Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello there, PBI Community!
I'm having an issue with a specific data source where I'm getting a data access error:
Código de erro: DataAccessError
Erro na fonte de dados: Erro de acesso aos dados
URI do Cluster: https://api.powerbi.com
ID da Atividade: f7295c88-0998-4fff-ab1f-067af9701565
Hora: Mon Nov 28 2022 16:16:58 GMT-0300 (Horário Padrão de Brasília)
<gateway name> : Received error payload from gateway service with ID 1001868: Mashup expression evaluation error. Reason: ..
The access to this data source is configured through a VM - and weirdly enough, I can access this data source directly.
I'm thinking this has to do with the VM itself and not with the data sourse per se, even though I have other data sources linked with this VM, they're working just fine.
What I need is some troubleshooting guidance, 'cause I'm not very familizarized with how these kinds of gateways work, and I myself didn't configure it.... so... Any insight on how to approach the problem to solve it will be much appreciated!
Thanks in advance!
Henry,
Thanks for the quicky reply! We figured it out - there was a missing param on the connection string to the db..... after fixing it, PBI online was then again able to update the reports. Thanks once again ! 🙂
How did you fix this issue.could you explain
Hello @kavi , I found out that the issue was with the connection string I was using to connect to the database, which was requesting mandatory SSL verification; so, in order to fix it, I just added sslmode=require; at the end of the connection string.
In case you use a database plugin through ODBC (windows), you should also change SSL Mode to require, in case your database requires it too.
That fixed the problem. 🙂
Hope that was helpful!
Hi @talitanieps ,
Can you provide some specific error information about the gateway so that I can troubleshoot it for you as soon as possible?
Troubleshoot the on-premises data gateway | Microsoft Learn
Looking forward to your reply.
Best Regards,
Henry