Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Error on refreshing -data problem

I tried to refreshed my pbi dashboard and follow what they suggested in the table, i cannot see  any null at all, 

 

  • Data source error{"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":"We cannot convert the value null to type Text."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"Expression.Error"}}],"exceptionCulprit":1}}} Table: QOL_ASCOF1C_LastMonth.
  • Cluster URIWABI-UK-SOUTH-redirect.analysis.windows.net
  • Activity IDxxxxxx
  • Request IDxxxxxx

anyone could help and some problem similar to this before , highly appreciated!

Status: Needs Info
Comments
Anonymous
Not applicable

Hi @nick_wongth1 

Can the associated report in dashboard be refreshed normally ? The error message mentions the QOL_ASCOF1C_LastMonth table, is there a problem with the report related to this table ?

 

Best Regards,
Community Support Team _ Ailsa Tao