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:


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

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

But getting below error while trying to refresh the fields:


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?