the given key was not present in the dictionary from new query

[PhilSmith23]

Hey Folks,

I have one query that I create: It previews fine, (runs elsewhere fine,) but Close and Apply gives me that error.  Latest version of BI, (did it in the previous version as well,) 90% of the queries come from the exact same source, (a MySQL database), I have no measure-only tables.  The query is clean, with no transformations.  I have not seen anything else online that seems to apply.

Anything else I should be looking for?

Thanx

Phil

[v-sgandrathi · Accepted solution]

HI @PhilSmith23,

To address the “The given key was not present in the dictionary” error in Power BI, begin by duplicating the query in Power Query Editor. Right-click the query causing issues, select "Duplicate," rename it, and remove any relationships with other tables. Use “Close & Apply.” If this version loads successfully, the issue is likely due to model dependencies. Then, remove all dependencies from the original query, including measures, calculated columns, or relationships, and try “Close & Apply” again.

Also, clearing Power BI’s cache can help, as it may contain outdated metadata. Navigate to File > Options and Settings > Options > Data Load > Clear Cache. If the error persists, consider creating a SQL view in MySQL (e.g., vw_MyWorkingQuery) with a consistent set of columns and import that view into Power BI instead of using the raw query. This ensures Power BI receives a stable data structure for processing.

Glad I could assist! If this answer helped resolve your issue, please mark it as Accept as Solution and give us Kudos to guide others facing the same concern.

Thank you.

[v-sgandrathi]

Hi @PhilSmith23,

May I ask if you have gotten this issue resolved?

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Thank you.

[v-sgandrathi]

Hi @PhilSmith23,

We haven’t heard from you on the last response and was just checking back to see if your query was answered.
Otherwise, will respond back with the more details and we will try to help .

If our response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. Please let us know if there’s anything else we can do to help.

Thank you.

[v-sgandrathi]

Hi @PhilSmith23,

As we did not get a response, may I know if the above reply could clarify your issue, or could you please help confirm if we may help you with anything else?

And if the provided information meets your requirements, you can Accept the solution and also give Kudos on that reply. It helps other users who are searching for this same information and find the information.

Your understanding and patience will be appreciated.

[Deku]

Have a look at the transaction log in mysql to see what happens when you click apply. Might get a more useful error message.

Also if the query if folding you also grab the native folded query and try running against mysql

[PhilSmith23]

Thanx for the reply.  The query itself works fine.  I hand it to MySQL, it runs clean, finds all the records it should.  The problme is not with the query, or the MySQL connection, it is just the combination of this particular query in power BI.

[parry2k]

@PhilSmith23 Does table name or schema of the table changed? Can you start a blank query and try to connect to the source and see if it works?

[PhilSmith23]

Thank for the reply. 

I built this query from scratch for this BI deck.  It runs clean directly against MYSQl.  It also previews just fine in BI.  It is only in the full load (Close and Apply) that it has an issue.  I have several other queries to the exact same source in this model, and thay all run fine.  

Watching the MySQL server, the query starts, the query finishes, (no errors,) THEN BI bombs with that error.  I get the impression that this error occurs when BI is trying to digest the results, not when getting them.

Phil