Forum Discussion

josef78's avatar
josef78
Memorable Member
5 years ago

Hi,

if you created report in Power BI Desktop RS aka "optimized for Power BI Report Server" (not cloud only version), it is ok. It is only way how to create report for Report Server.

 

If you are connecting to Azure SQL Database, check if you have defined proper firewall rules. SQL server must be accessible from Power BI Report server, and Power BI Report Server can be probably in different network with different IP than your desktop.

Good way to check is install Power BI Desktop RS to same machine where you are running Power BI Report Server, and check connection PBI Desktop RS from this machine.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi josef78 Thank you soo much for your reply. How can I see the IP Address of the report server ? also maybe for reference I don't have admin rights at my company so should I maybe contact the It admin at my office ? thank you again for the help 

  • v-deddai1-msft's avatar
    v-deddai1-msft
    Community Support
    5 years ago

    Hi Anonymous ,

     

    The ip address of report server is the ip address of the server that holds the report server.

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    Best Regards,

    Dedmon Dai

  • josef78's avatar
    josef78
    Memorable Member
    5 years ago

    If you have simple single server deployment, IP address of report server is same as IP address report server portal (you can use nslookup with URL of your server). 

     

    But if you have more robust scale-out deploymet, you must ask to some administrator (because there can be some load balancer, or multiple report servers which not all them have role for refresh data)