Forum Discussion

metamemelord's avatar
metamemelord
New Member
3 years ago

Dynamic sections in Sharepoint Datasource URL

We have a dashboard that queries Sharepoint for data files and updates. We are currently using Sharepoint.Files() data source, passing the URL similar to https://sharepoint.com/segment1/segment2/. We then filter the retrieved files based an Identifier. We are using Power Automate to refresh the dashboard when files are generated in Sharepoint. The issue is that it is taking a lot of time to apply this filter. Is it possible to:

  • Set up incremental data updates with Sharepoint data source?

  • Pass parameters in the URL - For example: instead of querying the Sharepoint path /segment1/segment2/ can we only query /segment1/segment2/${Year}/${Month}/${Identifier}? Please note that we want the Year, Month, and Identifier to be dynamic - Year, month, and Identifier should be passed from the Report URL (Maybe from Query Parameters). For example: On opening the dashboard using link (say) https://powerbi.com/dashboards/Test-Dashboard?filter=Identifier eq '123456789',Year eq '2023',Month eq '2' (Notice query params in link) should query the sharepoint directory at path /segment1/segment2/2023/2/123456789

I checked that parameter can be used to do something similar, but it does not let me partially update the data source URL.

What's the best way to achieve this?

No RepliesBe the first to reply