Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have read SO MANY posts on this topic and have tried many things. I am extremely frustrated that there is not an easy way to get around this! I understand that this is meant to avoid security issues from different sources but I should be able to override this and move on!!!
I have 25 different queries I am using to gather various organizational sources (all are set with that privacy setting by the way in the Desktop and within the service). Combining this into one massive query is not an option. I am pulling a variety of API info using PATs (personal access tokens), invoking custom functions to pass IDs, and then combining results into one table.
I will attach the PBIX if someone wants to take a look. Thanks.
If you are trying to merge them - don't. Let the data model do the work for you.
If you are trying to append them - there is the alternative to use the DAX UNION command. Give that a consideration.