cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Re: Data Integrations not working at all? Unexpected Error

@dazhang

yes i tried deleting the connection set as an attempt to start from the ground up, but the error was happening before that (and is happening on new, totally clean slate retries as well). I treid starting totally fresh with very simple datasets, same result. no integrations are working for me regardless of source/type (have tried excel in onedrive, simple table in sql, simple csv file - none of them work)

 

@AccuFloDev same issues exactly. 

Highlighted
Power Apps
Power Apps

Re: Data Integrations not working at all? Unexpected Error

@AccuFloDev and @drold, can you share the Request IDs for the errors you're seeing?

Highlighted
Advocate II
Advocate II

Re: Data Integrations not working at all? Unexpected Error

Here's my most recent error from trying to import from Excel through PowerQuery: Request ID: d372c017-0846-4d8e-9460-1202e72a9a2b (Screenshot attached)
Highlighted
Frequent Visitor

Re: Data Integrations not working at all? Unexpected Error

@dazhang mine seems to be working as of today, thank you for the help and replies 

Highlighted
Power Apps
Power Apps

Re: Data Integrations not working at all? Unexpected Error

@AccuFloDev, the issue is that your CRM instance's root business name does not match its domain name. We've put in a fix for this that should be available by the end of next week. If you need a workaround before then, please try renaming your CRM instance's root business unit name to match its domain name.

 


@AccuFloDev wrote:
Here's my most recent error from trying to import from Excel through PowerQuery: Request ID: d372c017-0846-4d8e-9460-1202e72a9a2b (Screenshot attached)

 

Highlighted
Advocate II
Advocate II

Re: Data Integrations not working at all? Unexpected Error

Hey @dazhang, thanks for the update.

A couple of questions based on your previous answer:

1. CRM Root business name does not match domain name:. Can you explain what the root business name is and where to find/change it?

2. Can you elaborate on what you mean by domain name? Are you talking about the default domain for our O365 organization?

Thanks.

Highlighted
Power Apps
Power Apps

Re: Data Integrations not working at all? Unexpected Error

@AccuFloDev, to find your CRM instance's domain name:

  1. Sign into https://admin.powerapps.com/
  2. Click on your PowerApps environment
  3. Click on "Manage security for this instance".
  4. Look at the URL in your browser, it should be something like orgABC.crm.dynamics.com. The orgABC is the domain name of your CRM instance.

And to find your root business unit name:

  1. Go to https://orgABC.crm.dynamics.com (replace orgABC with the domain name you found above)
  2. Open Settings, Security, and click on Business Units
  3. Your root business unit should be shown in the next screen.

Can you see if those two are matching?

Highlighted
Advocate II
Advocate II

Re: Data Integrations not working at all? Unexpected Error

Hey @dazhang, I followed your instructions and the instance names do not match (The root BU name is some randomly generated format "orgXXXXXX" where X is a hexadecimal digit.
However, I now have a new issue: when I go to rename the Business Unit, it asks me to enter a Parent Business (of which I have none) so I can't save the changes. After reading this MS Article, I found this:


The organization (also known as the root business unit) is the top level of a Dynamics 365 business unit hierarchy. Dynamics 365 automatically creates the organization when you install or provision Dynamics 365. You can’t change or delete the organization name.

Because of this, I cannot apply the fix you suggested.  Any other suggestions?


 

Highlighted
New Member

Re: Data Integrations not working at all? Unexpected Error

As of today, I am also experiencing the same issue with "Unexpected error" on refresh attempts. Latest attempt information:

 

Session ID: 6ac380b1-bfae-4774-a4ea-0bd955e86dc4
Request ID: 280c9bbc-f28e-4acb-ac99-ae47f4c945b1
 
Previously working projects have stopped working. New projects generate this error message dialog after editing the project. Subsequent refresh attempts display the following error message in the Load Progress dialog:
 
Something went wrong. (Job ID: 0e9d29fe-26cf-4008-b9e5-97225dd7eeb4)
Highlighted
Power Apps
Power Apps

Re: Data Integrations not working at all? Unexpected Error

@AccuFloDev, the fix for this issue is deployed now, so the workaround should not be needed any more. Would you mind trying again?

 


@AccuFloDev wrote:

Hey @dazhang, I followed your instructions and the instance names do not match (The root BU name is some randomly generated format "orgXXXXXX" where X is a hexadecimal digit.
However, I now have a new issue: when I go to rename the Business Unit, it asks me to enter a Parent Business (of which I have none) so I can't save the changes. After reading this MS Article, I found this:


The organization (also known as the root business unit) is the top level of a Dynamics 365 business unit hierarchy. Dynamics 365 automatically creates the organization when you install or provision Dynamics 365. You can’t change or delete the organization name.

Because of this, I cannot apply the fix you suggested.  Any other suggestions?


 


 

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Users online (5,964)