Forum Discussion

vsolanon's avatar
vsolanon
Frequent Visitor
6 years ago
Solved

Merge Queries is not populating the information for 3 Queries

Hi Experts!

 

I am creating my first Dashbord combining 3 SharePoint lists. My main issue is that when I try to merge  the third Query, the new Query created  is not populating any information.

Kindly note the Query1 and Query2 have a column named IDData, within this column is an identifier I created to connect them. Also, Query2 and Query3 have a column named IDRotation, whithin this column is an identified to connect them.

 

Please find below the steps followed:

- I merged the Query1 and the Query2 and create a new Query named "MergedQuery"

- I merged two dates column within the Query3 and create a new column named "RotationDates"

- I "Group By" the Query3 and create a new column named MyTable

 

 

 

 

 

 

-I add a new Custom Column named "Total Rotation Dates"

 

 

 

 

 

 

 

 

- Then I delete the column "MyTable" in order to have only 2 columns and select "Extract Values" (up to here everything it good)

 

 

 

- After I have all the table consolidated, I merged this Query3 with the Query "MergedQuery", however for some reason the information is not being populated 😞

 

 

 

 

 

Coul you please guide me how can I achive this.

Thank you in advance!

Need Help
Show and Tell
  • dax's avatar
    dax
    6 years ago

    Hi vsolanon , 

    According to your description,  which step will cause abve error? Did you click the error to see the detailed error information? If you want to use M code in your last step, you don't need to expand the list("Total Rotation Dates"). Or you could expand it like below. You could try it to see whether it work or not

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

9 Replies

  • edhans's avatar
    edhans
    Icon for Community Champion rankCommunity Champion
    6 years ago
    1. Click in the My Table column in the area next to the word Table and look below. Confirm the data in the table is valid.
    2. Do the same for the List column. Is the list valid before you extract?

    If those are ok. I'm gonna need more info. Maybe a paste of the M code using the Code box.

    • vsolanon's avatar
      vsolanon
      Frequent Visitor
      6 years ago

      Hi edhans  thank you for the information,

      Kindly note I verified both columns and noticed the data of the table is valid. Please see imaged below,

      Could you please confirm where I can verify the M code using the code box? I am new in PowerBi and I am afraid I do not know what that is.  🙂

       

      Thank you!

       

      • edhans's avatar
        edhans
        Icon for Community Champion rankCommunity Champion
        6 years ago
        Try wrapping your penultimate statement with Table.Buffer() before expanding.

        The code box is a toolbar icon looks like </> - I’m on my phone so not 100% sure that is the exact symbol.
    • vsolanon's avatar
      vsolanon
      Frequent Visitor
      6 years ago

      Hi edhans  the M Code of the last step I applied is:

      = Table.TransformColumns(#"Removed Columns1", {"Total Rotation Dates", each Text.Combine(List.Transform(_, Text.From), " , "), type text})

      • dax's avatar
        dax
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi vsolanon , 

        According to your description,  which step will cause abve error? Did you click the error to see the detailed error information? If you want to use M code in your last step, you don't need to expand the list("Total Rotation Dates"). Or you could expand it like below. You could try it to see whether it work or not

        Best Regards,
        Zoe Zhi

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • vsolanon's avatar
      vsolanon
      Frequent Visitor
      6 years ago

      Hi Greg_Deckler the formula used is:   Table.Column([MyTable], "RotationDates")

      Please let me know if any further information is required,

      Thanks! 🙂