Forum Discussion
undefined
Hi, there are 3 source tables and 3 target tables. Validate data between S2, T1 and S2, T2... get the record counts, see if the content is the same etc. Power bi visual that will display the different validations performed and the results( Pass, fail, percentage) etc. how do we go about creating a dashboard?
4 Replies
Hi PrabhuSri The information you share is not enough to answer your question, can you please provide more details on your ask.
Regards
Geetha
Hi Geetha,
I have a table T1, with columns COL1, COL2, COL3 and Source Table with similar columns , I need to compare the three columns COL1 in T1 with CoL 1 in Source 1
mans provide an output such as
C1 - Pass percentage , Fail percentage
C2 - ""
C3 - ""
sinilar for all three tables T2 with Source 2 and T3 with Source 3
and then this is only one validation. I will also be performing other validation checks like null check , duplicate check etc.
how can I show the different validation checks visually in power bi?
Hi Geetha,
I have a table T1, with columns COL1, COL2, COL3 and Source Table with similar columns , I need to compare the three columns COL1 in T1 with CoL 1 in Source 1
mans provide an output such as
C1 - Pass percentage , Fail percentage
C2 - ""
C3 - ""
sinilar for all three tables T2 with Source 2 and T3 with Source 3
and then this is only one validation. I will also be performing other validation checks like null check , duplicate check etc.
how can I show the different validation checks visually in power bi?
Thanks, PrabhuSri for providing additional information, I see you have added powerbi tag but this is the Synapse community forum I would suggest posting in Power Bi form here is the link
Forums - Microsoft Fabric Community
Regards
Geetha
