Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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.
Solved! Go to Solution.
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
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.
@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?
@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.
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
Excellent solution
i changed my date/time format to date only format in the query editor , my report is now viewable. thank you.
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?
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.
Hello Gilbert.
For sure it is a good start, I checked the gateway version and desktop version in advance to post this issue.
Thanks
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.
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.
I found my issue, it was in the operator error section of errors.
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
Hello Gilbert,
I just update and refresh the report in service power BI, I don´t use any filter at all.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.