web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Pages / Business central Datav...
Power Pages
Unanswered

Business central Dataverse connector returning error 500

(0) ShareShare
ReportReport
Posted on by 4

Hey there,

 

I'm currently working on a portal for clients to see, approve and download their invoices. 

Since we work in business Central, I ended up using the Dataverse connector. 

But I'm stuck on an error 500, I will outline the steps I took to get to this point to maybe give a better explanation.

 

Note: this was all tested on a trial e3 account.

 

Step 1

Set up the dataverse connector inside business central using "Dataverse connection "setup".

WesselOud_0-1691045478574.png

 

Step 2

make the needed tables available, by setting visible to "yes".

WesselOud_1-1691045587231.png

 

Step 3

Make a new website in power pages and check if the tables are available and have data.

WesselOud_2-1691045759449.png

 

Step 4

Add the table into a page view.

WesselOud_3-1691045853610.png

 

Step 5

Apply the permissions.

WesselOud_4-1691046038458.png

 

Step 6 - The problem

Now when i try to show this in the live preview i get this error, and when i open the developer options it says "error 500" which after looking up means "any error we have no clue about" (i think).

WesselOud_5-1691046171532.pngWesselOud_6-1691046215636.png

 

 

I'm at a bit of a loss and any help is greatly appreciated, if there's something i did not explain properly i will try my best to explain better.

Thank you so much in advance!

 

 

 

 

 

 

Categories:
I have the same question (0)
  • Gabriel Dias Junckes Profile Picture
    69 on at

    You can try to enable the diagnostic logs to get more details about it. I also suggest restarting the portal once the configuration is done. 

     

    View error logs | Microsoft Learn

  • WesselOud- Profile Picture
    4 on at

    Thank you so much for the reply Gabriel, 

     

    After following your suggestion and checking the logs i'm pretty sure this is the error generated when i try to load the website.

     

    RequestData:, RequestPath:, RequestExtension:, SessionId:, UserId:, CorrelationId:44f00d46-d47e-4973-9a60-ec76dec3710d, Elapsed:0, MemberName:ToCookieOptions, SourceFilePath:C:\__w\1\s\Framework\Adxstudio.Xrm\AspNet\Cms\StartupSettingsManager.cs, SourceLineNumber:574, Category:Application, Message:Invalid path string site setting value for the site setting:Authentication/ApplicationCookie/LoginPath, ErrorCategory:ApplicationError

     

     

    The part that stood out to me is 

     

    Message:Invalid path string site setting value for the site setting:Authentication/ApplicationCookie/LoginPath

     

     

    But unfortunately, it still didn't end up making a lot of sense for me. Do u have any idea what this means?

     

    Thank you in advance!

  • Gabriel Dias Junckes Profile Picture
    69 on at

    What do you have configured for this setting? See the documentation from Microsoft. Try the Default option.

     

    Local authentication, registration, and other settings | Microsoft Learn

     

    gabrieljunckes_0-1691485720146.png

     

  • WesselOud- Profile Picture
    4 on at

    Would u mind telling me where I can find these settings? , the article doesn't seem to make this clear for me. thank you so much 

  • Gabriel Dias Junckes Profile Picture
    69 on at

    This a Site Setting. You can try to find it in the table before creating a new record. The name will be the key.

     

    Configure site settings for Power Pages sites. | Microsoft Learn

     

     

    gabrieljunckes_0-1691485720146.png

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Pages

#1
11manish Profile Picture

11manish 56

#2
Valantis Profile Picture

Valantis 46

#3
rezarizvii Profile Picture

rezarizvii 25

Last 30 days Overall leaderboard