How do I disconnect my report from OneLake data hub and connect to a new data source not in OneLake?

[lihan]

Hi I have a report currently connected to a data source in OneLake data hub, now I want to disconnect and use another data source not in OneLake data hub, how can I do that?

[amaasen]

I'm also having this issue. Did you ever find a resolution? 

[Shkelzen_zariqi]

I have the same problem as you. I want to change the data source, but when I click on "Data Source Settings," it now opens the OneLake Data Hub. I can’t change the source to SSAS Azure or other sources. I’m trying to find a solution, but I haven't found anything yet.

As for the comments below, Power Query is disabled, so we can't access it.

[Anonymous]

Thank you @Uzi2019  for your prompt reply.

Hi @lihan ,

Based on the information you have provided, you want to disconnect the report from the OneLake data centre and connect it to another data source. Please follow the steps below:

1. Open the Power Query editor. Locate the query that is connected to the OneLake Data Centre. Right-click the query and select to view the connection details. If you no longer need the query, change the source of the query or delete the query. This action disconnects the report from the OneLake Data Centre.
2. In the Power Query editor, from the tab, select the appropriate data source type to connect to. Follow the prompts to establish a new connection, making sure you have the necessary credentials and connection details. After connecting convert the data as needed and load it into the report.
3. After loading the new data, update or recreate the visual objects in the report to reflect the new data source.
4. After making the necessary changes, save the PBIX file and publish it to the Power BI service.

For more detailed information about connecting to different data sources in Power BI, you may refer to the following documentation:

If you encountered any specific problems or error messages during this process, please provide more details? For example, what type of data source did you try to connect to and did you see any specific error messages?

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lihan]

@Anonymous thanks for you reply, but please note Power Query editor isn't available, all the option besides data source setting are greyed out. 

[Uzi2019]

Hi @lihan 

try the video below
https://www.youtube.com/watch?v=MgU3sSI0y-A

I hope it helps you.

[lihan]

This is a question specifical about onelake data hub, its different from any other disconnect data source and connects to a new one. You can see I don't have any other options.