Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join the FabCon + SQLCon recap series. Up next: Power BI, Real-Time Intelligence, IQ and AI, and Data Factory take center stage. All sessions are available on-demand after the live show. Register now

Refresh Web PowerBI Issue

Submitted by Anonymous on ‎05-22-2020 08:04 AM

Hello!

 

The report of my PowerBI Desktop App works!

But when a Refresh it by PowerBI Web, via Gateway, I get the error:

 

Algo não deu certo
Erro durante o processamento de dados no conjunto de dados.
Tente novamente mais tarde ou entre em contato com o suporte. Se você entrar em contato com o suporte, forneça esses detalhes.
Erro de fonte de dados: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"As informações são necessárias para combinar os dados"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.DataSources","detail":{"type":1,"value":"[{\"kind\":\"MySql\",\"path\":\"uppmysqldb.uppertools.inf.br;uppersitedb\"},{\"kind\":\"SQL\",\"path\":\"uppersap92.uppertools.inf.br;SBOUppertools-ADM\"}]"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.Reason","detail":{"type":1,"value":"PrivacySetting"}}],"exceptionCulprit":1}}} Table: Planos Suporte x Cliente.
Cluster URI: WABI-BRAZIL-SOUTH-B-PRIMARY-redirect.analysis.windows.net
ID da atividade: b7c83c0d-0d90-42bc-a9ad-ca26b172d36a
Solicitar ID: 88530922-77c3-ffe0-5f73-dbc58d4fb9e1
Hora: 2020-05-22 14:34:41Z

 

Anyone can help me?

Status: New
See more ideas labeled with:
4 Comments (4 New)
Comments
v-yuta-msft
Community Support
Community Support
‎05-25-2020 01:27 AM

@Anonymous ,

 

It seems the data source is mysql database, right? Have you configured mysql credentials correctly in "manage gateway" section on power bi service? Also please check if you have updated gateway to the latest version.

 

Regards,

Jimmy Tao

 

Anonymous
Not applicable
‎05-25-2020 08:18 AM

 

Hello @v-yuta-msft !

 

I have a lot of Dashboards, and all of them use MySQL and SQL Server as Datasource.

And all of them works fine!

 

So YES! I configured MySQL and SQL Server credentials correctly!

Just this Dashboard, return with this error when I try to Refresh.

 

Regards;

Bruno Affonso.

 

I updated the Gateway version to 3000.40.15 (May 2020), and the error still happaned.

 

v-yuta-msft
Community Support
Community Support
‎05-25-2020 11:39 PM

@Anonymous ,

 

I would suggest you create a support ticket here for further analysis.

Support Ticket.gif 

 

Regards,

Jimmy Tao

Anonymous
Not applicable
‎11-09-2021 08:09 AM

Bruno, esse erro se dá porque em algum momento do query você mesclou/combinou consultas de fontes diferentes, pelo que eu vi do MySQL e do SQL, não sei o motivo, mas dá erro, eu tive esse problema com o MySQL e o sharepoint.

 

Pra resolver eu excluí a etapa de mesclagem no powerquery, e criei uma coluna calculada em dax pra sanar minha mesclagem

Idea Statuses