Guest user (b2b) is unable to set Lakehouse or Warehouse as destination in our dataflow gen2

[ArekSE]

Hi,

We have a problem with Guest users (b2b) as they are not able to set Lakehouse or Warehouse as destination in our dataflow gen2.

Their permission on specific Workspace is setup as Admin.

They can add new dataflows, sources etc, but when they try to publish it without connection to Lakehouse or Warehouse, they are getting error under Refreshed column:

There was a problem refreshing the dataflow: 'Something went wrong, please try again later. If the error persists, please contact support.'. Error code: UnknownError. (Request ID: e64975c2-7b0f-4275-8d5c-d8d93ea91e60)

When they try to setup Data Destination to Warehouse or Lakehouse, under 'Connect to data destination' they need to login via 'Use another account' -> 'Sign-in options' -> 'Sign in to an organization' -> ... -> Sign (you can see that they are signing in to our environment).

All looks good until 'Choose destination target' screen, where they can see Warehouses list, but after pressing Next the error comes up:

The credentials provided for the Warehouse source are invalid. (Source at Warehouse.)

Again user is loging in, but switching account to 'Sign in to an organization', all looks OK, but after trying to connect, they are getting same error

The credentials provided for the Warehouse source are invalid. (Source at Warehouse.)

Does anyone knows what settings for guest accounts could be wrong?

What is more, we have noticed that they can not open Dataflow Settings:

after clicking it, nothing happens.

[v-prasare]

We are following up once again regarding your query. Could you please confirm if the issue has been resolved through the support ticket with Microsoft?

If the issue has been resolved, we kindly request you to share the resolution or key insights here to help others in the community. If we don’t hear back, we’ll go ahead and close this thread.

Should you need further assistance in the future, we encourage you to reach out via the Microsoft Fabric Community Forum and create a new thread. We’ll be happy to help.

Thank you for your understanding and participation.

[v-prasare]

Hi @ArekSE,

Ensure that the guest users have at least Contributor or Member role in the workspace and specific permissions on the Lakehouse or Warehouse:

• Open the Lakehouse or Warehouse in the Fabric workspace.

• Go to Manage Permissions.

• Ensure that the guest user has the appropriate "Can edit" or "Can use" access.

also check below:

• In Power BI Admin Portal, enable guest user access to tenant settings.

• Check if the guest users have write permissions on the workspace.

If you are blocked on this, i suggest you to raise a support ticket here with request Id details. so, that they can assit you in addressing the issue you are facing. please follow below link on how to raise a support ticket:

How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

Thanks,

Prashanth

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

[ArekSE]

Hi Prashanth,

thank you for your reply.

I have checked permissions on Lakehouse, Warehouse and Workspace - all are 

Read, Write, Reshare, ReadData, ReadAll, Monitor, SubscribeOneLakeEvents (Workspace Member).

Regarding Power Bi Admin Portal and tenant settings which exactly you recommend to check? The list is very wide (About tenant settings - Microsoft Fabric | Microsoft Learn).

Any other suggestions why system doesn't accept credentials when connecting Dataflow to Warehouse?

The credentials provided for the Warehouse source are invalid. (Source at Warehouse.)

[v-prasare]

@ArekSE, 

In this scenario if your blocked on this i suggest you to raise a support ticket here. so, that they can assit you in addressing the issue you are facing. please follow below link on how to raise a support ticket:

How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query