Forum Discussion

lastephanieee's avatar
lastephanieee
Frequent Visitor
1 year ago
Solved

Ghost queries from MySQL

Hello everyone,   Does someone know how and why I am getting ghost queries in my power query? The record does not exist in the DB, I have tried running the query though the DB, but yet when I run ...
Need Help
  • v-achippa's avatar
    v-achippa
    1 year ago

    Hi lastephanieee,

     

    The issue here might be caused by power query cache, joins, or transformations. Please try below steps:

    • Clear power query cache and refresh the query preview, close and reopen the power bi.
    • Check if the power query uses a JOIN which results in unmatched/null rows.
    • Inspect query generated in power query, use View Native Query if available. Try running that exact SQL manually in MySQL directly to compare results.
    • Check if the query uses views or triggers, if you are querying a view or a table with triggers, they might return unexpected rows.
    • Make sure you are using the latest MySQL ODBC or .NET connector to avoid compatibility issues.

     

    If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

     

    Thanks and regards,

    Anjan Kumar Chippa

lastephanieee's avatar
lastephanieee
Frequent Visitor
1 year ago

Not found a solution yet.

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

Hi lastephanieee,

 

The issue here might be caused by power query cache, joins, or transformations. Please try below steps:

  • Clear power query cache and refresh the query preview, close and reopen the power bi.
  • Check if the power query uses a JOIN which results in unmatched/null rows.
  • Inspect query generated in power query, use View Native Query if available. Try running that exact SQL manually in MySQL directly to compare results.
  • Check if the query uses views or triggers, if you are querying a view or a table with triggers, they might return unexpected rows.
  • Make sure you are using the latest MySQL ODBC or .NET connector to avoid compatibility issues.

 

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

 

Thanks and regards,

Anjan Kumar Chippa

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

    Hi lastephanieee,

     

    As we haven’t heard back from you, we are closing this thread for now. If you have any further issue, please raise a new thread in the community forum, we are ready to assist you on it.

    Thank you for being part of Microsoft Fabric Community.

     

    Thanks and regards,

    Anjan Kumar Chippa