TODAY() functions works on desktop but fail in the web app

[Onaiggac]

I created a new column with today() expression.

Column = TODAY()

And put it to in a table

When I publish it on the PowerBI web app, it returns an error like this

In red it says something like

"There was an error with the data gateway".

And in the with box it says:

"Was not possible to recover the data for this visual. Try again later.

Try again later or contact the support. If you contact the support, give these details:

Task ID

Request ID

Correlation ID

Hour

Version

"

I think there is something with languages. My PowerBI Desktop is set to Portuguese (Brazil) and the web api (app.powerbi.com) is set to Portuguese.

[v-sihou-msft]

@Onaiggac

As the error message said, the issue is related to your gateway. You may re-install your data gateway and make sure it's online. If this issue still persists, please create a support ticket.

Regards,

[Onaiggac]

The gatway is fine and online. I have many other reports and they are running as expected.

I dont think TODAY() function use the gateway.

Anyway, I will try to create a support ticket.

Tks.

[Onaiggac · Accepted solution]

I found the problem.

My .pbix (Desktop) uses an account (database account) with default language diferent from the account that is used to access the data from the gateway.

When I change the gateway database account to use the same account that pbix uses, the error was fixed.