Power BI Service - Data Missing after refresh

[guibenassi]

I have some files that works fine in Power BI desktop, but after upload and refresh the files on service power BI some data doesn´t shows any more.

I try to delete some measures and some case it works, but I can not work without this measures.

Above one measure that causes the problem.

Desc = calculate(sum('Receber Mysoft'[DescComercial]);'Receber Mysoft'[cfop]<>"5.202";'Receber Mysoft'[cfop]<>"6.202")

[jakemorris606]

Hello,

not sure if anyone is stilll having simular issue, i had this issue for a couple of days ... for me i had the incremental refresh data starting '1' month before data on the table, so in desktop my dataset was full, but once i published to service and it refresh it would only pull in 1 month of data resulting in missing data, so if anyone has this issue going forward this i one to check.      service will use parameters set in desktop.

[Anonymous]

@mdmoo Can you elaborate more on your issue and solution please?

@GilbertQ That's the strange part, when I refresh my date in Power BI desktop, it just works perfectly fine also when publishing in web service. However, when automated refresh is done in web service, only two graphs (with calculation) of 27 are turning blank (deleted values/blank values). It looks like de calculated columns in these two graphs won't work in web service, noticing that it worked perfectly fine before. 

Is there any reaction on the ticket to Microsoft? 

[guibenassi]

@GilbertQ @Anonymous describe exactly what happens, some reports works fine, others don´t and there are no problems in Power BI Desktop or even in uploading, the error appears only after refresh the service.

I am expecting a call from the ticket today, hopefuly we will have good news.

[guibenassi · Accepted solution]

@Anonymous @mdmoo @GilbertQ 

Microsoft answer the ticket with a solution.

The problem is caused by a date issue, when refresh in power bi service they invert day and month, the day shows as month and the month as day.

The solution goes to change the type of the columm in the query editor, changing the columm type from text to date.

In the begining I change the type direct in the table section, when refresh by power BI service it get the data from the query wich is in text format and bringing problems with English an EU date system.

Hope I help you guys.

Thanks for the support

[yusufashiq]

Excellent solution

[JSwamina]

i changed my date/time format to date only format in the query editor , my report is now viewable. thank you.

[GilbertQ]

That is great to know and I would recommend best practise is always to set your column data types to ensure that they are in the valid format.

[Anonymous]

I'm having the same problem, since last week 😕  Report has been working perfectly for weeks and now suddenly deletes data after refresh. 

Im saying 'deletes, because I've found out that after updating the file, the data is shown again in the graph. However, after refreshing, the data is just missing. After downloading the file from PBI service, I see that the columns with data are blank (have been deleted).

My data set contains data with thousands with decimal number in dutch format (so with comma instead of dot) and is calculated dividing price (decimal) by total. Maybe it has to do with this, not sure? 

[guibenassi]

Hello, I am not sure what cause this issue, but I have a feeling that can be a problem with regional format, im my case I use big volume of data ( 9 Million lines) and use Brazilian format (comma instead of dot).

I open a service call with Microsoft team that is working in that.

[GilbertQ]

It could possibly be a bug, but I have never seen the Power BI Service delete any data.

I would also double check that the latest version of the Power BI On-Premise Data Gateway is installed?

[guibenassi]

Hello Gilbert.

For sure it is a good start, I checked the gateway version and desktop version in advance to post this issue.

Thanks

[GilbertQ]

If that is the case I am not sure what could be causing the issue.

The only other test I could think of before logging a support request is to try and upload the report into a new app workspace, schedule a refresh and see how it refreshes as expected?

[guibenassi]

I have already uploaded in a different workspace, delete the old report but the problems persist.

I have already opened a ticket service in Microsoft, and there are more than 10 days duration and no effective response at all.

[mdmoo]

I'm seeing something similar. It seems like some of my measure don't calculate anymore. The really odd thing is that when I get data from a Power BI dataset, I see a similar thing, even when the same measure shows up in the online version of the report. I believe this is a new bug.

[mdmoo]

I found my issue, it was in the operator error section of errors.

[guibenassi]

Hello Mdmoo, can you describe in more details what you did to fix it.

This is a big issue to me, and if you can help me I will be very grateful.

Thanks

[GilbertQ]

Hi there

Thanks for letting us know.

I was fairly certain it could have been something that changed in your data.

I would suggest refreshing the data in Power BI Desktop and checking to see if there are any errors on refreshing?

[GilbertQ]

Hi there

When you are in the report in the Power BI Service, do you have the default filters set or persistent filters?

I have never seen data refreshing if it was the same in Power BI Desktop.
What I have seen is filters or slicers being applied to the reports, which makes it appear that there is data missing.

[guibenassi]

Hello Gilbert,

I just update and refresh the report in service power BI, I don´t use any filter at all.