search

microsoft / powerapps-tools

Unsupported PowerApps Tools & Apps
MIT License
1.05k stars 434 forks source link

BUG]: Issue connecting to the new COE via PowerBI- ERROR MESSAGE LOADING BLOCK FAILURE #698

Closed margolee56 closed 3 years ago

margolee56 commented 3 years ago

Describe the bug Eror: "Loading Block by failure with others" COE CONNECTION IKSSUE

See attach screenshot.

I can be reach at 786 923632 or email margo_lee@mednax.com.

thanks

JeneferM-MSFT commented 3 years ago

Can you please share 1) What version of Core you are running 2) What version of (the appoximate date of download) the PBI?

margolee56 commented 3 years ago

See attach dashboard I’m trying to connect to

See below screenshot with Power BI version

[cid:image001.png@01D6EB59.87095200] Not sure what you means by what version of core I’m using.

From: Jenefer Monroe notifications@github.com Sent: Friday, January 15, 2021 3:18 PM To: microsoft/powerapps-tools powerapps-tools@noreply.github.com Cc: Margo Lee Margo_Lee@mednax.com; Author author@noreply.github.com Subject: Re: [microsoft/powerapps-tools] BUG]: Issue connecting to the new COE via PowerBI- ERROR MESSAGE LOADING BLOCK FAILURE (#698)

Can you please share

  1. What version of Core you are running
  2. What version of (the appoximate date of download) the PBI?

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://urldefense.com/v3/__https:/github.com/microsoft/powerapps-tools/issues/698*issuecomment-761176169__;Iw!!AmoheuNn!FLYGfw2tWKnb1VnJFFU9sJ6_wkOpEocRP_U2w9vU5qiRMsS33CxRjAEBeYfBCdws$, or unsubscribehttps://urldefense.com/v3/__https:/github.com/notifications/unsubscribe-auth/ASPLK3RQO4ICB4AKHZL7HX3S2CPHZANCNFSM4WEQV7WA__;!!AmoheuNn!FLYGfw2tWKnb1VnJFFU9sJ6_wkOpEocRP_U2w9vU5qiRMsS33CxRjAEBeVw7fA5E$.

manuelap-msft commented 3 years ago

Where it says "Loading blocked by failures in other queries" can you scroll all the way down to find the actual query that is failing?

If you navigate to make.powerapps.com > Solutions > next to the Center of Excellence - Core Components there will be a version number, can you let us know which one it is?

margolee56 commented 3 years ago

Hi Support, Please see the full error via connecting to the COE environment via Power BI. As to the solution being used I am validating that info and will send it to you as soon as possible.

Where it says "Loading blocked by failures in other queries" can you scroll all the way down to find the actual query that is failing? See the below error OrgUrl Loading blocked by failures with other queries. Environment Loading blocked by failures with other queries. App Loading blocked by failures with other queries. Flow Loading blocked by failures with other queries. Maker Loading blocked by failures with other queries. App Connection Reference Loading blocked by failures with other queries. Flow Connection Reference Loading blocked by failures with other queries. Audit Log Loading blocked by failures with other queries. Connector Loading blocked by failures with other queries. Flow Action Details Loading blocked by failures with other queries. NonProdWords Loading blocked by failures with other queries. CoE Settings Loading blocked by failures with other queries. Virtual Agent The key didn't match any rows in the table. Virtual Agent Component The key didn't match any rows in the table. Virtual Agent Flows The key didn't match any rows in the table. Virtual Agent Makers Loading blocked by failures with other queries. RPA Loading blocked by failures with other queries. RPA Sessions The key didn't match any rows in the table. Environment Maker Loading blocked by failures with other queries. Date Last Refreshed Loading blocked by failures with other queries.

From: Manuela Pichler notifications@github.com Sent: Saturday, January 16, 2021 7:23 AM To: microsoft/powerapps-tools powerapps-tools@noreply.github.com Cc: Margo Lee Margo_Lee@mednax.com; Author author@noreply.github.com Subject: Re: [microsoft/powerapps-tools] BUG]: Issue connecting to the new COE via PowerBI- ERROR MESSAGE LOADING BLOCK FAILURE (#698)

Where it says "Loading blocked by failures in other queries" can you scroll all the way down to find the actual query that is failing?

If you navigate to make.powerapps.com > Solutions > next to the Center of Excellence - Core Components there will be a version number, can you let us know which one it is?

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://urldefense.com/v3/__https:/github.com/microsoft/powerapps-tools/issues/698*issuecomment-761555044__;Iw!!AmoheuNn!HxqkGCpjnEe0Bl9I_jOXl-38CAE2xLPRxawTCzp7d6d9Lbx-YuBiKFVWWeiThS30$, or unsubscribehttps://urldefense.com/v3/__https:/github.com/notifications/unsubscribe-auth/ASPLK3UXK3WL7CTJCCFXVJ3S2GAITANCNFSM4WEQV7WA__;!!AmoheuNn!HxqkGCpjnEe0Bl9I_jOXl-38CAE2xLPRxawTCzp7d6d9Lbx-YuBiKFVWWX4BEyEj$.

JeneferM-MSFT commented 3 years ago

Hello it appears that you did not have the latest core bits that are required for the PBI to load. Please install the latest version of core (see installing upates) and then use the latest version of the PBI.

margolee56 commented 3 years ago

Please reopen this ticket

From: Jenefer Monroe notifications@github.com Sent: Monday, February 1, 2021 12:50 PM To: microsoft/powerapps-tools powerapps-tools@noreply.github.com Cc: Margo Lee Margo_Lee@mednax.com; Author author@noreply.github.com Subject: Re: [microsoft/powerapps-tools] BUG]: Issue connecting to the new COE via PowerBI- ERROR MESSAGE LOADING BLOCK FAILURE (#698)

Closed #698https://urldefense.com/v3/__https:/github.com/microsoft/powerapps-tools/issues/698__;!!AmoheuNn!Asf22_lBoIXTxEmw4a7DmGfpa34ND_d7eHgOgXdePWPjDUq1xNt99kywWvaOV0IX$.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://urldefense.com/v3/__https:/github.com/microsoft/powerapps-tools/issues/698*event-4275091691__;Iw!!AmoheuNn!Asf22_lBoIXTxEmw4a7DmGfpa34ND_d7eHgOgXdePWPjDUq1xNt99kywWohhgxE7$, or unsubscribehttps://urldefense.com/v3/__https:/github.com/notifications/unsubscribe-auth/ASPLK3VZFRD25FH3DKE2PJLS43SUDANCNFSM4WEQV7WA__;!!AmoheuNn!Asf22_lBoIXTxEmw4a7DmGfpa34ND_d7eHgOgXdePWPjDUq1xNt99kywWuHR08Mn$.

JeneferM-MSFT commented 3 years ago

Hello. If you still see this issue after update of Core and PBI, please let us know. But your error indicates that you do not have the PVA or RPA components, something that was put in core months ago. We just shipped the Feb release today so you should be good to go. Please be sure to remove unmanaged layers on update as described in installing upates

margolee56 commented 3 years ago

Hi support,

I followed the steps and still having issues. Can you please give me a call or can you setup a remote session.

From: Jenefer Monroe notifications@github.com Sent: Monday, February 1, 2021 1:04 PM To: microsoft/powerapps-tools powerapps-tools@noreply.github.com Cc: Margo Lee Margo_Lee@mednax.com; Author author@noreply.github.com Subject: Re: [microsoft/powerapps-tools] BUG]: Issue connecting to the new COE via PowerBI- ERROR MESSAGE LOADING BLOCK FAILURE (#698)

Hello. If you still see this issue after update of Core and PBI, please let us know. But your error indicates that you do not have the PVA or RPA components, something that was put in core months ago. We just shipped the Feb release today so you should be good to go. Please be sure to remove unmanaged layers on update as described in installing upateshttps://urldefense.com/v3/__https:/docs.microsoft.com/power-platform/guidance/coe/setup*installing-updates__;Iw!!AmoheuNn!EL7hj0pOHvyJNRsm7FlOZ0tL3wg-GcvKbf-nVMY7VM9FsF58ssQktbGDdzFPQm1H$

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://urldefense.com/v3/__https:/github.com/microsoft/powerapps-tools/issues/698*issuecomment-771045288__;Iw!!AmoheuNn!EL7hj0pOHvyJNRsm7FlOZ0tL3wg-GcvKbf-nVMY7VM9FsF58ssQktbGDd-O6vfcV$, or unsubscribehttps://urldefense.com/v3/__https:/github.com/notifications/unsubscribe-auth/ASPLK3RF4RKO3EPY34VLOTDS43UKTANCNFSM4WEQV7WA__;!!AmoheuNn!EL7hj0pOHvyJNRsm7FlOZ0tL3wg-GcvKbf-nVMY7VM9FsF58ssQktbGDd51QJbPQ$.

JeneferM-MSFT commented 3 years ago

To set expectations, this toolkit is not a supported product. It is a starter kit to get you going. So we are not support. We are here to help with issues that Power Platofrm customer see as budget allows. And as such we are not able to offer calls or remote sessions for our github users.

Can you please share here a screenshot showing the version of core you have installed? Please note that screenshots only work if you paste them in github, they will not show up if you paste in an email reply.

Here is what I am looking for: image

margolee56 commented 3 years ago

Hi Support,

Upon imported the most recent COE Toolkit the below error was received, the update toolkit was being imported at Power Appshttps://make.powerapps.com/environments/c5ed9853-e3fa-4692-a60e-f2574f7432d9/history URL

Note: the following steps was performed via the URL noted "The import of solution: [solution name] failed" error occurs in Dynamics 365 (microsoft.com)https://support.microsoft.com/en-us/topic/-the-import-of-solution-solution-name-failed-error-occurs-in-dynamics-365-011afe49-3aa1-db40-566b-e4f27d1e7375 for the Error code 80041A06http://go.microsoft.com/fwlink/?LinkID=398563&client=Solutions&Error=80041A06&de=online failure.

Information Details Name CenterofExcellenceCoreComponents Start time 3/2/2021, 11:32 AM End time 3/2/2021, 11:34 AM Version 1.89 Publisher powerplatformadmin Operation Import Suboperation None Result Failure More details Error code 80041A06http://go.microsoft.com/fwlink/?LinkID=398563&client=Solutions&Error=80041A06&de=online Exception message Attribute admin_rpamodifiedon is a String, but a DateTime type was specified. Total operation time 1 m 41 sec Patch No Managed Yes Overwrite customizations No Activity id 697badc8-0107-425b-a7dd-280a732b4623

Please let me know if you have any further questions.

Thanks

From: Jenefer Monroe notifications@github.com Sent: Monday, February 1, 2021 1:52 PM To: microsoft/powerapps-tools powerapps-tools@noreply.github.com Cc: Margo Lee Margo_Lee@mednax.com; Author author@noreply.github.com Subject: Re: [microsoft/powerapps-tools] BUG]: Issue connecting to the new COE via PowerBI- ERROR MESSAGE LOADING BLOCK FAILURE (#698)

To set expectations, this toolkit is not a supported product. It is a starter kit to get you going. So we are not support. We are here to help with issues that Power Platofrm customer see as budget allows. And as such we are not able to offer calls or remote sessions for our github users.

Can you please share here a screenshot showing the version of core you have installed? Please note that screenshots only work if you paste them in github, they will not show up if you paste in an email reply.

Here is what I am looking for: [image]https://urldefense.com/v3/__https:/user-images.githubusercontent.com/62659043/106504092-57b27400-647b-11eb-891d-cb7177fb6ff8.png__;!!AmoheuNn!GX92hNSnszDWkTkgCmsVh2aycNu6c6Qgi3nlCJHyIIFzX0KRWxmjJoM4Pa1VOC_B$

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://urldefense.com/v3/__https:/github.com/microsoft/powerapps-tools/issues/698*issuecomment-771077079__;Iw!!AmoheuNn!GX92hNSnszDWkTkgCmsVh2aycNu6c6Qgi3nlCJHyIIFzX0KRWxmjJoM4PZc4She8$, or unsubscribehttps://urldefense.com/v3/__https:/github.com/notifications/unsubscribe-auth/ASPLK3RZN57RCJ7B3OX4KKTS43Z45ANCNFSM4WEQV7WA__;!!AmoheuNn!GX92hNSnszDWkTkgCmsVh2aycNu6c6Qgi3nlCJHyIIFzX0KRWxmjJoM4PY3B5P_I$.

JeneferM-MSFT commented 3 years ago

Again, we are not support, this is not a supported toolkit, and we cannot do calls with Github customers.

In the future please share screenshots of issues, you need to be logged in to Github for them to work they will not work by replying in email.

But I can see from your text that what you are experiencing is a known old issue, so I can help you here.

You need to install the itermediate solution found here #491 and #515 depending on your current version of Core.

And then you can update to the latest version. Be sure to follow the instructions in installing updates when doing so.

margolee56 commented 3 years ago

Adding new IM+ @Aakanksha Sinha (Accenture Solutions Private Li)mailto:v-aakasi@microsoft.com for visibility.

From: Margo Lee Margo_Lee@mednax.com Sent: Tuesday, March 2, 2021 10:19 PM To: microsoft/powerapps-tools reply@reply.github.com; microsoft/powerapps-tools powerapps-tools@noreply.github.com Cc: Author author@noreply.github.com; Sai Abhishek Balla (MINDTREE LIMITED) v-saball@microsoft.com; Chaitanya R (Accenture Solutions Private Li) v-chr1@microsoft.com; Kiran Reddy kiranb@microsoft.com; Veera Venkata Satya Narayana Murty Peetha (MINDTREE LIMITED) v-vepeet@microsoft.com; Aakanksha Sinha (Accenture Solutions Private Li) v-aakasi@microsoft.com Subject: [EXTERNAL] RE: [microsoft/powerapps-tools] BUG]: Issue connecting to the new COE via PowerBI- ERROR MESSAGE LOADING BLOCK FAILURE (#698)

Hi Support,

Upon imported the most recent COE Toolkit the below error was received, the update toolkit was being imported at Power Appshttps://make.powerapps.com/environments/c5ed9853-e3fa-4692-a60e-f2574f7432d9/history URL

Note: the following steps was performed via the URL noted "The import of solution: [solution name] failed" error occurs in Dynamics 365 (microsoft.com)https://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Ftopic%2F-the-import-of-solution-solution-name-failed-error-occurs-in-dynamics-365-011afe49-3aa1-db40-566b-e4f27d1e7375&data=04%7C01%7Cv-chr1%40microsoft.com%7Cb55b66916af1427ad09d08d8dd9b0e5e%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C637503005807285717%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000&sdata=1gKNdJO%2BBnoDMcHWZKxgiTD0m%2B0t0KOk6w0AgHDvrZQ%3D&reserved=0 for the Error code 80041A06https://nam06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fgo.microsoft.com%2Ffwlink%2F%3FLinkID%3D398563%26client%3DSolutions%26Error%3D80041A06%26de%3Donline&data=04%7C01%7Cv-chr1%40microsoft.com%7Cb55b66916af1427ad09d08d8dd9b0e5e%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C637503005807285717%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000&sdata=oSvMHOUvNX9SooEqpXw5kET2oooG8vbe5UtTRiJuGRw%3D&reserved=0 failure.

Information Details Name CenterofExcellenceCoreComponents Start time 3/2/2021, 11:32 AM End time 3/2/2021, 11:34 AM Version 1.89 Publisher powerplatformadmin Operation Import Suboperation None Result Failure More details Error code 80041A06https://nam06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fgo.microsoft.com%2Ffwlink%2F%3FLinkID%3D398563%26client%3DSolutions%26Error%3D80041A06%26de%3Donline&data=04%7C01%7Cv-chr1%40microsoft.com%7Cb55b66916af1427ad09d08d8dd9b0e5e%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C637503005807295673%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000&sdata=wYCG3axGeVqyeKCCYk4HY1UcCY5u57KSNEnn0wYHNGY%3D&reserved=0 Exception message Attribute admin_rpamodifiedon is a String, but a DateTime type was specified. Total operation time 1 m 41 sec Patch No Managed Yes Overwrite customizations No Activity id 697badc8-0107-425b-a7dd-280a732b4623

Please let me know if you have any further questions.

Thanks

From: Jenefer Monroe notifications@github.com Sent: Monday, February 1, 2021 1:52 PM To: microsoft/powerapps-tools powerapps-tools@noreply.github.com Cc: Margo Lee Margo_Lee@mednax.com; Author author@noreply.github.com Subject: Re: [microsoft/powerapps-tools] BUG]: Issue connecting to the new COE via PowerBI- ERROR MESSAGE LOADING BLOCK FAILURE (#698)

To set expectations, this toolkit is not a supported product. It is a starter kit to get you going. So we are not support. We are here to help with issues that Power Platofrm customer see as budget allows. And as such we are not able to offer calls or remote sessions for our github users.

Can you please share here a screenshot showing the version of core you have installed? Please note that screenshots only work if you paste them in github, they will not show up if you paste in an email reply.

Here is what I am looking for: [Image removed by sender. image]https://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Furldefense.com%2Fv3%2F__https%3A%2Fuser-images.githubusercontent.com%2F62659043%2F106504092-57b27400-647b-11eb-891d-cb7177fb6ff8.png__%3B!!AmoheuNn!GX92hNSnszDWkTkgCmsVh2aycNu6c6Qgi3nlCJHyIIFzX0KRWxmjJoM4Pa1VOC_B%24&data=04%7C01%7Cv-chr1%40microsoft.com%7Cb55b66916af1427ad09d08d8dd9b0e5e%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C637503005807295673%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000&sdata=BIgdlUVubrwk8KOCWABXwRKjal3VYPrrCE1IoxVpdwQ%3D&reserved=0

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Furldefense.com%2Fv3%2F__https%3A%2Fgithub.com%2Fmicrosoft%2Fpowerapps-tools%2Fissues%2F698*issuecomment-771077079__%3BIw!!AmoheuNn!GX92hNSnszDWkTkgCmsVh2aycNu6c6Qgi3nlCJHyIIFzX0KRWxmjJoM4PZc4She8%24&data=04%7C01%7Cv-chr1%40microsoft.com%7Cb55b66916af1427ad09d08d8dd9b0e5e%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C637503005807305628%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000&sdata=22emsy5zz2ZQrwFhqTUbf%2FREP7IZjt%2Fg5kCtqK%2BHlBw%3D&reserved=0, or unsubscribehttps://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Furldefense.com%2Fv3%2F__https%3A%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FASPLK3RZN57RCJ7B3OX4KKTS43Z45ANCNFSM4WEQV7WA__%3B!!AmoheuNn!GX92hNSnszDWkTkgCmsVh2aycNu6c6Qgi3nlCJHyIIFzX0KRWxmjJoM4PY3B5P_I%24&data=04%7C01%7Cv-chr1%40microsoft.com%7Cb55b66916af1427ad09d08d8dd9b0e5e%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C637503005807305628%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000&sdata=rThyiXgcKMftJfvPCG3xqLsU9NupXVoqC0VT%2Bjp7Uow%3D&reserved=0.