Power Bi connected to excel file on SharePoint but not always refreshed

[Recoba88]

Hi,

I connected Power Query directly to excel file in Sharepoint .

When I update some values in my excel file (on SharePoint) and then refresh the power query , sometimes the data refreshed and I see the right values but sometimes I can't see the right values although according Power Query the data was refreshed 

Any suggestions ?

Thanks a lot,

Igor

[Recoba88]

Hi,

I connected Power Query directly to excel file in Sharepoint .

When I update some values in my excel file (on SharePoint) and then refresh the power query , sometimes the data refreshed and I see the right values but sometimes I can't see the right values although according Power Query the data was refreshed 

Any suggestions ?

Thanks a lot,

Igor

[v-shex-msft]

Hi @Recoba88,

I test on my side without any issue, the file can be refreshed. Have you connect to  other database in excel? If this is a case, I think the delay is related of excel refresh source data.(i test simple excel file without any issue)

Regards,

Xiaoxin Sheng

[Recoba88]

Hi There are three excel file in sharepoint

I merged the data from 2 of these files with power query (to the third excel file).

All the files located in Sharepoint. When I update some values in first excel file . The third file not always refreshed although I see in power query that it was refreshed.  

The data in these files located only in excel

Help 😞

[v-shex-msft]

Hi @Recoba88,

>>I merged the data from 2 of these files with power query (to the third excel file).

Can you ensure you have turned on the refresh option?

In addition, have you clicked the "Close & Apply" button to apply these change?

Regards,

Xiaoxin Sheng

[Recoba88]

ofcourse

[v-shex-msft]

Hi @Recoba88,

Does this issue also appeared at report level?

Regards,

Xiaoxin Sheng