Ghost queries from MySQL

[lastephanieee]

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 it in Power Query I get null values for most of the columns and some values for some.

Please explain to me how can this happen.

Thanks a lot.

Kind regards,

S

[lastephanieee]

Not found a solution yet.

[v-achippa · Accepted solution]

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]

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

[v-achippa]

Hi @lastephanieee,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @Deku for the prompt response.

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the super user resolved your issue? or let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @lastephanieee,

We wanted to kindly follow up to check if the solution provided by the super user resolved your issue.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @lastephanieee,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the super user resolved your issue.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

[Deku]

Hard to say without seeing the query. PowerQuery does like to shoot out queries to determine schema

Please see this blog post on the topic