Report works well on Desktop and Gives an error on Service (automatic refresh)

[jppuam]

Hello,

ive a dashboard that works well on Power BI Desktop, but when i try to schedule the refresh it gives an error : 

I've created on PowerQuery the fields TMA and TME with the formula thats shows the picture, and i think thats whats causing the issue. Can you understand whats the problem ?

thanks,

JP

[jppuam]

Hello,

in contact with microsoft support it was tuned the issue. 

The problem was related with the configuration of the gateway linked with dashboard.

thanks for the help,

JP

[ibarrau]

Hi. I don't think that's the problem. Your picture is showing a DAX code. The refresh issue is from the "Transform Data" menu.

It sounds like you have a Parameter defined in Power query. It's name is "t". There is an error regarding that value. Be sure that there is a default value for "t" because it might be that you haven't specified the value for that in the Service (you can specify it from report schedule refresh options under Parameters).

I hope that helps, feel free to show us Power Query code from the advanced editor if you can't find it yet.