Solved: Date Issues

Wecks · ‎01-14-2019

I have a dataset in a SharePoint List.

When i make a PowerBI report ii pull in the data no problem. I set a data refresh schedule.

I have a couple of filters that look at the date field. however when the data set refreshes the filter breaks and my reports are useless. It is almost like it defaults to a different date range. how can i stop this from happening.

Wecks · ‎01-16-2019

Hi,

I managed to resolve this issue. The data set was a sharepoint list that had a date field. I dragged the field along with a couple of other fields into a report and i noticed the dates were all in correct. I checked in the dataset under model that the date format was selected for the collumn and it was. locally the report work absolutley fine. When it was published the date format either changed to non uk time or dates were showing for months where data was not present which was confusing.

What I found out is that when i opened the query editor in the Power BI Desktop for the report in question and viewed the view the date collums was still showing as text even though the data set was showing as a date under the model tab. By modifying the type to date for the specific collumn in the Query Editor and then publishing the report everything functions as it should and my reports function as they should.

View solution in original post

v-jiascu-msft · ‎01-15-2019

Hi @Wecks,

1. What are these filters? Are they slicers? Or used in the connection?

2. What is it "the filter breaks"?

3. Can you please share some snapshots?

Best Regards,

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Wecks · ‎01-16-2019

Hi,

I managed to resolve this issue. The data set was a sharepoint list that had a date field. I dragged the field along with a couple of other fields into a report and i noticed the dates were all in correct. I checked in the dataset under model that the date format was selected for the collumn and it was. locally the report work absolutley fine. When it was published the date format either changed to non uk time or dates were showing for months where data was not present which was confusing.

What I found out is that when i opened the query editor in the Power BI Desktop for the report in question and viewed the view the date collums was still showing as text even though the data set was showing as a date under the model tab. By modifying the type to date for the specific collumn in the Query Editor and then publishing the report everything functions as it should and my reports function as they should.