Forum Discussion

GustavO65's avatar
GustavO65
Helper 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...
jstorm's avatar
jstorm
Resolver 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
Helper 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)

 

  • GustavO65's avatar
    GustavO65
    Helper II
    6 years ago

    Sorry jstorm  it was my mistake...

    In Power Bi Server Service is showing information until today...

    PowerBi Desktop has information only at 04/29...

    I´ll fix it...

    Best regards!

     

  • jstorm's avatar
    jstorm
    Resolver 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? 

  • jstorm's avatar
    jstorm
    Resolver III
    6 years ago

    Awesome! Don't worry, it is a common mistake, which is why I knew. I'm happy you could get it worked out.