Power BI Part 2.1 - Install and Configure Power BI Report Server

[@emaseyoum9099]

Andrew is a teacher who knows how to deliver the subject very well.Thank you

[@WiseOwlTutorials]

Thank you, Ema!

[@amandawang6592]

After spending 2 days on Google and KZbin, your video is the only one that helps me. Thank you!

[@WiseOwlTutorials]

Happy to hear that it helped you Amanda, thanks for taking the time to leave a comment!

[@digitalreview4256]

I thank you so muchhhhh. This 26 min video is equal to search, read and watch other tutorials for 26 hours.. super great.

[@WiseOwlTutorials]

Happy to hear that it helped, thank you for taking the time to leave a comment, it's much appreciated!

[@TitansLacrosse34]

Very helpful - thank you! Had trouble initially setting up the report server DB, but that's because I did not add the /SQLEXPRESS to it. Thanks Andrew!

[@WiseOwlTutorials]

You're very welcome Iqbal! Happy to hear that you got it working!

[@kv73477]

Amazing video! When I started to learn SSRS reporting. I came across wiseowl tutorials and since den... Really like all videos by Andrew! Amazing work❤.. Keep going 👍

[@WiseOwlTutorials]

Thank you for the kind comments and for watching!

[@vchandm23]

Some handy DAX tutorials in power BI would be really helpful like how you guys did in SSRS course. Once again thanks for this awesome tutorial.

[@WiseOwlTutorials]

Agreed! It's on the list!

[@vchandm23]

@@WiseOwlTutorials - Thanks once again, been following your channel since 2014

[@WiseOwlTutorials]

Thanks, I appreciate the continued support!

[@cesarchicaiza4831]

@WiseOwlTutorials, you are the best...love your videos!!!

[@TechySanataniEngineer]

I was really looking for this series to come up. and thanx alot for posting POWER bI viedos

[@WiseOwlTutorials]

You're very welcome Shubham, thank you for commenting and for watching!

[@tejamarneni]

Awesome video as always. Oh! did I mention that first comment for 3rd time yay!!!

[@WiseOwlTutorials]

Thanks Ravi! Let's see if you can keep that streak going!

[@wissembellara6411]

Nice video it helped me a lot very simple and explanatory well done

[@WiseOwlTutorials]

Happy to hear that Wissem, thanks for watching!

[@wissembellara6411]

@@WiseOwlTutorials I do have a little problem however, after configuring everything and putting everything on report server, my colleague was unable to find that server so how can you share it on a local network ?

[@WiseOwlTutorials]

@@wissembellara6411 Hi Wissem, you'll need to configure permissions to allow others to access the report server. You can find detailed information on how to do this using the following links docs.microsoft.com/en-us/sql/reporting-services/report-server/configure-and-administer-a-report-server-ssrs-native-mode?view=sql-server-ver15 docs.microsoft.com/en-us/sql/reporting-services/security/roles-and-permissions-reporting-services?view=sql-server-ver15 I hope it helps!

[@thaboseboka2654]

great vid very informative but just a quick question after you have create the Power BI report in Power BI Desktop and then manually upload the PBIX to the Power BI Report Server portal and assign roles how do you share with consumer?? or you just send them the url? i'm new to powerbi report server

[@BASEMFAWZY1]

Just Brilliant ! Bravo !

[@WiseOwlTutorials]

Thanks!

[@Kodomonster]

Thank you for this, very very helpful!

[@PaoloDallaVia]

Good and complete video. It could be useful to have a more deailed video about SSL configuration

[@efficiencydna897]

thanks! is there any methods that can help me view the report publish by computer A fromt computer B in the same local network？many thanks!

[@DanielWeikert]

Thank you. Could you tell more about SSL Certificates?

[@WiseOwlTutorials]

Hi Daniel, I'm afraid that I don't know much about that topic but I'll add it my list of things to find out. If you're in need of information quickly I guess the official Microsoft documentation would be a good place to start docs.microsoft.com/en-us/sql/reporting-services/security/configure-ssl-connections-on-a-native-mode-report-server?view=sql-server-2017 I hope that helps for now!

[@NadsRocker]

Great content, thanks for sharing. Keep it up!

[@WiseOwlTutorials]

Thank you, Nadissen!

[@Tipejote]

Thanks for the tutorial. What I'm not sure of is: would someone be able to open see the reports if we share that URL or is the SQL in our local machine?

[@WiseOwlTutorials]

Hi Alberto! By default, only local admins on the Report Server computer have access. To allow others to see the reports you must grant access to other users. This Microsoft help page describes how the process works docs.microsoft.com/en-us/sql/reporting-services/security/grant-user-access-to-a-report-server?view=sql-server-ver15 I hope it helps!

[@Tipejote]

@@WiseOwlTutorials Thanks for the quick reply but, and please forgive my ignorance on this topic, do they need access to the SQL server? In my case I linked the power bi report server to my local SQL server (the default one when you install Microsoft SQL Server Management).

[@Tipejote]

@@WiseOwlTutorials and in fact I'm going to be more specific. After creating the report server I am able to access it from a different PC that has the same WiFi connection that the host. However, my co-workers are unable to access, despite all being connected to our company intranet through a VPN. Am I missing something obvious on how this works? Again thanks for your time, it would be extremely helpful if you could shed some light.

[@WiseOwlTutorials]

@@Tipejote Hi Alberto, I'm no expert on server administration. Have you added your co-workers as users to the report server as described in the Microsoft documentation that I linked to in the previous answer?

[@Tipejote]

@@WiseOwlTutorials I did, although I do not think it's a matter of users since I cannot access myself when I am not connected to the same WiFi. Anyways I wouldn't want to take any more of your time, I asked in case I was misunderstanding something conceptually regarding the report server. Very kind of you to answer and many thanks for your help :)

[@ibra09swede]

The support for internet explorer has stopped, any advice on how to get by the "Could not load folder contents" error?

[@WiseOwlTutorials]

Hi Andreas, sorry I don't have any advice for that problem.

[@admiringamjad]

Hey Andrew, Informative Video,👍👍, quick question did you install PowerBi Report Server on working SSRS environment, I mean should we use both the reporting server on Single SQL server? If yes then should we view existing SSRS reports on PowerBi Report Server?

[@tameraziz2104]

Andrew - Thank you for the Video.

[@buih2]

Thank you so much the tutorials videos. They are really helpful and informative! Can you please make some videos on more advanced graphs, formatting and properties of Power BI (Drill-through, hierarchy, tooltips with graph,...). Thank you!

[@hadireg]

👍👍👍🍻

[@WiseOwlTutorials]

👍

[@mohamedfasil4891]

Can we view full screen of report in report server ?

[@WiseOwlTutorials]

Hi Mohamed! There isn't a native full screen report view in the SSRS web portal. You can press F11 in Chrome or Edge to hide the browser title bar and menu but you'll still see the web portal toolbar, etc.

[@mohamedfasil4891]

@@WiseOwlTutorials Thanks for your reply brother and I have searched in Google regarding this full screen display in Power BI Report Server. Someone shared this trick for full screen in Google ,In Report Server URL if we add ?rs:embed=true to the end of the URL. It is showing full screen of the report. How is it working and Is it good to use ?

[@WiseOwlTutorials]

@@mohamedfasil4891 Hi Mohamed! There are many parameters you can add to your report URL learn.microsoft.com/en-us/sql/reporting-services/url-access-parameter-reference?view=sql-server-ver16 I didn't know about the embed parameter, thanks for sharing!

[@mohamedfasil4891]

@@WiseOwlTutorials Thanks Brother ! I have one more question. Can we integrate the Power BI Report Server with Microsoft Teams ?

[@WiseOwlTutorials]

@@mohamedfasil4891 Hi Mohamed, sorry I don't know the answer to that!

[@baoshenyi]

Thank you so much to post Power BI tutorial, it is very good. When I use "Save as" in Power BI Desktop, I could not see "Power BI Report Server" But I could find both service are running. SQL Server Reporting Services (MSSQLSERVER) (under NT Service\ReportServer account) Power BI Report Server (under NT SERVICE\PowerBIReportServer account) Any ideas? Any config on SQL Server side? Thanks again!

[@ibrahemmohamed2244]

Many thanks

[@ptqi.it.instructor1949]

Test connection error:40 , configure report server

[@suhailmsq]

Thanks for your Tutorial.. After Installation Power BI Report Server , getting message " Could not load Folder Content - You are not allowed to view this folder. Contact your administrator to obtain the necessary permissions. " even open in IE "Run as Administrator". please help me to solve this issue. Thanks

[@WiseOwlTutorials]

Hi Suhail, I'm sorry but I don't know how to solve that other than the option you have already tried.

[@kashifkhanspecial]

Hi Andrew, This is a fantastic tutorial thank you so much for that, I have one request to you, can you make tutorials about VSTO (Visual Studio Tools for Office), how can we programme excel from VSTO. Thanks Kashif

[@WiseOwlTutorials]

Hi Kashif, thanks for your comment! A VSTO tutorial would be pretty cool but it would also take a huge amount of time for a product that we don't currently offer training courses in so I'm afraid that it's fairly unlikely to happen. Thank you for the suggestion though, it's good to hear from people which tools they're using.

[@kashifkhanspecial]

WiseOwlTutorials Hi Andrew thank you so much for reply, yes I know that anyway thank you so much for other great tutorials you are currently running in this channel, I hope in future we will be seeing this tutorial as well. Thanks Kashif

[@WiseOwlTutorials]

Thanks Kashif, I appreciate the comments!