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
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

That's not all you are doing.  You are also applying filters.

 

Click Start Recording, Refresh Visuals, Copy Query.

stuarthokie's avatar
stuarthokie
Frequent Visitor
2 years ago

I did not refresh visuals previously, thanks!  I'll disect this code when I have time and get back to the thread.

  • stuarthokie's avatar
    stuarthokie
    Frequent Visitor
    2 years ago

    Hello!  No, not solved, still working on it.  If I am able to come up with the solution, I will post it here for others.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years 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.