Forum Discussion
Credentials for an Organizational User
I have a Non-Premium Workspace that holds a Dataflow that is being used in an Excel file by a co-worker that has a Pro - License.
When he goes to refresh the Excel workbook he receives the, "We couldn't authenticate with the credentials provided. Please try again."
It also states that, "You are currently signed in." And the selected tab to the left is set at Organizational account.
When he clicks Connect he cannot get any further than this.
Clicking the 'Sign in as a different user' provides the web popup for him to select his information. Then he clicks Connect again and it has no effect.
What am I missing. He should have no problem updating this Excel Workbook.
Hi RobRayborn -If your co-worker is working with a Dataflow from a non-premium workspace, you need to:
1.Either upgrade the workspace to Premium or
2.Share the dataset in a Pro workspace.
Open the Data tab in Excel > Get Data > Dataflows.
- Click on Dataflow and check if the credentials are set properly (e.g., Organizational Account).
- If credentials are incorrect or out of date, remove them and re-enter the credentials.
Go to the Power BI service > open the Dataflow > click on the Settings > Permissions and ensure that your co-worker is granted the necessary access.
Verify that the Dataflow is in a Premium Workspace or ensure proper sharing permissions for Pro users.Ensure that the correct credentials are used when connecting in Excel.Double-check the permissions on the Dataflow in Power BI.Try clearing the cache and resetting the data connection in Excel.Ensure there are no authentication conflicts with multiple accounts.
3 Replies
Hi RobRayborn -If your co-worker is working with a Dataflow from a non-premium workspace, you need to:
1.Either upgrade the workspace to Premium or
2.Share the dataset in a Pro workspace.
Open the Data tab in Excel > Get Data > Dataflows.
- Click on Dataflow and check if the credentials are set properly (e.g., Organizational Account).
- If credentials are incorrect or out of date, remove them and re-enter the credentials.
Go to the Power BI service > open the Dataflow > click on the Settings > Permissions and ensure that your co-worker is granted the necessary access.
Verify that the Dataflow is in a Premium Workspace or ensure proper sharing permissions for Pro users.Ensure that the correct credentials are used when connecting in Excel.Double-check the permissions on the Dataflow in Power BI.Try clearing the cache and resetting the data connection in Excel.Ensure there are no authentication conflicts with multiple accounts.
Hi RobRayborn , Just checking in as we haven’t received an update from you regarding last response. Were you able to resolve the issue with rajendraongole1 's answer?
If solution was helpful, please mark it as Accept Answer and click Yes to confirm.
Feel free to let us know if you have any further questions—we’re here to help!
Thank you for being a part of the Microsoft Fabric Community Forum!Hi RobRayborn
I wanted to check if you had the opportunity to review the information provided by rajendraongole1 . Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.
