Forum Discussion
Merge Queries is not populating the information for 3 Queries
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 ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Champion- 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.
- 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.
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!
- edhansTry 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.