question

Chantalr99-6658 avatar image
0 Votes"
Chantalr99-6658 asked Chantalr99-6658 answered

Inner Join is grouping rows

131977-image.png


HI there, when I do this inner join, its grouping my bends rather than showing them one by one in rows. It will show one for all the bends of the same type. I don't know how to join these tables ( which I'm doing to apply the names) without the bends grouping themselves. I need to see each individual bend.

Thanks
131945-image.png


power-query-not-supportedazure-database-mysql
image.png (49.3 KiB)
image.png (82.1 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

If you run the query directly through SSMS and not through PowerBI desktop, what result do you get?

0 Votes 0 ·
Chantalr99-6658 avatar image
0 Votes"
Chantalr99-6658 answered

I found that the table "Bystronic_Log" was grouping the rows, not my query so I quit linking to that table and created smaller tables to access the data points I needed out of it.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered Chantalr99-6658 commented

A JOIN never forces an implicit grouping of the data.

What's that for a tool in the second screenshot? Looks like PowerPivot/PowerQuery?
I see at least one active filter on column "BendCount"; may does that causes that you see a limited result?

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

That's Power Bi and the filter is showing me only Bend Counts higher than 1

0 Votes 0 ·