Showing results for 
Search instead for 
Did you mean: 
Not applicable

Online Dataset Time Problem

Hello everyone,


For most of my reports I import dates using Google Analytics, which works flawlessly. Most commonly, I connect from Power BI desktop to GA, using the built-in connector, and retrieve the date table.

Recently I started to play around with the datasets and the dataflows from the online side of PBI. 

Dataflows allows me to automatically retrieve all the dates since 2015 (start of our GA account) up until today. Once I import a the date dataflow into Power BI Desktop, the date feature works flawless as expected.


My problem starts when I connect a new dashboard in Power BI Desktop to a live dataset using the built-in connector. Aan example: I have an existing dashboard with data from last september until today (date data is being pulled using normal GA connector). When I create a line chart, the chart starts at the first date where data is available and stops on the date when the data ends. When I upload this dashboard to the online environment of PBI everything works as expected.

However, when I connect to this data flow and try to plot the same graph, I see way more date data that should not be present.


Normal situation with the dashboard with 'offline' information. Data starts in Jan 2018, as defined and runs through today.



Problem situation when connecting to the same dataset, but this time it has been uploaded to PBI service. The data runs until the end of 2019 (impossible since GA doesn't allow future dates). These additional dates must have been generated by Power BI itself somewhere.

 Annotation 2019-01-10 143442.jpg

Does anyone know why these future dates are generated and how I can make my online dataset work similarly to a normal one?



Not applicable

Re: Online Dataset Time Problem


v-danhe-msft Super Contributor
Super Contributor

Re: Online Dataset Time Problem

Hi @Anonymous,

Based on my test, I could not reproduce your problem, could you please share your sample data to have a test if possible?



Daniel He

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

Re: Online Dataset Time Problem

Hi Daniel, Thanks for helping out. I am not sure how I can provide you with a dataset, as the data is coming from the online dataset. As said in my first post. The problem only occurs when I use a live connection to the dataset. Using the dataset on the original PBIX file it was created doesn't create for this error. Interestingly, when I create a graph based on some data and add a report level filter saying that it should only include data up until today, the graph still continues running to the end of 2019. Hopefully this may help establishing the problem. Thanks again!

Helpful resources

Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 139 members 1,605 guests
Please welcome our newest community members: