cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cwallace
Level: Powered On

Cannot view execution details for data integration project

We have been very successful writing Power Queries and mapping data into CDS using data integration projects created via https://web.powerapps.com. 

 

The effort required has been several orders of magnitude less than what was required to implement equivalent functionality using SSIS and we are excited about the potential of retiring our SSIS runtime environments and reducing time to value and operating cost.

 

Only thing standing in our way from moving forward at the moment is our current inability to monitor and troubleshoot refresh issues.

 

Although we have proven we can reliably execute both manual and scheduled refreshes, we are only able to somewhat monitor a manual refresh.

 

If we attempt to use the Show refresh history command for a given project, we are brought to the new https://admin.powerapps.com site and see the message "You don't have any projects yet."

 

During a scheduled refresh, if an error or warning occurs, we do get an informative summary e-mail however when we click on the link to view the execution details we are again brought to the https://admin.powerapps.com site and this time an error message such as the following is displayed:

 

Unable to get executions for project:'D2E-38504021-7c0e-4f68-8b5c-a7d9abf949d0'.Please check if project:'D2E-38504021-7c0e-4f68-8b5c-a7d9abf949d0' exist. Session id: 8ea69576-0c38-4d92-9016-50a7a9044f29

 

If it is relevant, we are located in Canada and we are currently testing in a test environment which is backing our Dyanmics CRM Sandbox instance.

 

 

8 REPLIES 8
Community Support Team
Community Support Team

Re: Cannot view execution details for data integration project

Hi @cwallace,

Could you please share more details about the error message within your app?

I have made a test on my side, and don't have the issue that you mentioned. The screenshot as below:8.JPGPlease check if the corresponding project has been removed from your Data integration part.

In addition, please also take a try to clear cache of your browser, then try it again to check if the issue is solved.

If the issue still exists, please consider take a try to submit an assisted support ticket through the following link:

https://powerapps.microsoft.com/en-us/support/pro/

 

Best regards,

Kris

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
cwallace
Level: Powered On

Re: Cannot view execution details for data integration project

Thanks for the reply Kris. I have cleared the browser cache as you suggested however it has not resolved the issue. I have attached some screenshots below to provide additional clarity.

 

We are starting in Edge browser at https://web.powerapps.com/ (note, we are NOT creating the Data integration project from https://admin.powerapps.com). See 1.PNG attached.

 

We create a project at https://web.powerapps.com/ and afterwards we checked to see if a new project was also created at the https://admin.powerapps.com location. No projects appeared here.

 

After initiaiting and completing a successful refresh from https://web.powerapps.com/ location, we try to view the associated refresh history by clicking on the Show refresh history button. See 2.PNG attached.

 

After clicking this command, the browser attempts to open the associated execution history from this location:

 

https://admin.powerapps.com/dataintegration/projects/D2E-b63a77a2-7060-4fcc-8942-6004b95ac174/executionhistory

 

The browser eventually fails to resolve the above URL and returns us to https://admin.powerapps.com/dataintegration/projects where there are no projects listed. See 3.PNG

 

 

 

 

 

newbike
Level: Powered On

Re: Cannot view execution details for data integration project

I have the same issue when my environment is Asia.

 

When the environment is US, the histories showed up normally.

 

 

newbike
Level: Powered On

Re: Cannot view execution details for data integration project

hi, support team, I have the same issue. When my environment region is US, there is no such issue. The issue happens when my environment region is in Asia. 

cwallace
Level: Powered On

Re: Cannot view execution details for data integration project

We have been working through MS support and they are advising us the issue is due to a region mismatch between our Office 365 tenant (Canada) and our CDS environments (US). 

 

We have confirmed we can create a new CDS environment in Canada region and all features work as expected.

 

We are now in the process of migrating our US CDS environments to Canada which we expect to resolve the issue for us.

Highlighted
newbike
Level: Powered On

Re: Cannot view execution details for data integration project

Hi @cwallace,

 

Could you recommand the technical support person to me? 

I raised support ticket previously, but ironically the Microsoft PowerApps support person I talked to don't even have PowerApps P2 license. That support person wasn't even familar with the PowerApps website.

cwallace
Level: Powered On

Re: Cannot view execution details for data integration project

I am not sure how you engaged MS support for this, but I recommend you raise the support ticket through the correct admin center, currently located at:

 

https://admin.powerplatform.microsoft.com/

 

This should route your request to the right team and individual.

 

Next, if you are contemplating moving your environments around, you may need to do what we did and also place a request to enable multi-geo tenancy. Without this enabled, you will not be able to copy an environment across different regions. For example, we could not copy our environment from the US to Canada without this feature enabled.

newbike
Level: Powered On

Re: Cannot view execution details for data integration project

@cwallace

 

Thank you, that is really helpful. Could you PM me your support's email?

 

I raised a ticket in the admin center too, but the support person I encountered was an amature, he resides in India office, he probably don't know how to create environment and integration projects.

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Users Online
Currently online: 182 members 5,128 guests
Please welcome our newest community members: