API Pages in PowerBI

[nathannn-b]

I have created a new API page and deployed the app in our production environment, but I cannot find the API page anywhere to be selected for use in PowerBI. I previously done the same thing in our Sandbox environment and this shows as expected under the hougaard API folder, but not for the production environment. I am wondering if I am missing any steps or need to do anything after creating the new API page and publishing the extension?

[hougaard]

No, nothing should be different, are you sure it's deployed to production? (check extension management and verify that your app is installed).

[nathannn-b]

Thanks for the quick reply! It is definitely deployed - checked extension management and also the deployment status via SOD.

[nathannn-b]

[nathannn-b]

Here's what I see for our Sandbox Vs Production in PowerBI

[hougaard]

I wonder if this could be a permissions issue?

How did you deploy to prod, from Simple Object Designer, or did you upload the .app file you got from your sandbox?

[nathannn-b]

I deployed directly from simple object designer in both environments. The methods I took to create the pages didn’t change across the environments and I am a super user in both environments also.

I have successfully used the sandbox apis in power automate flows also but I can’t find the api pages in power automate for the production environment either.

Sent from my iPhone

---

From: Erik Hougaard @.> Sent: Tuesday, November 15, 2022 11:57:58 PM To: hougaard/Simple-Object-Designer @.> Cc: Nathan Bennett @.>; Author @.> Subject: Re: [hougaard/Simple-Object-Designer] API Pages in PowerBI (Issue #117)

[EXTERNAL]

I wonder if this could be a permissions issue?

How did you deploy to prod, from Simple Object Designer, or did you upload the .app file you got from your sandbox?

— Reply to this email directly, view it on GitHubhttps://github.com/hougaard/Simple-Object-Designer/issues/117#issuecomment-1316050748, or unsubscribehttps://github.com/notifications/unsubscribe-auth/A4GWKA2G7UEQN7FOK5JCSFLWIQPQNANCNFSM6AAAAAASBQB52E. You are receiving this because you authored the thread.Message ID: @.***>

[hougaard]

Weird, perhaps hit publish in SOD again in production .. This is not something I have ever heard from others before.

[nathannn-b]

I think I have found something that could be causing the issue. When I download the source code from the production environment, the launch.json file shows the environment type as sandbox:

        "name": "Microsoft cloud sandbox",
        "request": "launch",
        "type": "al",
        "environmentType": "Sandbox",

When I try to download symbols in vscode, I get the following error:

[2022-11-16 10:53:22.46] Targeting Dynamics 365 Business Central environment tenant ID 'xxxxxxxx' and primary Azure AD tenant domain name ''. [2022-11-16 10:53:22.47] Sending request to https://api.businesscentral.dynamics.com............ [2022-11-16 10:53:43.81] Error: An error occured while processing the request. Request ID: xxxxxxxxxxxxxx Session ID: xxxxxxxxxxxxxx

If you are targeting a cloud instance, supply these IDs if contacting Microsoft support. [2022-11-16 10:53:43.82] The request for path /v2.0......... failed with code GatewayTimeout. Reason: Gateway Timeout [2022-11-16 10:53:43.83] Sending request to https://api.businesscentral.dynamics.com/v2.0......... [2022-11-16 10:54:26.23] Error: An error occured while processing the request. Request ID: xxxxxxxxxxxxxxxxxx Session ID: xxxxxxxxxxxxxxxxxx

Have you ever seen this or do you have any idea why the source code is showing a sandbox environment instead of production?

[hougaard]

That doesn't matter, from VS Code you can ONLY deploy to sandboxes.

[nathannn-b]

ok, so where do you propose I go from here? I have a project that I was counting on this extension to make happen, that was successful in Sandbox, but hasn't worked in production? How else can we troubleshoot this? Do you have any other suggestions for what I can check?

[hougaard]

Please try to uninstall the app from Extension Management and re-publish it from the Object Designer. This works for 100s of other users, so it should for you too..

[hougaard]

.. otherwise, we need to do a quick screenshare session...

[hougaard]

Did you find a solution?

[nathannn-b]

Hi - I completely uninstalled the SOD app, reinstalled it, created a new extension with a new API page, published it, and it worked. I then went and added more new API pages, republished my extension, and everything disappeared. I'm now back to square one with it

[hougaard]

Can we do a screenshare session later today?