Forum Discussion
Power Bi - SharePoint List Multiple Value columns
Hi, I'm just starting my journey with Power Bi, but I will try to explain it the best I can. I have connected Power Bi to a SharePoint list to make some analysis from the data. I have a few c...
Hi KnucklezZ ,
You may consider modify the relationship like below:
Final output:
Best Regards,
Ada Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for the reply.
I have tried to replicate these steps, but I am getting a blank table. 😞
Can I also ask, what's the reasoning behind two of the tables being many-to-many and the middle table being many-to-1, also the filter in the middle one seems to only be one way.