Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I want to use a measure at my report in Power BI Service.
But now Error happend when a measure set on my visual property.
Data is Excel file on my OneDrive for Business.
Report create by Power BI Desktop 2.41.4581.361 64-bit .
Measure create at Power BI Desktop, it work well on report at Power BI Desktop.
Data Source at Power BI Desktop is URL of Excel file on OneDrive for Business, instead of local file by OneDrive Sync App,
Publish from Power BI Desktop to Power BI Service work well.
Report on Power BI Service work well except a measure.
Power BI Service version is 2.41.4581.361 64-bit
ERROR mean "This visuals can not read Data"
In my environment, ERROR deatil in Japanese.
Regards,
Yoshihiro Kawabata
The calcurated column is ERROR using DATEDIFF and NOW.
My test calcuated column :
OK : TestNow = NOW()
OK : TestMax = DATEDIFF('WeatherTable'[Date], MAX('WeatherTable'[Date]), MINUTE)
NG: TestDiff = DATEDIFF('WeatherTable'[Date], NOW(), MINUTE)
Regards,
Yoshihiro Kawabata
-- Edit : from NOW to NOW()
@yoshihirok I don't know if it's just a typo, but you don't have the open and close paren next to "NOW"... should be "NOW()"
Outside that, the calculation worked in my quick test...
Thank you @Seth_C_Bauer for typo.
I edit from NOW to NOW() on my post.
and still ERROR on my Power BI Service.
Regards,
Yoshihiro Kawabata
@yoshihirok Is this a custom visual, or out of box?
This ERROR happen any visual, like table visual, line visual, etc.
and also happen any property at using this to visual item, visual filter.
Regard,
Yoshihiro Kawabata
Does your issue still persist?
I haven't reproduced your issue. I created a similar calculated column as yours which can be dispalyed properly after publishing onto Power BI Service.
Regards,
Thank you for your reply, and try reproduce this issue.
I will clear this issue reproduce step.
Regards,
Yoshihiro Kawabata
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.