Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Nil_255
Regular Visitor

Scheduled Refresh Errors with the Dates

Hi Everyone,
I have a Fact table with some sales data and a date column and a separate date Table created in DAX with the CALENDARAUTO(). The tables are linked together in the data model by the dates and They are used to generate a visual displaying sales trends over the years.
 
On the line graph visual i tried using the dates from the Facts table as well as the dates from the Dates table. Same case when it comes to the filters (I use a date timeline) and both approaches seem to work fine on the desktop power bi.

The problem comes when i publish the report to trhe report sever which has a scheduled refresh running every day.
After each refresh , if i use the date table dates on the visual and the Fact table dates on the timeline filter, the visual become blank for some reason, if i use the fact table dates on the graphs and the the Dates table dates on the filter, all the values get grouped to the first date only (When i move the timeline to later dates it shows blank).

I could use the Facts tables dates on both ends but i need to be able to drill down on the report visuals and this becomes not possible with this approach.

Any idea what this may be caused by and the solutions?
Thank you.

1 ACCEPTED SOLUTION

change your filters to account for the service UTC.

View solution in original post

6 REPLIES 6
Nil_255
Regular Visitor

Thanks it looks good now

lbendlin
Super User
Super User

Recommendation is to use the dimension columns for the axis. In your case the Dates table date.  The facts table date column should be hidden.

I tried this today and it looks fine on the power bi desktop and even after i publish it to thhe report server
The problem comes when the scheduled refresh runs, the visuals which have the date from the date table as the axis become blank, any idea what might be the reason?

Timezone differences?  The Power BI Service runs on UTC.

I'm on UTC +3... any idea to adjust the data after it has been refreshed?

change your filters to account for the service UTC.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.