Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
JannaChadji
New Member

Parameter Error There weren't enough elements in the enumeration to complete the operation

I realized that error was pointing to query which fed data from folder that details and files are no longer needed. Do i just delete the query?

I tried unchecking Enable refresh and load as i was trying not to delete it completely but im still getting above/subject error.

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @JannaChadji 

 

Deleting a query will lose all the transformation steps of it. I guess your purpose is to still remain all steps but make the query not be used any more, right? If so, I have a trick. You can open the Advanced Editor, convert all steps into comment by adding /* */ around it. Then add null at the end. The query will return null as a result. Uncheck enable load of the query. With this way, you can bring everything back easily in the future. 

vjingzhanmsft_0-1717724252212.png

 

However if you want to use the data of this query, you have to fix the folder it points to or modify the M code where it uses any unnecessary and non-existing files/columns. 

 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Hi @JannaChadji 

 

Deleting a query will lose all the transformation steps of it. I guess your purpose is to still remain all steps but make the query not be used any more, right? If so, I have a trick. You can open the Advanced Editor, convert all steps into comment by adding /* */ around it. Then add null at the end. The query will return null as a result. Uncheck enable load of the query. With this way, you can bring everything back easily in the future. 

vjingzhanmsft_0-1717724252212.png

 

However if you want to use the data of this query, you have to fix the folder it points to or modify the M code where it uses any unnecessary and non-existing files/columns. 

 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

ManuelBolz
Responsive Resident
Responsive Resident

Hello @JannaChadji,

 

This is not enough information about how and where the error occurs. Do you perhaps have a screenshot of the error or the code that caused the error?

Just a guess - But your error suggests that you want to access an empty element (List/Table/Record).

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors