Report with Excel - data set doesn't refresh

[Yael]

Hello,

I created a report on PBI Desktop with an excel file on share point as the data set. This excel file contailns some macros. 

The first few times I opend the report, and clicked "refresh", the report was presenting the updated data. Now when I click refresh, the data is not updated... More so, I published the report to PBI Service, and I cannot refresh the report from there either.

Thank you

[v-huizhn-msft]

Hi @Yael,

Now, neither of Power BI desktop and Power BI service refresh, right? If it is, what are the separate error message? Could you please share more details for further analysis.

Best Regards,
Angelia