Forum Discussion
Sabo256w
4 years agoFrequent Visitor
Mutiple classified/Trusted data error when appending two tables
Hi All. I've run into an error when I append two queries/tables in PowerQuery: It's worth noting the two tables/queries I'm appending have a custom function. I'm using the function so th...
- Anonymous4 years ago
Hi Sabo256w ,
Please try the solutions provided in this blog:
- The first method to fix this problem is to avoid the fnGetParameter function all together and just hard code the file paths. While this works, you cut all dynamic capability from the query that you went to the effort of implementing. In my opinion, this option is awful.
- If you want to preserve the dynamic nature of the fnGetParameter function, the only way to fix this error today is to perform the steps below in this EXACT order!
- Turn on Fast Combine (Power Query –> Options –> Privacy –> Ignore Privacy Levels)
- Save the workbook
- Close Excel
- Restart Excel
- Refresh the query
Here is a similar thread:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Sabo256w
4 years agoFrequent Visitor
Thanks Eyelyn!
Works perfect 😀