Can I use the measure which created by Power BI Desktop from Excel data.

[yoshihirok]

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

[yoshihirok]

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() 

[Seth_C_Bauer]

@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...

[yoshihirok]

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

[Seth_C_Bauer]

@yoshihirok Is this a custom visual, or out of box?

[yoshihirok]

Hi @Seth_C_Bauer

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

[v-sihou-msft]

@yoshihirok

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,

[yoshihirok]

Hi @v-sihou-msft

Thank you for your reply, and try reproduce this issue.

I will clear this issue reproduce step.

Regards,

Yoshihiro Kawabata