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.
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!