topic Re: how can you see the underlying query in an on prem ssrs dataset in Report Server

how can you see the underlying query in an on prem ssrs dataset

db042190 — Tue, 07 May 2024 10:11:01 GMT

hi i'm looking at a dataset on our ssrs server. i dont see any friendly way to look at the underlying query. i have sa. how would someone look at the query and any other properties that arent visible?

Re: how can you see the underlying query in an on prem ssrs dataset

Anonymous — Wed, 08 May 2024 01:46:29 GMT

Hi db042190 ,

You can see it in power bi report builder:

In the Report Data pane, expand the Datasets folder, and then double-click on the dataset you wish to examine. This action opens the Dataset Properties dialog box.

In the Dataset Properties dialog box, you can see the query in the Query box.

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: how can you see the underlying query in an on prem ssrs dataset

db042190 — Thu, 09 May 2024 11:46:59 GMT

thx xianda, i'm asking about a shared dataset. they seem to accompany paginated reports

Re: how can you see the underlying query in an on prem ssrs dataset

aduguid — Tue, 14 May 2024 05:45:04 GMT

You could download the shared dataset as a .rsd file and open it in either Visual Studio or just open it in a notepad.