Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

urgent: PowerBI looses data when working with multiple sources!

Hi All

I've been at it for a week, and I can't fix it (and need to present tomorrow:)).

 

I have 2 data sources in my power bi: one is an import of an internal sql database (i intentionally don't do a direct query because it was screwing things up even more), the second one is from SmartSheet (online Excel-like tool).

I need to create a table where I have cost information from both tables based on application ID. Smartsheet has less applications than first database: I expect it this cell to just be blank if there's no entry in Smartsheet for this application. However, as soon as an application is not in Smartsheet, it completely disregards this application and it's not present in the table.

 

I hope someone can help me!

BR Natalia

Need Help

5 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      v-frfei-msft 

      Thanks for reply! I tried this but I have a huge number of columns in both databases and whe I do join (Full Outer or Left Outer), it doesn't insert the column that I need. What can be the problem?

      • v-frfei-msft's avatar
        v-frfei-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi Anonymous ,

         

        You should expand the column you want as the picture below.