topic Re: Populating dataset with SSRS Report Query in Report Server

Populating dataset with SSRS Report Query

Sime — Thu, 23 Sep 2021 06:38:53 GMT

Hi All,

Is it possible to use an SSRS report query to populate a dataset in Power BI?

Currently I'm using a ODBC connection to the data source but it has some limitations.

The main one being the inability to use the EXECUTE command to create temporary tables for the purposes of currency conversions etc.

It would be great if I could simply drop the report query in and retrieve the desired output as one does with an ODBC connection.

I should add that I do not have a direct connection to the SQL or Report servers as the system I am connection to is hosted by a 3rd party.

Appreciate any feedback or suggestions.

Thank you.

Re: Populating dataset with SSRS Report Query

AbhiSSRS — Thu, 23 Sep 2021 13:33:40 GMT

You may use your exec sp for Power BI too to import/direct query data but Its not possible to create Tables on that. On scenario may be to have persisted tables created via these which you can access from Power BI

Re: Populating dataset with SSRS Report Query

Sime — Wed, 29 Sep 2021 07:48:29 GMT

Thank you for your response Abhi. I will give this a try.