Forum Discussion

Sabo256w's avatar
Sabo256w
Frequent Visitor
4 years ago
Solved

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...
  • Anonymous's avatar
    Anonymous
    4 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!
    1. Turn on Fast Combine (Power Query –> Options –> Privacy –> Ignore Privacy Levels)
    2. Save the workbook
    3. Close Excel
    4. Restart Excel
    5. 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.