Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Alicia_Anderson
Resolver I
Resolver I

How to get around "Unable to combine data" error

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.  

 

Alicia_Anderson_0-1709050475744.png

 

I will attach the PBIX if someone wants to take a look.  Thanks. 

1 REPLY 1
lbendlin
Super User
Super User

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.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Solution Authors