Forum Discussion

ccsnet's avatar
ccsnet
Frequent Visitor
2 years ago
Solved

Power BI Visualisation - Missing and Duplicate Lines - Sorce Data Correct - Relationship Issue?

Hi all, sorry this may not be the best post but I am still finding my feet with Power BI.

 

I have a few sources of data I pull on to create a single view.

 

As part of that build I have had to create relationships.

 

What I didnt know was adding the sources was changing what was in the view, I now have duplicate lines (not sure why as feilds look the same) and missing rows (I assume as all data was not found for a reason).

 

I had one additonal senario where there are 3 URL records which is associated with the 'project record' or row.

 

When added it removed all other data except these three where I simply just wanted to add the data of it matched and was available. 

 

Nb duplicates do not appear on a less complicated page. 

 

Is there a setting some where on a visulation that can tidy this up as its not the raw data or some thing I can look at on the relationships ?

 

Sorry I can not show examples directly due to the content.

 

Thanks

 

Terran

  • Fowmy's avatar
    Fowmy
    2 years ago

    ccsnet 

    Sorry, I couldn't understand what exactly is the issue that you are facing but if you are concerned about showing items regardless of data availability then, try turning on "Show item with no data"


     

5 Replies

  • Fowmy's avatar
    Fowmy
    Super User
    2 years ago

    ccsnet 

    Sorry, I couldn't understand what exactly is the issue that you are facing but if you are concerned about showing items regardless of data availability then, try turning on "Show item with no data"


     

    • ccsnet's avatar
      ccsnet
      Frequent Visitor
      2 years ago

      Hi Fowmy,

       

      Thanks for that - I think part one of my issue is resolved.

       

      Intestingly I could only find it when creating a new visulation but I was able to do it so thanks.

       

      For my second part - duplicates I have just grabbed this, sorry its only a small part.

       

      The above is a single entry in data source 1 but it seems to be duplicating and blanking some feilds. All these shown here are actually from the same record in the same data source yet I am getting a duplication in lines. 

       

      Terran

       

      • Fowmy's avatar
        Fowmy
        Super User
        2 years ago

        ccsnet 

        Sorry, it's a bit hard to figure it out without more details about your model.

  • ccsnet's avatar
    ccsnet
    Frequent Visitor
    2 years ago

    Hi all,

     

    As thought I had a relationship problem. 

     

    Still need to work out how to fix, I think it will be another table, then I can re implement it. 

     

    Thanks

     

    T