Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
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

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
v-sihou-msft
Microsoft Employee
Microsoft Employee

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

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.

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.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.