Data formula in excel file not updating when dataflow is updated

[FedericoF]

Hi everyone,

I have a dataflow which gets raw data from the DB.

With the dataflow I do the ETL, then I created a ML model on these data and applied it to another table, an Excel file I loaded directly in the wizard (which uploaded to OneDrive).

Everything works fine, but there's one issue.

The ML model should predict something, in this case the quantity sold daily by the store.

I thought I could make these prediction variable in time, that's why in the excel file I used a column with data where the first cell references the variable 

Data partenza = TODAY()+10

The problem I'm facing is this: when I refresh the dataflow, the predictions are created starting from 04/02 (I created the dataflow some days ago), when they should start from 09/02.

What I wanted to achieve is this: 

if I create a prediction today I want the first day predicted to be 09/02,

if I create a prediction tomorrow I want the first day predicted to be 10/02,

and so on..

I don't understand why this is happening, and probably it's a small thing that I'm not thinking of but I've been struggling on this for days.

Thank you for your time, any help is appreciated

[v-jiewu-msft]

Hi @FedericoF ,

If I understand correctly, the issue is that you couldn’t get the updated as expected when you refresh the dataflow. Please try the following methods and check if they can solve your problem:

1.Ensure that the calculation mode in the Excel file is set to automatic.

2.Check that the formula references in the Excel are correct.

3.Verify that the data connection between the Excel file and the dataflow is properly configured.

4.Make sure that the data types in the file are correct.

5.Try refreshing the dataflow again and see if the update as expected.

Best Regards,

Wisdom Wu

[FedericoF]

Hi @v-jiewu-msft ,

I checked once again all the things that you mentioned, but unfortunately nothing changed.

The problem it's not in the excel file itself, but I think it's in the way PowerQuery or PowerBi reads it.

The prediction starting date I'm expecting today is 12/02/2024, but this is the result

Looks like DirectQuery doesn't apply the formula that changes the starting date, and it is applied only when i manually open the excel file.

Am I doing something wrong?

Is there a way to do what I'm trying to do?

Thank you for your time.