cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
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.

 

Capture.PNGCapture2.PNG

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?

 

Thanks!

3 REPLIES 3
Highlighted
Anonymous
Not applicable

Re: Online Dataset Time Problem

Bump

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?

 

Regards,

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.
Anonymous
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

Announcements
Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

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

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 126 members 1,638 guests