Forum Discussion
SSRS with power bi
Which version are you on? PBIRS and SQL Server?
Install the Power BI Desktop for Report Server in the correct version: https://www.microsoft.com/en-us/download/details.aspx?id=55329
You may have already downloaded this when you downloaded the Report Server installation!
If you intend to use it for Dashboard, you need to install the latest version of the PBI Desktop (for Report Server, not PBIS, they are different)
If this is PBIRS, then you should use Report builder for Power BI (Download Microsoft® Power BI Report Builder from Official Microsoft Download Center)
With that said, this could be one of the security setups, where Server Admin has not authorized users to connect to the dataset out of server (via local computer). to circumvent that, you should have your reports built with SQL connectors and publish the connectors.
The screenshot with the error message is "user friendly". If you have access to the server, take a look at event logs, and RS Server logs to take a look at the actual error message. if the log file is limited, update the rsreportserver.config for verbose logging, then regenerate the error, and look at the log files again.
The only time i saw this message was when our report server db was moved, and we forgot to reconfigure the server to the right database. so updating the rsconfig (then service restart) helped get rid of the error.
atuljha hi inshort will you please specify what i should do ? i am am facing this error while using
SQL Server Mobile Report Publisher
Microsft Report builder
- ChrisMuthmann
Resolver II
Which version are you on? PBIRS and SQL Server?
Install the Power BI Desktop for Report Server in the correct version: https://www.microsoft.com/en-us/download/details.aspx?id=55329
You may have already downloaded this when you downloaded the Report Server installation!