Forum Discussion

GustavO65's avatar
GustavO65
Icon for Helper II rankHelper II
6 years ago

How to use Filters in database queries?

Good. I need to use the From/Until I select the query user in SQL syntax to fetch data. You could initially run the query to the SQL server by taking the last 30 days as a default search. But t...
GustavO65's avatar
GustavO65
Icon for Helper II rankHelper II
6 years ago

Hello @jstorm

In principle I'm trying to use DirectQuery (I have a report armed with "Import" and the data on it is not being updated..)

Users have to select any date range....

It is not extremely important and/or critical that you report the data in real time. I could use "Import".. (I would have to finish viewing/resolving because the consultation I have in the armed office is not refreshing the information when I have created the task on the PoweBI Server to keep it in sync..)

Best regards

jstorm's avatar
jstorm
Icon for Resolver III rankResolver III
6 years ago

I would highly recommend switching to Import.  DirectQuery has many limitations and should only be used when necessary.  With Import, after you publish the report to PBI online, you should be able to set the refresh to occur up to 5 times per day.  Spaced correctly, you could have fresh data every ~4 hours.  To switch to import, open the 'Model' view, select the tables one by one in the fields section on the right, then expand 'Advanced'. You can change the 'Storage Mode' to Import.  Try this with a copy of your current report to test it out.  With Import, you can have millions of records no problem.

  • jstorm's avatar
    jstorm
    Icon for Resolver III rankResolver III
    6 years ago

    GustavO65 

    Also, be aware that I am writing in English and you are writing in Spanish. The Power BI forum is translating for us and there may be some errors.

    • GustavO65's avatar
      GustavO65
      Icon for Helper II rankHelper II
      6 years ago

      Hi jstorm 

      I´ll write in english!

      As I told you I have been creating a powerBI report using "Import" instead of DirectQuery.
      But I don´t have the last information for my fact table..
      At the moment I don´t know why..
      In my SQL Server I have information until today..
      In PowerBi I have information until 04-29-2020 (the day I made the change from Direct Query to Imported)

       

      • jstorm's avatar
        jstorm
        Icon for Resolver III rankResolver III
        6 years ago

        To be sure- are you saying data after 4-29 is not showing up in the published report on Power BI Service or it is not showing up in Power BI Desktop on your local machine?