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

Local SSRS can't be found on Windows Power BI App

I've done everything here:

https://docs.microsoft.com/en-us/sql/reporting-services/report-server/enable-a-report-server-for-pow...

 

and looked for all related topics. However, I have SSRS 2016 (and 2017) hosted locally on my Surface Pro 4 and am trying to connect via Power BI windows 10 app on same Surface Pro and just continue to get the:

Server Address isn't valid Verify the address is a SQL Server 2016 Reporting Services address and try again

error

 

I can connect via browser, I've looked for items in SSRS error log, windows error logs. I can't find anything. I have no idea why it can't find the local report server.

 

 

4 REPLIES 4
Highlighted
Microsoft
Microsoft

Re: Local SSRS can't be found on Windows Power BI App

Hi @HoosierSqlDev,

 

Make sure the address you input for the mobile app should be something like:

http://<servername>/reports or https://<servername>/reports 

 

Instead of inputting server name to connect to report server, using the IP address for a test. Also, please make sure your mobile device was connected to the same network with the Power BI report server.

 

Did you install an other SSRS instance on your machine? If so, please try:

1. Change the Database name like ReportServerPowerBI in order to distinguish the database for SSRS instance. 

2. Check in your Report Server Configuration Manager->Web service URL and Web Portal URL change the port name to other one for a test. 

 

Regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Frequent Visitor

Re: Local SSRS can't be found on Windows Power BI App

This is all running locally on a Surface Pro 4 (the SSRS instance(s) and the Power BI App).

 

Yes, I've tried with the IP Address (which does work through the browser). I've switched ports and have different db names.

 

Always the same error message as originally given above.

Highlighted
Regular Visitor

Re: Local SSRS can't be found on Windows Power BI App

I am facing the same problem. It is working fine if it accessed using browser and android power bi mobile apps.

I've tried to use username@domain format just like in mobile apps, but like domain\username format, still it is not working.

 

Is there any solution for this problem? Thank you.

 

Regards,

Iqbal

Highlighted
New Member

Re: Local SSRS can't be found on Windows Power BI App

I got this to work by making an exception for Power BI App to connect locally using Fiddler.   This guide is older and Win8 based, but the setup was pretty easy once Fiddler was installed.   I only did the "create loopback exemption" step, not the additonal part related to certificates.   After I did this, the PBI App connected fine.

 

http://docs.telerik.com/fiddler/configure-fiddler/tasks/configurefiddlerforwin8

 

I'm guessing Power BI app is not intended to connect this way and this is not a supported setup, but it may be useful for some testing purposes. 

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors