Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Adding Column from Mixed Dataset makes the entire table empty

I'm working with a mixed dataset, one that has datasources that are direct query and import. When the table includes columns that stem from all of the direct query sources, it works fine. However, when I add a column from the import source, the entire table disappears. Any insights?

Need Help

3 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi Anonymous 

    You have created a dataset which contains direct query data source and import data source,

    Then you add a custom or calculated column from the table1 (from import data source) to the table2 (from direct query data source), the entire table2 (from direct query data source) disappears,

    Right?

     

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      No, sorry I worried that poorly. I had a table visualization that contained only columns from the direct query source. When I add in a column from the import source, the entire table visualization becomes empty. 

      • v-juanli-msft's avatar
        v-juanli-msft
        Icon for Community Support rankCommunity Support
        7 years ago

        Hi Anonymous 

        Do the table(direct query) and table(import) have relationships?

        If they don't have correct relationship, it may show errors.

         

        which version do you use?

        I test with Power BI Desktop Version: 2.70.5494.661 64-bit (June 2019),

        When creating correct relationship, it can work well.

        Please update to the lastest version from here

         

        In addition, there is a blog regarding Mixed Dataset.

        Composite Model; DirectQuery and Import Data Combined; Evolution Begins in Power BI

         

        Best Regards
        Maggie

         

        Community Support Team _ Maggie Li
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.