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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

BUG with TODAY() function

The TODAY() function works fine in PowerBI Desktop but returns error when I publish it in powerbi web app like I describe in my post

https://community.powerbi.com/t5/Desktop/TODAY-functions-works-on-desktop-but-fail-in-the-web-app/m-...

 

My gateway is running fine and have many other reports thats is ok.

Status: Needs Info
Comments
v-haibl-msft
Microsoft Employee

@Onaiggac

 

I just have a test on my side but cannot repro the same issue as you.

You can try to create a new PBIX file, create a simple table just by "Enter Data", create a column with TODAY() function. In this way, your report will not require gateway to refresh.

Then you can check the report after publish to Power BI Service to see if the TODAY() function can work well.

If it works in above scenario, it should be related to your gateway configuration.

 

BUG with TODAY() function_1.jpg

 

Best Regards,
Herbert

Vicky_Song
Impactful Individual
Status changed to: Needs Info
 
Onaiggac
Frequent Visitor

@v-haibl-msft

It worked in above scenario. The problem is in my gateway.

So, is there any configuration on Gateway to solve this issue?

 

Tks.