Forum Discussion
Solved
Power Query Partitions and Appending Data
I get the error below when I initiate a data refresh from Power BI Desktop. It's not consistent though. If I go into Power Query, peform a refresh and then go back to Power BI Desktop and refresh, ...
You can't - in this query. Create another query and do the append there. Or set the sensitivity level to none/ignore.
You can't - in this query. Create another query and do the append there. Or set the sensitivity level to none/ignore.
That's exactly what I ended up doing. I was coming back here to comment on it. I created a new query only for the join and that resolved the issue. I definitely don't want to set the sensitivity level to ignore.
Thanks!