Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
@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
Thanks! This ended up being user error. (Doesn't it always?) I appreciate you pointing me in a direction that helped me discover it!
User | Count |
---|---|
93 | |
85 | |
78 | |
68 | |
62 |
User | Count |
---|---|
113 | |
99 | |
96 | |
64 | |
58 |