Using SSRS Data Feed as a source for Power BI

[NeedInfo]

Hi all,

I try to import a SSRS report as a data source to Power BI Desktop via the Data Feed / OData functionality. So I open the report in SSRS, export it as a Data Feed, take the URL from the feed and try to use it as OData source in Power BI, but I receive errors. Can you please let me know how the URL should like? Also, what are the steps to be performed for importing a SSRS report OData feed in Power BI?

Cheers

[v-shex-msft · Accepted solution]

HI @NeedInfo,

Nope, power bi not support to import SSRS reports to power bi desktop as datasoruce. Import option only support excel workbooks:

Import Excel workbooks into Power BI Desktop

Current you can only consider to pin SSRS report to power bi dashboard.

How to migrate SSRS reports to Power BI and create new reports?

BTW, even if you succeed get data from SSRS, it only import data tables to power bi desktop instead import SSRS contents and reports.

Regards,

XIaoxin Sheng

[v-shex-msft · Accepted solution]

HI @NeedInfo,

Nope, power bi not support to import SSRS reports to power bi desktop as datasoruce. Import option only support excel workbooks:

Import Excel workbooks into Power BI Desktop

Current you can only consider to pin SSRS report to power bi dashboard.

How to migrate SSRS reports to Power BI and create new reports?

BTW, even if you succeed get data from SSRS, it only import data tables to power bi desktop instead import SSRS contents and reports.

Regards,

XIaoxin Sheng

[NeedInfo]

Thank you for your reply! That means that Power BI doesn't support ATOMSVC file? I succeded to connect with Excel, but it's strange that Power BI doesn't support this functionality. I receive the following error when typing the OData URL into Power BI:

Details: "OData: The feed's metadata document appears to be invalid."

[v-shex-msft · Accepted solution]

Hi @NeedInfo,

>>I receive the following error when typing the OData URL into Power BI: Details: "OData: The feed's metadata document appears to be invalid."
AFAIK,power bi desktop not support these files.

Regards,

Xiaoxin Sheng