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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Not applicable

How cann i connect multiple Tables correctly ?


I have 3 different values in 3 different tables. I want to connects them, so that i can show the value in a line chart with each of the three volumes for the duration i haveConnect.PNG


everytime i want to conect them or start an autodetect, so engine doesnt find anything or i get this errorcode :




can please somebody help me ? THANKS !

Memorable Member
Memorable Member

Hi @Anonymous,


Create measures to calculate the sum of values for all three tables differently.


Like Sum_1 = SUM('Table1'[Values])

Sum_2 = SUM('Table2'[Values])

Sum_3 = SUM('Table3'[Values])


Add them all in a final measure Total=[Sum_1]+[Sum_2]+[Sum_3]


Plot this measure in the visuals with the date and make sure that all the tables are joined individually to the Date Table.


Mark this post as a solution if that works for you!
Check out this blog of mine: How to Export Telemetry Data from Azure IoT Central into Power BI

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

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


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors