cancel
Showing results for 
Search instead for 
Did you mean: 

Error in calculated column only in power bi service, not in power bi desktop

I have a report where I calculate whether a sensor has been activated in the last three days or not. Until today it worked perfectly, but now I get an error message in Power BI Service (NOT in Power BI Desktop, there it works just fine). 

 

Error message: 

Couldn't load the data for this visual
The query referenced calculated column 'Sensors'[IsInactive] which does not hold any data because evaluation of one of the rows caused an error.

 

DAX: IF(DATEDIFF(DATE(RIGHT(FIRSTNONBLANK(LiveData[Date]; LiveData[Date]); 4); MID(FIRSTNONBLANK(LiveData[Date]; LiveData[Date]); 4; 2); LEFT(FIRSTNONBLANK(LiveData[Date]; LiveData[Date]); 2)); TODAY(); DAY) > 3; "Inactive"; "Active")

 

The reason for not calculating the date field directly is that it is formatted as text in the data source and query format is direct query for that table. 

 

I use the updated version of Power BI Desktop. Any suggestions?

Status: New
Comments
Moderator

Hi @andrmi,

 

It looks like the issue happens when you access the report on Power BI service, right? There should be a detail information with RequestID and ClusterURl, please share these information. 

 

Please download the report from Power BI service then open the report in Power BI desktop, refresh the data, check if any error occurs. 

 

Best Regards,
Qiuyun Yu 

Frequent Visitor

Hi @v-qiuyu-msft

 

Activity IDb0bbb1d3-c167-4faf-849c-4cda5ca52ea5
Request ID17d41be3-9c9d-8f27-912f-d22d3aefbde1
Correlation ID5f4f66f1-b18f-07b7-3fd8-cb2904ce440d
TimeWed Dec 19 2018 09:43:41 GMT+0100 (Central European Standard Time)
Version13.0.7683.188
Cluster URIhttps://wabi-europe-north-b-redirect.analysis.windows.net

 

 

The issue is only in Power BI Service. I downloaded the .pbix from Power BI Service, opened it in Power BI Desktop and refreshed the data, the visual worked without any issues. 

Moderator

Hi @andrmi,

 

In Power BI desktop, please check if calculated column 'Sensors'[IsInactive] and other DAX which reference this column have any error. 

 

If you republish the report to Power BI service, then access the report again, does the same issue occur? 

 

Best Regards,
Qiuyun Yu

Frequent Visitor

Hi @v-qiuyu-msft

 

I tried this. I get no errors in the DAX and no errors in the visual in Power BI Desktop. When I republish, I get the same error as before. 

 

Activity IDb0bbb1d3-c167-4faf-849c-4cda5ca52ea5
Request IDd5bcc469-ada1-cf43-69a3-504bcf75f30c
Correlation IDbfed269b-a1f6-7b55-f8f2-f789572a5169
TimeThu Dec 20 2018 08:36:42 GMT+0100 (Central European Standard Time)
Version13.0.7683.188
Cluster URIhttps://wabi-europe-north-b-redirect.analysis.windows.net

Moderator

Hi @andrmi,

 

Till now, it's hard to provide further help on forum side. I would suggest you create a support ticket to let engineers look into the issue on your side. 

 

Support Ticket.gif

 

Best Regards,
Qiuyun Yu