Forum Discussion
Responsive ResidentAlter DirectQuery source but keep all existing tables and data?
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.
Community SupportThankyou, HarishKM, for your response.
Hi SevsBo,
Based on my understanding, DirectQuery connections to Power BI datasets or Analysis Services models do not appear in Power Query (Transform Data). This might be the expected behaviour, as those sources could be managed through the composite model and might not be exposed in the M code or Advanced Editor.
Please follow the method outlined below, which may help resolve the issue:
- If your report is published, navigate to your report > Settings > Dataset. Click on "Choose a different dataset" and select the renamed dataset (for example, "Report 2b"). This will retain all visuals, measures, and structure intact.
If you find our response helpful, kindly mark it as the accepted solution and provide kudos. This will assist other community members facing similar queries.
Thank you.