Forum Discussion
Power BI Data Source Change - Keep Getting 'A DirectQuery" Connection Is Required
Hi IfaZ_1,
Thank you for the clarification. Based on your description, the associate's dashboard was built using a Power BI Service (published dataset) as its data source. Now, you want to redirect it to the original on-premise source.
Unfortunately, in Power BI, you cannot directly switch a report from a published Power BI Service dataset back to an on-premise data source because of differences in connection types and structures. Power BI treats Service datasets and on-premise sources differently, and direct swapping is restricted, especially when moving from Service datasets to Import or DirectQuery sources.
To achieve this, you would need to rebuild the associate’s dashboard by connecting it freshly to the on-premise source. You can speed up this process by reusing the existing report by copying visuals and pages into a new PBIX connected to the on-premise data source and rebuilding the measures and relationships if they were built inside the Service dataset.
I hope this helped! Feel free to ask any further questions. If this resolved your issue, please mark it as "Accept as Solution" and give us Kudos to assist others.
Thank you.
You are showing two different sources, with the latter being an import mode on-premise source.
Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?
Hi,
Sorry it took me so long to get back, I was sick for a few days.
Our data source is on-premise, and we've built a dashboard based on it. An associate has created a new dashboard using our published server dashboard. We want to leverage this associate's dashboard further by redirecting its data source back to our on-premise source (as shown in Picture 3).
However, I'm encountering errors (as shown in Picture 2) whenever I attempt to change the data path. Is there a way to modify the path, or do we need to rebuild the dashboard from scratch?
