Forum Discussion
will not update data
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.
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.
Correct me if I wrong,
if i created my report (in power Bi desktop) with DirectQuery option I will fix my issue, but i know (i could be wrong) if report cretaed with DirectQuery options and have some complex calculations it can have some issues with calculations results.
Hi AndrejZevzikov ,
Sorry I may not have explained it clearly. Switching storage modes does not solve this issue. The suggestion above means that no matter what storage mode you use, the refresh will go to the data source to find a matchable item based on the metadata (such as column name, etc.) used by PBIX , and when this item is deleted, it cannot be found, so an error will be reported, in which case the intelligent choice is to republish or restore the deleted column.
Also, you are right, there are indeed some limitations when using direct query, for details please check:Limitations of using Direct Query
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.