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

[@hesammohammadi6969]

Thank you for excellent training👌

[@virtual_school]

Always welcome

[@richardtorrenueva5512]

Thank you for excellent hand ons training

[@virtual_school]

Our pleasure!

[@richardtorrenueva5512]

In domain environment where to configure the user?

[@virtual_school]

Active Directory

[@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.

[@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)

[@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.