Filter works in PBI Desktop totally fine but not in Power BI Web App

[Chilli]

Hi,

I build up a power bi report based on an oralce db. I use for upload an on premises gateway, which loads the data daily.

While uploading the data in PBI Desktop it totally works. I have a date slicer (which connects the date table to the data needs to be shown).

When I upload the report, the data are still totally fine and connected as wished. But for some reasons the report shows up all data on the earliest date available after uploading data via gateway. Meaning the connection between date table and data needs be shown up is wrong.

Can you help me out? 

[Chilli · Accepted solution]

I found the failure on my self. The format in the format of the date in data source changed, but the connecting between date table and further tables where build up poorly 😕  so the change of the format put a failure into the web app. 

Thx for your support as highly appreciated 🙂

[shugh]

I think perhaps there is an issue in your data model between your data and the date table. Do you have access to the Power BI desktop file?

[Chilli]

Yes I build that report 😅

and there we have no issue with that 😕

[Chilli]

just in the web app 😞

[Chilli]

All data without the earliest date

[shugh]

Apologies, it looks like it should work. I can't see where things are going wrong.

[shugh]

Are you able to expand the date slicer to start from 01.08.2021 and end at the maximum date?

[Chilli]

Fully Date RangeFully Date Range without the earliest

[Chilli]

So all data are connected for some reasons to the earliest date

[shugh]

Hi, where is it showing as the earliest date? Could you provide a screenshot? Perhaps it is doing an auto summarisation of the earliest date.

[Chilli]

Screenshot

[Chilli]

Hi,

the attached screenshot shows up the report in the web app.  As you can see the earliest date is chosen via the slicer (filter) - in this case 01.08.2021. 

Taking out the 01.08.2021 means no data are shown any longer. All data are connected to the earliest date. So your suggestion gets in a good direction. Do you have a solution for tis issue.

Thx and greetings from Germany Chilli