Forum Discussion

stuarthokie's avatar
stuarthokie
Frequent Visitor
2 years ago

Native Query to Pivot Large Volumes of Data

Hello!  I have a challenge for which I have not seen a resolution posted.  I have seen similar issues resolved, but none like what seems to be my normal challenge.  I am green to the more complex wor...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi stuarthokie ,

Did your problem get solved? If so, please mark lbendlin 's answer as the solution.

 

Best Regards,
Wenbin Zhou

stuarthokie's avatar
stuarthokie
Frequent Visitor
1 year ago

As promised, I have finallly found a solution.  It has nothing to do with what can be done in PBI.  Due to the large volumes of data, everything I tried to do to pivot the data failed in the PBI environent.  I had to resort to creating an entirely new table view in the data synapse.  Sorry this won't help anyone else out other than not wasting time trying to pivot large volumes of data in PBI.  Best case scenario, it was able to complete the pivot (albeit a couple of months ago, when there were far fewer data than now and, indeed, vastly fewer than there will be 10 years from now) in 3h ONLY ONCE.  All other times, crash and burn.