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

Dataverse/Powerapps unable to access "Available Business Central table"

I'm trying to create some Business Central virtual tables in my Dataverse production environment and not having much luck. Hopefully one of you has encountered this and corrected whatever the source of the problem was.

 

I've followed the steps in this document: https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/powerplatform/powerplat-admi... to the end of the Authentication and authorization section. On step 3 of that section ("Locate and edit the table that you want to enable"), Powerapps studio emits an error.

 

Steps to repeat: 

  • Navigate: Powerapps>Data>Tables>Available Business Central table
  • Then, select Data.

When I do, I receive this message

An error has occurred.

Something went wrong. Please try again.

The URL https://api.businesscentral.dynamics.com/v2.0/xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx/Production for Business Central is incorrect or not accessible.

(Where xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx is my tenant ID)

 

When I use Advanced find to locate and show the table, I receive this error:

An error has occurred.

Try this action again. If the problem continues, check the Microsoft Dynamics 365 Community for solutions or contact your organization's Microsoft Dynamics 365 Administrator. Finally, you can contact Microsoft Support.

Timestamp: 5/11/2021 6:41:01 PM UTC
Service Request Id: 2016c456-a2ed-41fc-8e7e-d15992826d52
Technical Details
Tenant Id: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Url: https://yyyyyyyyyyy.dynamics.com
Organization Id: ooooooooooooooooooooooooooooo
Type: Secondary
Unique name: uuuuuuuuuuuuuuuuuuuuuu
Created on: 3/8/2021 2:54:37 AM
State: Enabled
Security Group: 00000000-0000-0000-0000-000000000000

 

My Business Central Virtual Data Source Configuration looks like so:

Business Central Virtual Data Source Configuration.png

0 REPLIES 0

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Users online (1,436)