Helo everyone, please see below how my dataset looks like:
2 tables:
- 1 excel from Sharepoint: MAP_ERRORS with "ERROR NAME" and "ERROR Description"
ERROR NAME,ERROR Description
Exception,ClassCastException
Exception,RuntimeException
Invalid value,invalid data type for attribute
-1 SQL Server Table EMEA_AM_AP with "ITEM_PK" "STATUS" "Error_message"
ITEM_PK,STATUS,Error_message
code1,KO,null:RuntimeException:data not complaint
I would like to create a new column in table EMEA_AM_AP where if I find one of the Error Description messages, to have automatically the ERROR NAME. For example:
ITEM_PK,STATUS,Error_message, ERROR Type
code1,KO,null:RuntimeException:data not complaint,Exception
I succeeded to do that with the following power queries:
#"Added Error_type" = Table.AddColumn(#"Renamed Columns1", "Error Type", each Table.SelectRows(MAP_ERRORS, (outer) => Text.Contains([Error_message], outer[ERROR Description]))),
#"Expanded Error Type" = Table.ExpandTableColumn(#"Added Error_type", "Error Type", {"ERROR NAME"}, {"ERROR NAME"}),
On Power BI Desktop everything is working perfect, but if I refresh the report on the Service, I got this error message:
- Underlying error code-2147467259
- Underlying error messageSharePoint: Request failed: Unable to connect to the remote server
- DM_ErrorDetailNameCode_UnderlyingHResult-2147467259
- Microsoft.Data.Mashup.ValueError.DataSourceKindSharePoint
Please note that all data souce settings are set to organizational.
Could you please give me an idea of how to fix this issue?
