web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Business Central forum Connect Business Centr...

Business Central forum

Connect Business Central in SSRS.

(0) Share

Report

Report

Posted on by Community Member

Hi,

I am trying to connect Business Central in SSRS but getting a error while creating the dataset.

The first step I followed is to create a Data Source as password as configuration key and username. But I am confused about connection string:

3173.3.png

The next step I added a dataset as below with Query as

<Query>
<ElementPath IgnoreNamespaces="true">
feed{}/entry{}/content{}/properties
</ElementPath>
</Query>

3173.2.png

But getting below error while trying to refresh the fields:

6786.1.png

Can anyone let me know the exact steps to connect connect Business Central in SSRS? And how to pass Connection string to connect business central in SSRS in data source?

Categories:

Reports and Business Intelligence

Business Central

All responses Img

All responses (1)

Answers Img

Answers (0)

mcrooks 10 on at

Like (0)

Report
Copy link

Link copied!

Hello, I am trying to do the same thing but I found that you cannot use the XML connection without using Windows Authentication. Did you get a resolution on this issue?

Join the conversation

Helpful resources

Quick Links

Leaderboard > Business Central

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans