Forum Discussion

GaneshReddy643's avatar
GaneshReddy643
Regular Visitor
4 years ago
Solved

Report Data Validation using Sql server Data Base

Hi Guys, My Data Source is Sql Server DB. Please guide me on how to validate the Power bi report data at Sql Server Database Side.
  • FarhanAhmed's avatar
    FarhanAhmed
    4 years ago

    What kind of validation that you need? Is it related to Data or Metadata?

     

    You can also Check Row count of all tables in Power BI and compare it with SQL Database Tables.

     

    For further data validation, you write queries with filters and apply the same on Power BI.

     

    Also, you can check the "Native Query" of your Import Data that is actually running behind at SQL Server to match values.

     

     

     

FarhanAhmed's avatar
FarhanAhmed
Community Champion
4 years ago

What kind of validation that you need? Is it related to Data or Metadata?

 

You can also Check Row count of all tables in Power BI and compare it with SQL Database Tables.

 

For further data validation, you write queries with filters and apply the same on Power BI.

 

Also, you can check the "Native Query" of your Import Data that is actually running behind at SQL Server to match values.