Forum Discussion
Report technical page to show code errors of charging tables
- 9 months ago
Hi fbittencourt
By the looks of it, you seemed to have added a new column and just entered the code as a text string - they're wrapped with quotation marks. Other than that the code is not much help without seeing a sample data and your expected out from it. Please read and follow the instructions in this post - https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
- 8 months ago
Hi fbittencourt ,
Keep this as a function query:
let
Attempt = try tbl,
Output = if Attempt[HasError] then
#table(
{"Table", "Status", "Message"},
{{TableName, "Error", Attempt[Error][Message]}}
)
else
#table(
{"Table", "Status", "Message"},
{{TableName, "OK", ""}}
)
in
OutputUse this report query is used to produce a final table output that can be loaded into the model and shown in Report View.
let
Checks = {
fxAuditTable(REF_DASCOOPS, "REF_DASCOOPS"),
fxAuditTable(REF_FOURNISSEUR, "REF_FOURNISSEUR")
},Combined = Table.Combine(Checks)
in
CombinedKindly share the sample data in a workable format (such as text, Excel, or a PBIX file with sample data) so we can proceed with testing and troubleshooting.
Regards,
Chaithra E.
Hi fbittencourt
By the looks of it, you seemed to have added a new column and just entered the code as a text string - they're wrapped with quotation marks. Other than that the code is not much help without seeing a sample data and your expected out from it. Please read and follow the instructions in this post - https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523