DataFlows Data Destination

[AdarshPanasri]

Hello Everyone, I am trying to use dataflows to ingest data from sharepoint to onelake, The source query ran fine and now I want to write the data to the Onelake destination, but when I try to configure the destination connection details its not showing up the lakehouse present in my workspace and I believe its trying to create a new Lakehouse for me as there are few tables present in the lakehouse but in flows I am not able to see any, can someone please help here.

Thanks

[Bharti_Das]

Please check the data destination at the bottom of the Query settings pane on the right side of the Power Query editor. If a destination is already set, you can change it using the gear.

In the Connect to data destination dialog box, edit the connection and you need to sign in using your Power BI organizational account to set the identity that the dataflow uses to access the lakehouse.

[AdarshPanasri]

Tried doing it, but I think it is somehow logging me into a different workspace instead of using the current session, not sure how I can stop it from redirecting to the other session.

[Anonymous · Accepted solution]

Hi @AdarshPanasri ,

Thanks for using Fabric Community. Can you please try to re-create a new Dataflow Gen 2.

Ideally you should be able to see your lakehouses present in all workspaces

Incase if you are still facing the issue. The best course of action is to open a support ticket and have our support team take a closer look at it.

Please reach out to our support team so they can do a more thorough investigation on why this it is happening: Link 

After creating a Support ticket please provide the ticket number as it would help us to track for more information.

Hope this helps. Please let us know if you have any other queries.

[Anonymous]

Hi @AdarshPanasri ,

We haven’t heard from you on the last response and was just checking back to see if your query was answered.
Otherwise, will respond back with the more details and we will try to help .

Thanks