Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Date/Time filters and Data Refresh to current

Hi,

 

Please whats the option to select in the Date/Time filters  in powerbi desktop so that I can get a small chunk of data to work with.

and then I can  publish and I schedule to refresh to today it will give me the current data.

Query Editor: Date/TimeFilters: 

But after scheduling refresh to today in powerbi service or refreshing manually, it only shows me pulls out data  between 01/11/2017-07/11/2017... I want the data to refresh to current date. 

 

My data starts at 01/11/2017 and its live to current.

If  I do the below: I get all the data to current but its now too big to save and publish..

Please help

Need Help

6 Replies

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi Anonymous,

    From your description, the data from 2017/1/11 to current data are two large to publish to service, which means you can filter rows to current data. The limit of .pbix file is 1GB. We only upload files to Power BI up to 1 GB in size. So you have to filter your resource table to decrease less than 1 GB.

    Best Regards,
    Angelia

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi ,

       

      The link  by gooranga1 is not the solution as that pulls all data..Not What I want.

       

      Let me make it clearer.

      So how do I filter a chunk in Pbix so that when I publish it will not be stucked on that date range.. ie Like  I mentioned the data from 01/11/2017-07/11/2017 is just 20MB..

      But its not refreshing to current date after publishing.. Is it as a result of this 

       

       

      But in my other  Pbix which I had the below: They are about 27MB after the complete built. They are refreshing after publishing.:

       

      Is my data not refreshing to current date even after publishing as a result of the "is after or equal to : And is before or equal"  filter.

      Maybe there is something I am not getting right..Please help

      • gooranga1's avatar
        gooranga1
        Icon for Power Participant rankPower Participant
        8 years ago

        Hi Anonymous,

         

        If you want to stop the data being imported to the pbix then you have to do that at source. So whatever query you are using to pull the data that will need to be modified to only pull a certain subset of data?

         

        Is it data from SQL Server?