Forum Discussion

GuidoMS's avatar
GuidoMS
Helper II
2 years ago
Solved

Error while refreshing from service

Hi!   We are having a problem when trying to refresh our data set from power BI service. When we do it from desktop there's no error.   Said dataset has data from our database (from created views...
Need Help
  • GuidoMS's avatar
    GuidoMS
    2 years ago

    We found the issue. We never stopped a second to check the basic configuration. The problem was the configuration of the ODBC where the Gateway is located.

     

    Thanks!

GuidoMS's avatar
GuidoMS
Helper II
2 years ago

I want to add that we tried to refresh a new dataset only containing the table that's giving timeout error.

 

This is the error we get:

 

{"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":"La tabla no tiene ninguna columna visible y no puede consultarse."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Detail","detail":{"type":1,"value":"VW_PROTOCOLOESTUDIOSCOPIA"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: VW_PROTOCOLOESTUDIOSCOPIA.

 

That's spanish for "The table does not contain visible columns and the table can't be queried"

 

The problem is that the table DOES have data and visible columns. There's no transformation applied to it.

 

Any hint?