Forum Discussion

GopVan's avatar
GopVan
Frequent Visitor
3 years ago

Point Power BI report to a different SharePoint list

When connecting the report to a SharePoint list, I provided the URL to the site, giving me a list of SharePoint lists to choose from.   The Advanced editor code looks like below:   Source = Share...
Need Help
Show and Tell
TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
3 years ago

Hey GopVan ,

 

you can create parameters that store the identifiers Parameters - Power Query | Microsoft Learn

Create another paramater like pThisOrThat.
Then you can change the relevant queries like so

let
    ListParameter = if pThisOrThat = "this" then pList1 ... ,

    Source = ... ,
    theList = ...  ListParameter ... ,
    
    //from here you have to reference theList
    finalTransform = AnyTransform( theList , ...)

in
    finalTransform

Hopefully, this provides what you are looking for.

Regards,
Tom