Share via

PBI Gateway Request using SSRS

Yaramsetty, Nagendra [contractor] 0 Reputation points
2023-09-28T18:43:17.9833333+00:00

Hi Team,

 

We have a data source for a Power BI dataset this is a separate SSRS report. We are unable to get access to the full database used by the SSRS report, so we need to import the SSRS file as a data source.

 

I have setup a ‘Web’ connection in Power BI desktop that will connect to the SSRS web server and download the data as a CSV file. The URLs are static and would not change. The details are:

 

Can a gateway be setup for the SSRS file as a data source?

Thanks in advance!

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,926 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. AniyaTang-MSFT 12,446 Reputation points Microsoft Vendor
    2023-09-29T01:59:50.9566667+00:00

    Hi @Yaramsetty, Nagendra [contractor]

    I don't know much about Power BI. You can refer to this document: https://learn.microsoft.com/en-us/power-query/connectors/text-csv.

    For more detailed information, I recommend you go to the Power BI forum for help: https://community.fabric.microsoft.com/t5/Forums/ct-p/PBI_Comm_Forums.

    If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know.

    Best regards,

    Aniya

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.