Azure Data Lake Blob and PowerBI desto

[JMSNYC]

Hi.   I am having an issue that did not surface in my other PowerBI files.  

I have an Excel stored in a Blob Storage on Azure that I import into PowerBI to aggregate with other datasets.   When I update the Excel, the new data entry does not update into my PowerBI file, after I click "Refresh Preview" or "Refresh All".

Is this a set-up issue? In PBI? In Datalake Gen2?   Thank you for your help.   Best regards, JM

[v-yingjl]

Hi @JMSNYC ,

Please try it connect this execl file in a new blank .pbix file and try to refresh it in power bi desktop to check whether it works fine.

If not, you can share some screenshots or error message for further discussion.

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[JMSNYC]

Thank you very much for your help. Does this frequently happen? Do I need to recode my entire report? Thanks again. JM

[v-yingjl]

Hi @JMSNYC ,

It's hard to guarantee that whether it happens frequently. Maybe reduce the aggreation with datasets as much as possible is a short-term solution currently.

Best Regards,

Yingjie Li