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?
