Erro de conexão Power BI e cPanel

[EduardoAC]

Olá,

Estou enfrentando um problema ao tentar carregar um modelo de dados no Power BI Service para publicar a dashboard em meu site. Durante o desenvolvimento, utilizei o Power BI Desktop e configurei a conexão ao meu banco de dados hospedado em um servidor acessível via cPanel. Para isso, fiz o seguinte:

1. Mandei meu IP para o cPanel para liberar o acesso ao banco de dados.
2. Baixei e configurei o ODBC na minha máquina para conseguir desenvolver a dashboard.

Tudo funcionou perfeitamente no Power BI Desktop. No entanto, ao tentar publicar e carregar o modelo de dados no Power BI Service, recebo a seguinte mensagem de erro.

[v-jianpeng-msft]

Hi, @EduardoAC 

The PowerBI service client receives an incorrect HTTP response with a status code of 400. This means that there is a problem loading the model associated with the report. The error code provided is “Datasource.AnalysisFailedWithUnknownFunctions”. Below are some workarounds:
Check if the function you are using is correct? If you are using the wrong function or an unsupported function you will experience the current problem.
Make sure that the connection to the data source is stable and that there are no interruptions during data retrieval. The gateway connection is correctly configured for your semantic model in Power BI Service and it is in the online state.
Go to File > Options and Settings > Data Source Settings. Ensure that the data source is configured correctly and that you have the necessary permissions. Check the privacy level of the data source. Sometimes a mismatch in privacy levels can cause problems!

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.