Forum Discussion

Stacey_Tucker's avatar
Stacey_Tucker
Frequent Visitor
1 year ago
Solved

Merge queries only returning partial information

Hi, I am attempting to merge two tables together, but not getting the expected result.   Table 1  Table 2   I am testing my query with 27 rows to figure out my issue. but in reality ...
Need Help
  • Stacey_Tucker's avatar
    Stacey_Tucker
    1 year ago

    Thank you for the suggestions and responses, unfortuently these did not resolve our issue, it appeared that when we were merging our data it wasn't importing all of the data even though it was demonstrating a perfect match and all possible causes for difference had been removed, to get around this my manager has completed a significant rebuild on our query as we had it broken up into different steps into smaller query tables. She has worked around the issue and we are back up and running.

v-sgandrathi's avatar
v-sgandrathi
Community Support
1 year ago

Hi Stacey_Tucker,

 

Thank you for being a part of the Microsoft Fabric Community.

 

As ZhangKun ans BA_Pete mentioned, those workarounds should resolve your issue.

If you have further questions or updates, please let us know.

 

If the answer meets your requirements, please give us Kudos and consider marking it as a solution to assist others.

 

Best Regards,
Sahasra.

  • v-sgandrathi's avatar
    v-sgandrathi
    Community Support
    1 year ago

    Hi Stacey_Tucker,

     

    we haven't heard back from you regarding our last response and wanted to check if your issue has been resolved.

    If our response addressed by the community member for  your query, please mark it as Accept Answer and click Yes if you found it helpful.

    Should you have any further questions, feel free to reach out.


    Thank you for being a part of the Microsoft Fabric Community Forum!

    • v-sgandrathi's avatar
      v-sgandrathi
      Community Support
      1 year ago

      Hi Stacey_Tucker,

       

      We wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.

      If my answer resolved your query, please mark it as "Accept Answer" and select "Yes" if it was helpful.

      If you need any further assistance, feel free to reach out.

       

      Thank you for being a part of the Microsoft Fabric Community!