Forum Discussion

villasenorbritt's avatar
villasenorbritt
Resolver I
4 years ago
Solved

SQL Views and BI

I am working with SQL to pull data into power bi. I made a view in SQL that has only what we consider "Good Data" and here is the table that represents that: What I am stuck on is how to make ...
  • Anonymous's avatar
    Anonymous
    4 years ago

    If i understood your question correctly, i will probably do the following:

     

    Create a view with good and bad data, but add a column that (semething like "Data quality") that says if the current row is good data or bad data.

    Then in Power BI you can filter your visuals using that field.

     

    Hope it helps