Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I updated ONE table deleting ONE column and now I cannot refresh the data. What gives? Is M$ saying that NO changes can be made to a table once it's uploaded into PowerBI?
I have also deleted said column in the data view of Power BI and still it does not refresh. I really do not want to (a) have to rebuild the entire dashboard and (b) have to worry about having EVERYTHING in a table hte first go around. There will be edit, ppl will want different aspects after seeing what the dashboard provides and is capable of. This cannot be how PBI works...
Solved! Go to Solution.
Read through the query steps for that table. It's referenced somewhere in there.
Proud to be a Super User!
I found this area, but how do I correct it from there? I tried using the "delete column" option to no avail.
You clearly have either
...that references that column. Or you have several of those things, but at least one. So in order for that thing to work, you need that column. If you want to get rid of that column you'll have to get rid of that thing that references it too. If you didn't have anything that ever used or referenced that column, you could delete it without consequence the way you think you should.
Proud to be a Super User!
It was a blank column, no value nor was it used anywhere.
Read through the query steps for that table. It's referenced somewhere in there.
Proud to be a Super User!
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |