cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Deepan Frequent Visitor
Frequent Visitor

SQL Server Reporting Services 2017 Jan Preview - not identified in Power BI

I created a Power BI report and tried to save as SQL Server Reporting Services. But when I enter the report server address in that field it says "This URL is not a valid report server address". But I can see the URL in the Reporting Services Configuration Manager and when I type the URL in the browser I am able to see the portal. The URL looks like this:

http://desktop-myservername/Reports/

1. What am I doing wrong?

If I understand the concept of Power BI reports in SQL Server Reporting Services, It can be used on-premises right?

2. So, can I publish the Power BI report to my SQL Server Reporting Services and include the report in an iframe in my ASP.NET MVC application that I have hosted in my IIS server?. Basically can I do all of this without having an online Power BI subscription? If yes, how? I can't find any documentation on this. If no why? What's the purpose of "BI reports in SQL Server Reporting Services".

3. Is there any other way to display Power BI reports (on-premises SQL Server datasource) in my ASP.NET Application hosted on my IIS Server without publishing to the internet?

My Reporting Server Version When I go to : http://myserver/ReportServer

Microsoft SQL Server Reporting Services Version 13.0.4001.0

3 REPLIES 3
Microsoft v-haibl-msft
Microsoft

Re: SQL Server Reporting Services 2017 Jan Preview - not identified in Power BI

rbeainy Occasional Visitor
Occasional Visitor

Re: SQL Server Reporting Services 2017 Jan Preview - not identified in Power BI

Gentlemen,

 

I have the same issue; and i installed January Preview, but the problem persists.

 

Any input please?

Thanks,

Highlighted
apate277 Frequent Visitor
Frequent Visitor

Re: SQL Server Reporting Services 2017 Jan Preview - not identified in Power BI

2 issues. 

 

1. The pbix file fails to "Save As SQL server reporting service ". Indicates that URL is not a valid report server address. However the same URL works well in browser.

 

2. PBIX file uploaded within SSRS browser doesnt preview at all. Upon clicking it just downloads. Is it still under beta testing. I asked this because I wanted to use this for my project.

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)