Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Sharepoint connection with excel files from multiple private groups of a single workspace

Hello,   This issue may have no solution but hope is what makes me alive !   My company has a workspace. In this workspace there are dozens of private groups. In each one of these private group...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    Finally I ended up doing a site list to use it as a parameter in a custom function.

    It is working fine this way but someone will have to keep this list up to date through times to come.

    If someone who have the same issue read this topic, an half solution is to :

    1) Create a column which contains the teams private channels name in an excel file.

    2) Connect to this file in a Power BI report.

    3) In power query, invoke a function using the column names as a parameter.

    4) Do the usual steps when connecting to a file

     

    Here is the M code of the function I used :

    (names as text) =>
let
Source = SharePoint.Files("https://company.sharepoint.com/sites/workspace-"&names, [ApiVersion = 15])
in
Source


    Thank you for your time KNP and have a good day !

    Cado

KNP's avatar
KNP
Super User
4 years ago

I may have misinterpreted what you meant by "private groups".

If you're talking in a Microsoft Teams context then the private groups are actually separate SP sites behind the scenes and there is no concept of a "root".

This isn't an ideal design choice in my opinion and is contradictory to what is visually displayed.

 

Let me know what your actual setup is if my first suggestion doesn't work.

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi KNP 

 

Indeed I'm talking in a Microsoft Teams context, and yes every group has a different root url but the difference is quite light :

Let's imagine the worspace is named "Workspace"

Every group corresponds to a project and is named "Projet A", "Project B", "Project C", ...

Then the root url of the groups is https://company.sharepoint.com/sites/Workspace-ProjectA for example

But I have no table listing the project names and I don't want to have to update it continuously. Maybe you know a way to get all these groups name with a query ?

 

Best regards,

Cado