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 ...
Need Help
  • 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

Anonymous's avatar
Anonymous
Not applicable
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

  • villasenorbritt's avatar
    villasenorbritt
    Resolver I
    4 years ago

    Anonymous See I knew someone on here would have a simpler, cleaner way to get this done. Thanks for your help!

  • villasenorbritt's avatar
    villasenorbritt
    Resolver I
    4 years ago

    Hey Anonymous , I have another question that I think you might be able to help with. Lets say I am only wanting to show the "Good" data in my chart, but then I need the "Bad data" to be categorized into five different categories. How would you go about doing this?