Dynamic URL - How to pull a lot at once?

Hi Anonymous

I'm basically hoping to pull 365 tables (or at least be able to select which table I'm pulling) will the URL above and only change the date. Is this possible or are there any work arounds without manually setting up a table 365 times?

->To pull 365 tables, you need create a parameter and select the date when get data, i'm afraid it is impossible to get data one time and get 365 tables which only change the date.

If you pull 365 tables which only change the date into power bi, the dataset is very large, thus the performance may be bad.

Is this possible? Currently I've used the advanced URL and set up a paramentor and can change the data that way - but I'm really wanting to have many dates available at once and then I'll build out filters to select each data in the report itself. 

->Per your requirement, you could pull data for all dates in that year, then use the slicers or filters(add date column in) on each report to select report.

for example, you have three reports, every report contains many visuals, report1,2,3 need to show date "2018/1/1", "2018/7/1", "2018/9/3" respectively, you could ass a default slicer on each report page or add the date column to the "Report level filter".

Best Regards

Maggie