One Dataset, Two Reports, Different Data

[Anonymous]

Hi,

Is it possible while connecting one dataset on Power BI service to 2 reports (one import connection, one live) to set limits on data load for the one connected live and, let's say, load only part of the information to the report? One report is sales and will need all the data, but the other one is yesterday's sales, and it will need only yesterday's data. How can I set the limits for the second report when I want the data to come from the same dataset for better data control? 

[audreygerred]

The report with the live connection isn't loading any data, if you want to limit the report to only show one day you can do that with a relative date filter. 

[ibarrau · Accepted solution]

Hi. No you can't import a PowerBi Dataset. You can live connect or direct query. Both scenarios might take the whole dataset. If you are building the reports you can just hide a filter for "Yesterday". If you already have the data in the dataset then it should be a problem like thinking "I will take one day to keep it smaller and faster". If the whole dataset is there and works, then don't worry, the backend just query that.

I hope that make sense