Forum Discussion
Power BI Data Source Change - Keep Getting 'A DirectQuery" Connection Is Required
Hi,
I need help with changing the data source for a dashboard. I attempted the usual method by going to Transform Data -> Data Source Settings to change it. However, the current path is from another dashboard published on the server (Picture 1). When I try to change the data source, I receive an error (Picture 2). I want to update the path to the one shown in Picture 3. How can I do this? Is there any possible way or I have to redo everything from start - blank PBI?
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.
8 Replies
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.
Hi IfaZ_1,
We wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.
If my answer resolved your query, please mark it as "Accept Answer" and give Kudos if it was helpful.
If you need any further assistance, feel free to reach out.
Thank you for being a valued member of the Microsoft Fabric Community Forum!
Hi IfaZ_1,
we haven't heard back from you regarding our last response and wanted to check if your issue has been resolved.If our response addressed by the community member for your query, please mark it as Accept Answer and click Yes if you found it helpful.
Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!
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?
Hi IfaZ_1,
Thank you for using Microsoft Community Forum.
I understand that you're trying to change your Power BI data source from a Power BI Service dataset to an on-premise source in Import Mode but are encountering the 'DirectQuery connection is required' error.
To resolve this, first, check if your report is in DirectQuery or Import Mode by going to Transform Data --> Advanced Editor. If it's in Import Mode, changing the source directly may not be possible. Instead, try updating the connection in Power Query’s Advanced Editor or reconnect using Get Data -->Power BI Datasets.
If your goal is to seamlessly switch between sources, consider using parameters to define the data source path, making future changes easier. However, if Power BI does not allow a direct switch, you may need to rebuild the report using the new data source.
Please Accept as solution if this meets your needs and a Kudos would be appreciated.
Regards,
Sahasra.Hi IfaZ_1,
I wanted to follow up on our previous suggestions regarding the issue. We would love to hear back from you to ensure we can assist you further.
If our response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. Please let us know if there’s anything else we can do to help.
Thank you.
Hi,
Sorry I was sick for a few days. Thank you for following up.
