Power BI: Setting up Report Server for Multiple Users over LAN and Internet, using Local & Public IP

In this tutorial, we'll guide you through the installation, setup, and configuration of Power BI Report Server for multiple users. Learn how to create a local users group, add users, and grant them access to the report server over the Local Area Network and through a public IP address.
Follow step-by-step instructions on downloading, installing, and configuring Power BI Report Server. Discover how to create a database for your report server using SQL Server, set up the web portal, and upload a sample dashboard. Ensure compatibility with Power BI Desktop and understand the importance of using the recommended version.
Additionally, gain insights into creating users and groups, managing their access rights, and making your report server accessible globally through port forwarding. This comprehensive tutorial covers everything from installation to remote access, providing a thorough understanding of Power BI Report Server functionality.
🔗 Watch the tutorial shown in the picture for a visual guide: [Link to Video Tutorial]
🚨 Note: This description assumes familiarity with basic concepts discussed earlier in the tutorial. For detailed steps and insights, watch the accompanying video tutorial.
🌐 For more tutorials and updates, like, subscribe, and hit the bell icon. We appreciate your support!
#PowerBI
#ReportServer
#DataVisualization
#BIReporting
#Tutorial
#TechHowTo
#DataAnalytics
#SQLServer
#BusinessIntelligence
#DashboardDesign

[@hesammohammadi6969]

Thank you for excellent training👌

[@virtual_school]

Always welcome

[@richardtorrenueva5512]

Thank you for excellent hand ons training

[@virtual_school]

Our pleasure!

[@ArminAghajani-vc8hm]

Hello. Is it possible to set the security settings so that the user will not be asked for username and password before viewing the report? It means that users can access the report page immediately after entering the url. Please guide me.

[@virtual_school]

These are all work arounds. To get proper power bi features, you need power bi service from Microsoft, which also gives you the facility to share your reports to general public without user name and password.

[@richardtorrenueva5512]

In domain environment where to configure the user?

[@virtual_school]

Active Directory

[@MoonShine-bs6cl]

Hi Nice explanation, please could you help me how do i calculate the delayed by 2 or more months and 6 or more mnths in dax, where I have the delivery date and delivery requested date. Does this work if ( delivery date) >delivery requested date, 'delay', 'ontime') please it would be helpful if you show me with an example. Thank you so much....

[@virtual_school]

Sure. Please share a sample table containing what is available and what you required. For example if you have 2x2 and 2x3 and you want 4 and 6 as answer.

[@MoonShine-bs6cl]

@@virtual_school Ok if u can help me with email id i can share. Pls can you provide

[@MoonShine-bs6cl]

@@virtual_school I have Division, category, conclusion, year, original expected report month, revised expected report month, audit progress, risk rating columns in my table and i should find out expected reports delays of 2 months or more and 6 months or more from this data, hope this will help you. Thanks in advance 🤝

[@virtual_school]

Send some data (data can be fake and few rows only) at [e-mail]. I will be pleased to help you.

[@virtual_school]

To find out delay in months, just use DATEDIFF function like Delay = DATEDIFF(start_date, end_date, month) Thanks

[@GeekUpdates]

Getting error while opening report url you dont have permission

[@virtual_school]

Creating, managing and granting rights to users can be tricky. You must create users, then grant them rights in PBIRS. Follow all step after 8:15 please. Since there are so many things that can go wrong, I cannot guess where you are having problem.

[@virtual_school]

You must watch this video as well, many things are discussed here, which are not repeated. kzbin.info/www/bejne/laPXZpeoeaujoq8 For this setup, you must have windows professional or higher (or a windows with local users and groups manager 'lusrmgr.msc') and a router that allows port forwarding (if you intend to access the server from public ip)