The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.
Solved! Go to Solution.
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.
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!
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.
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!
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).