undefined

[PrabhuSri]

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? 

[PrabhuSri]

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? 

[GeethaT-MSFT]

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

[GeethaT-MSFT]

Hi @PrabhuSri The information you share is not enough to answer your question, can you please provide more details on your ask.

Regards

Geetha

[PrabhuSri]

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?