Getting data from SP list by parameter

[kroman]

Hi All

I have a sharepoint list that getting 500-1000 new items every day. And I have a power BI report based on that list. I need be able to show report for any week, selected by user, without having to create new report every week.
So would need a report with a week (dates) as parameter that I would upload to Power BI service and it would load different data from the same SP list depending on selected week (dates) by user - is there any way to do it?
So something like:

http://linktomyreport?week=1 , http://linktomyreport?week=2  etc

Thanks 

[kroman]

Ok, so here is a source of the SP List, which I need to filter by Period and Week (list has 2 columns - 'Period' and 'Week') . 

As you can see I am already trying to filter by Period, which is a paramater I created and want to use to filter SP list.

So I want to pass parameter in a report URL (https://reportLink?period=7&week=4) and use those 2 parameters to filter data loaded from SP List .

I gues there are 2 questions here -
How do I pass arguments to online report (is this gona work - https://reportLink?period=7&week=4 )?

How do I use those passed parameters to filter SP List data (need to filter data on loading to report becouse there about  50000 rows in that SP list, and we all know about 5000 limit)?
Thanks again

[v-janeyg-msft]

Hi, @kroman 

Do you know the parameters in desktop? Parameters | Microsoft Docs

I did a sample.Hope it will help.

Best Regards

Janey Guo

[v-janeyg-msft · Accepted solution]

Hi, @kroman 

According to your description,I think you need to use the url parameter feature in PBI service.

You can try:

URL?filter=Table/week in (1,2)

Like this:

Here is a document: Filter a report using query string parameters in the URL - Power BI | Microsoft Docs

If it doesn’t solve your problem, please feel free to ask me.

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ibarrau]

Hi. Correct me if i'm wrong but it sounds like you just want to show "last week". Assuming you have a Date column in the sharepoint list to differenciate the weeks, just load all data and filter it with a relativa date filter in the filter pane:

That way you will show last week or this week for a page or the whole report. I recommend loading all data just in case you build deeper analysis.

If you only want to load a small piece of data you can limited in Power Query.

Hope this helps,

[PC2790]

Hi @kroman,

I am not able to access the links provided by you. Howver as per requirement, it seems like this can be addressed using parameters and templates.

Please see the related blogs for better understanding:

https://databear.com/power-bi-desktop-parameters-and-templates/

https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/

Let me know if this solves your purpose