Only some tables update from Sharepoint-hosted Excel

[melissacole1]

I have an Excel workbook, hosted on Sharepoint, which has about 12 tables in it. I connected all of them to a PBI dashboard, and they all pulled in just fine. However, when I attempt to refresh the data, using the PBI "refresh" button, only about half of the tables update, and the rest do not.

The tables come from the same workbook, and pulled in just fine. Any thoughts about what to do about this issue?

[amitchandak]

@melissacole1 , Open power query. Do you see any error messages? if yes, Please share that. There can some data-type-related errors, try to address those and refresh again.

refer if needed

debug issue
https://www.youtube.com/watch?v=OE6DPmKqN7s


refer how to handle error in power query
https://www.youtube.com/watch?v=OE6DPmKqN7s
https://www.youtube.com/watch?v=9-Lag0VOiTs

[melissacole1]

Thanks! This ended up being user error. (Doesn't it always?) I appreciate you pointing me in a direction that helped me discover it!