Forum Discussion

SevsBo's avatar
SevsBo
Icon for Responsive Resident rankResponsive Resident
1 year ago
Solved

Alter DirectQuery source but keep all existing tables and data?

I have a PBI report that is linked via DirectQuery to a report called "Report 2a". We have recently made some changes to that report, so it made sense to rename it & it data model to "Report 2b". Thi...
Need Help
  • SevsBo's avatar
    SevsBo
    1 year ago

    No real solution found. I think what I am trying to do simply isn't possible in PBI, but I have raised a suggenstion for product development to enable this.

v-pnaroju-msft's avatar
v-pnaroju-msft
Icon for Community Support rankCommunity Support
1 year ago

Hi SevsBo,

Thank you for your followup.

Based on my understanding, in instances where the source dataset has been renamed, the only supported approach is to remove the broken tables and re-add them manually using the new dataset connection ("Report 2b") via Get Data > Power BI Datasets. However, to avoid recreating all the report visuals and measures, please use the "Manage Relationships" option carefully after re-adding the tables, so as to restore only the dataset bindings without affecting the entire report.

If you find our response helpful, kindly mark it as the accepted solution and provide kudos. This will assist other members of the community who may encounter similar issues.

Thank you.