cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Onaiggac
Frequent Visitor

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

I created a new column with today() expression.

Column = TODAY()

And put it to in a table

Capturar.PNG

 

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

Capturar.PNG

 

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.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Onaiggac
Frequent Visitor

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

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.

View solution in original post

3 REPLIES 3
Microsoft
Microsoft

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

@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
Frequent Visitor

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

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
Frequent Visitor

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

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.

View solution in original post

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors