Merge Queries is not populating the information for 3 Queries

[vsolanon]

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!

[edhans]

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.
   1. 
2. Do the same for the List column. Is the list valid before you extract?
   1. 

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

[vsolanon]

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 · Accepted solution]

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]

Hi @edhans @dax @dax thank you both for the suggestions!

Kindly note I follow your recommendations and noticed the error was becauase the "IDRotation"  column was not in Text Format. After updating the "IDRotation"  column in both Queries, I was able to merged them and create a new query with the information combined.

I am new in PowerBi and just learn new things each day 🙂

Thank you!

[edhans]

Great. Data types are critical and can cause all sorts of issues if not set up properly, especially for merges and relationships in the model.

[vsolanon]

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]

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.

[Greg_Deckler]

I think this would be easier if you pasted the text from the Advanced Editor @ImkeF , @edhans 

[vsolanon]

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

Please let me know if any further information is required,

Thanks! 🙂