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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

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
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Kudoed Authors