Forum Discussion

alme's avatar
alme
Icon for Helper I rankHelper I
7 years ago
Solved

Error applying merged queries "sequence contains no element"

Hi,

 

I'm trying merging two queries. It should be a quite simple operation.

 

I'm merging a customer table and a price table (holding customer, price and item no).

In the editor my result looks fine, giving me the result I need, but when I Close and Apply Power BI throws  "sequence contains no element".

 

I'm a bit stucked here. Help is much appreciated

 

thanks

 

 

  • alme's avatar
    alme
    7 years ago

     

     

     

    My Merged Query looks fine until I click Close & Apply

     

     

     

    This the error

     

4 Replies

  • Hi,

     

    I'm trying merging two queries. It should be a quite simple operation.

     

    I'm merging a customer table and a price table (holding customer, price and item no).

    In the editor my result looks fine, giving me the result I need, but when I Close and Apply Power BI throws  "sequence contains no element".

     

    I'm a bit stucked here. Help is much appreciated

     

    thanks

     

     

  • PattemManohar's avatar
    PattemManohar
    Icon for Community Champion rankCommunity Champion

    alme Can't comment until we see the actual error message or any sample data to replicate the same. Please try to post the sample data of both tables that you are trying to merge in a copiable format.

    • alme's avatar
      alme
      Icon for Helper I rankHelper I

       

       

       

      My Merged Query looks fine until I click Close & Apply

       

       

       

      This the error

       

      • alme's avatar
        alme
        Icon for Helper I rankHelper I

        Hi,

         

        I fixed it by re-installing Power BI

         

        Case closed

         

        :smileyhappy: