Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

How to redirect to another SharePoint list

Hi. My report in Power Bi gets the data from a list in SharePoint. Works fine. But what if I cannot add new data to the list in SharePoint? Instead I always have a new list with the new data and I need my report in Power Bi to drop the first list and use the new list to get the new data. How can I refresh by switching lists in a Power Bi report?

Thanks.

Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    Didn't work but thanks. Instead I changed by Power Query, in advanced editor. I copied the url list and pasted here.

4 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    You would need to use parameters for that, and then change the parameter value in the Power BI service in the Semantic Model settings page.  If these lists have even the slightest hint of a meta data difference your scheduled refresh will break anyway and you will have to re-upload from Power BI Desktop with the new parameter value.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Do you know how to change the parameters in the Semantic Model settings?

      • lbendlin's avatar
        lbendlin
        Super User
        2 years ago

        Go to the settings page and open the Parameters section. If your semantic model uses parameters they will be listed here and you can change them.  The change will then affect the upcoming refreshes.