Forum Discussion
will not update data
- Anonymous4 years ago
Hi AndrejZevzikov ,
Whenever you refresh your data, Power BI must query the underlying data source. The entire refresh process consists of multiple stages, depending on the storage model of your dataset.
Power BI does not import data through a connection that operates in DirectQuery/LiveConnect mode. Instead, whenever a report or dashboard queries a data set, the data set returns results from the underlying data source. power BI transforms the query and forwards it to the data source.
Power BI imports the data from the original data sources into the dataset. Power BI report and dashboard queries submitted to the dataset return results from the imported tables and columns. You might consider such a dataset a point-in-time copy. Because Power BI copies the data, you must refresh the dataset to fetch changes from the underlying data sources.
So when you delete or rename a column in the id DB of one of the tables. You need to reconnect to the desktop and republish, this is by design.
For more information, please see:Data refresh in Power BI
Hope it helps,
Community Support Team _ Caitlyn Yan
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
I am very interested if anyone can explain this.
I have experienced the same issue, with a work around, but still do not know why this occurs or how to fix it without a work around.
What we had tried without success:
1. Deleted the dataset and report. Re published
2. Deleted the datasource connection cache within the PBIX
3. Restarted the capacity
What worked for us:
1. We added the deleted column back in source.
It's look like very unefficent solution ( I hope there is other way to solve this.