Data Doesn't show in Service, but it does in Desktop App

[FilaGr]

Hello community.

I have faced an issue where my report shows as intended in the Desktop app, but whne i publish it on the service, the data shows for a split second and then shows blank.

This is only for a specific measure. I have checked the measure, import the data from another source, but still the same issue. 

Here is video showing what happens. 

I can't seem to figure out why.

Can anyone please help?

[FilaGr · Accepted solution]

Good morning.

I have now re done the whole model as a new report and everything seems to be working fine.

Don't know what caused it, but it behaves as excpected now. 

Thank you for all your time and effort. 

[v-pnaroju-msft]

Hi FilaGr,

Apologies for the inconvenience caused.

Thank you for the update and please keep us posted on the updated information. Should you have any further queries, kindly feel free to contact the Microsoft Fabric community.

Thank you.

[v-pnaroju-msft]

Hi FilaGr,

We are following up to know if you have had a chance to look at the suggested solution for the issue. If you have any more questions, please feel free to ask the Microsoft Fabric community.

Thank you.

[FilaGr]

Good morning.

Back to work yesterday so i tried the recomended solution, but not luck.

The Table provides values, but after a refresh it is a blank table.

There is no errors in the refresh history either.

and i got the same issue with having re established my connections. 

I will re do the whole model again from the begining on a new report and see if i get a different result. 

[v-pnaroju-msft]

Hi FilaGr,

Thank you for your update.
May we kindly request you to inform us of your expected time of return.
Once you resume work, please try the suggested solution and let us know if it resolves the issue. Should you have any further queries, please do not hesitate to reach out to the Microsoft Fabric community for assistance.

Thank you.

[v-pnaroju-msft]

Hi FilaGr,

We would like to follow up and see whether the details we shared have resolved your problem.
If you need any more assistance, please feel free to connect with the Microsoft Fabric community.

Thank you.

[FilaGr]

Hello @v-pnaroju-msft .

I am currently on holiday, so will try this solution once i return to work and update here the results.

Thank you very much.

[v-pnaroju-msft]

Hi FilaGr,

Thank you for the update.

Based on my understanding, the issue may not lie within the DAX expression itself, but rather with the data available after the refresh. Power BI Desktop and Power BI Service can behave differently under the following circumstances:

1. Source credentials, query folding, or filters might be modifying the dataset during the refresh in Service.
2. Data privacy levels or gateway misconfigurations could be silently causing incomplete or empty data loads.
3. Locale or regional format settings in the Service may result in unexpected nulls or blank values.

Kindly consider trying the following steps, which may help in resolving the issue:

1.Verify the data after refresh by creating a table visual using the below DAX. This will help confirm if relevant rows exist after refresh in the Service. Please place this visual temporarily on the report page:

Table =
FILTER(
'Machines KLUBB Reporting',
UPPER(TRIM([Build By])) = "CPL" &&
UPPER(TRIM([Do Not Count])) = "FALSE"
)
2.Navigate to Dataset and then to Explore Data, and confirm whether the matching rows exist in the dataset following refresh in the Service.

3.Go to Workspace > Dataset > Settings > Refresh History and check for any warnings, partial loads, or differences in row counts compared to the desktop version.

4.Please reconnect to the data source and make sure that the column "Do Not Count" is clearly converted to text using the following expression:Text.Upper(Text.Trim(Text.From([Do Not Count]))). Reapply this and perform a refresh.

We hope the information provided is helpful in resolving the issue. Should you require any further assistance, please feel free to contact the Microsoft Fabric community.

Thank you.

[v-pnaroju-msft]

Hi FilaGr,

Thank you for your explanation.

From what I understand, your model is in Import mode, and the Planned measure shows blank only after you refresh. The problem is probably because of differences in data or data types after the refresh in Power BI Service. Sometimes in Power BI Service, text or boolean data acts differently after refresh because of case sensitivity, empty values, or data type differences.

If you use a filter like this:
'Machines KLUBB Reporting'[Do Not Count] = "FALSE"
it may show blank if the column is actually Boolean type, not text, or if the value is False (not the word "FALSE"), or if there are extra spaces.

Please try these steps to fix the problem:

1. If Do Not Count is a Boolean column, use this DAX code:
   Planned =
   CALCULATE(
   [Total Machines],
   'Machines KLUBB Reporting'[Build By] = "CPL",
   'Machines KLUBB Reporting'[Do Not Count] = FALSE()
   )
2. If it is a text column, use case-insensitive filtering like this:
   Planned =
   CALCULATE(
   [Total Machines],
   FILTER(
   'Machines KLUBB Reporting',
   UPPER(TRIM([Build By])) = "CPL" &&
   UPPER(TRIM([Do Not Count])) = "FALSE"
   )
   )

3. Also, make sure that the Machines KLUBB Reporting table has “Include in report refresh” turned on. You can check this by right clicking the table in Power Query and going to Properties.

We hope these steps help solve your problem. If you have more questions, you can always ask the Microsoft Fabric community.

Thank you.

[FilaGr]

Thank you for the reply.

The Column was set as text column and the table was already checked to be refreshed.

I did update the measure to the suggested one, and publish the report again to the service, but still the same result.

Planned =
CALCULATE(
[Total Machines],
FILTER(
'Machines KLUBB Reporting',
UPPER(TRIM([Build By])) = "CPL" &&
UPPER(TRIM([Do Not Count])) = "FALSE"
)
)

[v-pnaroju-msft]

Thankyou, @FBergamaschi, for your response.

Hi FilaGr,

We thank you for your question on the Microsoft Fabric Community Forum.

Based on my understanding, Power BI Service calculates time functions like NOW() or TODAY() using UTC time. This can be different from the local time you see in Power BI Desktop. During auto page refresh, the date filter may stop working properly, especially if DirectQuery has not finished running before the visual is shown. This can cause the measure to show blank results.

Please try the following steps which might help fix the problem:

1. Use UTCNOW() instead of NOW() or TODAY() and make sure all time related calculations use UTCNOW(). This will avoid problems with different time zones.
   For example: ValidDate = IF('Calendar'[Date] <= UTCNOW(), 1, 0)

2. Make sure the measure can handle empty or missing values, especially when using Date filters. You can use DAX functions like ISFILTERED or HASONEVALUE for this.

Also, please check these helpful links:
Data refresh in Power BI - Power BI | Microsoft Learn
DirectQuery in Power BI - Power BI | Microsoft Learn

We hope this information helps you solve the issue. If you have more questions, please feel free to ask in the Microsoft Fabric community.

Thank you.

[FilaGr]

Thank you for the reply @v-pnaroju-msft 

I made a mistake and my model is actually an import mode. 

The measure that keeps showing no values in teh service doesn't have a NOW() or TODAY() calculation. 

Planned =

CALCULATE(

    [Total Machines],

    'Machines KLUBB Reporting'[Build By] = "CPL",

    'Machines KLUBB Reporting'[Do Not Count] = "FALSE"

)

If i Publish and the Refresh Schedule is turned off, then the data shows as intended. If i however enable scheduled Refresh or if i manually refresh it, then the card shows Blank Values. 

The one measure that did have a TODAY() calculation, is showing without any issues, i have however changed it to UTCTODAY().

YTD Target =

CALCULATE(

    COUNT('Machines KLUBB Reporting'[Planned Completed Date]),

    'Machines KLUBB Reporting'[Planned Completed Date] < UTCTODAY()

)

All measures on that Card Visual come from the same source as well, so whne i first upload it works,

But once i refresh it doesn't.

[FBergamaschi]

I asked authorization to see the video, please can you approve

Thx

[FBergamaschi]

Watched the video

Questions:

1 - are you in DirectQuery or Import mode?

2 - in the top part of the report (not visible when you share the screen) is there any filter set by default that goes in place? I ask this as when the measure goes blank in the cloud, data change also in the bar chart on top

3 - if you are in DirectQuery mode, do you have an automatic page refresh in place?

Best

If this helped, please consider giving kudos and mark as a solution

@mein replies or I'll lose your thread

consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

[FilaGr]

Also regarding Filters. 

the whole page has got a date Filter that is set up in the Desktop app, as intented, but no extra filters added in the Service. 

[FilaGr]

Hello Francesco and thankyou for coming back to me. 

Im am using DirectQuery and have enabled Refresh.