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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
SteveIOW
Helper II
Helper II

pivot? sort of

Dear all,

 

I am loading in a table of data from SQL that has this sort of format... (only more columns)

DateValue
05/11/2022a
05/11/2022b
05/11/2022c
01/10/2022x
01/10/2022y

I need to get it into this format during the load

DateValue 1Value 2 Value 3
05/11/2022abc
01/10/2022xy 

given that I don't know what the maximum number of 'Values' I am going to get is.

 

is anyone able to help?

 

kind regards

 

Steve

1 ACCEPTED SOLUTION
SteveIOW
Helper II
Helper II

Hah - I've done it.

I created a column in the SQL using ROWCOUNT and PARTITION. Then when I loaded that table in I could use pivot in powerBI, using the new rowcount column as the column names and choosing not to aggregate the values.

 

Sorry if I wasted anyone's time and hopefully it will help someone else out.

 

Best

 

Steve

View solution in original post

1 REPLY 1
SteveIOW
Helper II
Helper II

Hah - I've done it.

I created a column in the SQL using ROWCOUNT and PARTITION. Then when I loaded that table in I could use pivot in powerBI, using the new rowcount column as the column names and choosing not to aggregate the values.

 

Sorry if I wasted anyone's time and hopefully it will help someone else out.

 

Best

 

Steve

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Fabric Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.