Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi gents,
I'm right now struggeling a bit in getting all relevant data for sharepoint online list entries in the correct way.
Actual setup:
- sharepiont online list with folders for different locations (yes, it's a list, not a library)
- several items in the single folders on the list
- online connection to sharepoint list via Power BI
What I actual see in PBI table:
- each single folder of this list
- each single entry of this list
What I do not see:
- folder location of every single entry
What's the actual problem:
- need to filter list entry by folder (location)
Any ideas?
Regards
There are types where you can use to connect to sharepoints.
https://docs.microsoft.com/en-us/powerquery-m/sharepoint-contents
Use any of the type according to your requirement in the advanced editor.
Thanks.
But also woth fetching the contents of the list I can not find any possibilities for this lookup...
Maybe I'm doing it wrong or mybe I oversee something?
Hi @NetMare ,
Would you please show us some screenshot about your issue?I'm puzzled by your description.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Found what I need. It was in ParentList.ParentWeb.Description
Thanks for your help
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
83 | |
66 | |
60 | |
57 |
User | Count |
---|---|
188 | |
111 | |
105 | |
78 | |
71 |