Create Power BI reports in Power BI Report Server

[@vincenzomascia4422]

Thanks for the video :). Just one question. Does The Cube Parameter is required in connection string? What happen if this parameter is not present?

[@winceeflores-sabuga8437]

Hi Adam, our company have SQL Server Enterprise Edition with SA, I was assuming we didnt have to get Pro/Premium licenses to publish and to view if we have this kind of server. Is this true?

[@davidbotzenhart2241]

Do you need PowerBI Pro license to File Save As to the PowerBI Report Server if I have an Enterprise Agreement?

[@dair919]

do you know whether MS plan to release a developer edition of Power BI Report Server?

[@GuyInACube]

Stay tuned for that info. It is coming very soon.

[@my2009videos]

Can I embed my reports from on premise report server into my web application and make it available for internal and external users?

[@sjelark]

Can you please add videos that explain new features in new releases of PBI Report Server? You're doing that for the cloud service, but not Report Server. Thanks. Love your videos.

[@GuyInACube]

Thanks for the feedback! We can try to tackle that. Most of the "new features" have really just been taking on the latest desktop features. We will keep an eye on it though and look to do a video discussing it.

[@shmuelkatorza8074]

Can I drill down to more data using the Power Bi tools?

[@manriquemontealegre3054]

Hi! Do you know when the next PowerBI Report Server release is scheduled? Will it include more data source connections? Is the team targeting to include all the data source connections included in the regular PowerBI Desktop? Thanks!

[@michaelbadal4721]

Are there any plans to get other data sources added other that SSAS for the new Power BI On Premise solution?

[@GuyInACube]

Absolutely! Riccardo mentioned it would come after GA later this year. blogs.msdn.microsoft.com/sqlrsteamblog/2017/06/12/power-bi-report-server-now-generally-available/

[@mshparber]

Thanks!What is the ETA for other Data Sources?

[@GuyInACube]

All I can tell you is what is in this blog post - blogs.msdn.microsoft.com/sqlrsteamblog/2017/05/17/a-closer-look-at-power-bi-report-server/. We haven't announced any further details on that. It indicates later this calendar year.

[@peterpan3900]

Where did you get the t Shirt ?

[@PhilCLP]

Will we be able to use the row level security similarly to the Power BI Service concept?

[@GuyInACube]

For the SSAS data source yes! This is because it is defined on the SSAS end in the model. And the end users credentials will be passed if you are using windows auth, or hard code the server admin and check the box to impersonate the user. This will use EffectiveUserName.

[@naheliegend5222]

Question: Why can I not upload a report, done with the June 2020 Version of PBI Desktop to the PBI Report Server (Version May 2020) ?

[@ajmorgan591]

Hi Adam. Love your videos - incredibly helpful! Unrelated question: where did the audio sample at 0:11 come from?

[@GuyInACube]

That was a built in audio file that came with Camtasia Studio 8. I don't know if it is still there with Camtasia Studio 9. I recently stopped using it though.

[@ajmorgan591]

Nice one, thank you sir!

[@Golden-Horse]

Hi, how did you get the images in slicer..?

[@GuyInACube]

You can get that by having a URL field in your data. Then use Data categorization to set it to an Image URL. The visuals will render the image :)

[@kennelson5860]

Hi - One of the selling points mentioned is being able to make from PBI pixel perfect pdf reports that are paginated. Do you have a video showing how to do that when data extends beyond what you see in a dashboard? Thanks!

[@desa885]

If i got 2 distinct clients and they can see his Power BI updated report in web. Wich Power Bi license is best for that? thanks

[@phrezilbeipe6554]

Has the Report Server version of PowerBI desktop been withdrawn now or amalgamated with the original version? I've just tried to download it as per this video and can't find a link to obtain it. Please advise.

[@carltonseymour869]

Why do you need a separate version of Power BI desktop to access Power BI Report server.

[@maryk0505]

Power BI Report Server can only report on Analysis Services cubes? We're looking for something to replace our Crystal Reports, can we not use the Report Server in the same way - connect to SQL Server or ODBC databases, etc.?

[@ayushsharma1400]

Hey, thanks for this video. Is there any workaround or a way to actually pass query parameter values in power bi report server?

[@mshparber]

Do the on-prem reports support parameters in URLs? Thanks!

[@dair919]

Michael Shparber Yes. I believe they posted a video on this a while back.

[@GuyInACube]

Actually, URL filtering for on-premises reports within Power BI Report Server is not available yet. I don't know that it will be there for general availability. I know it is being worked on though.

[@thaboseboka2654]

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

[@FlySindbad]

Nice Video , If I have SSRS already installed and configured, do I have to install Power BI report service ?

[@ekke553]

Hi Adam, Thanks for this great introduction video! We're finally getting into Power BI with Power BI Report Server (on premise). Does Power BI Report Server allows sharing reports in my company's website?

[@anthonysnk9413]

is there any way to export from PBI server from command line ? o something like with programing ? Thanks

[@hipets6952]

I have a question. If I want to embed Power BI reports into internal custom web app (reports from Power BI report server), any fee is involved?

[@prabhavjain4367]

Is there anykind of latency in report server in comparison to power bi service

[@micheledubose6881]

Hi Guy in a Cube. It seems there's a option to choose Database user name and password. When I add those credentials, I get an error. I created this db username and password in my sql instance of the report server database and granted this account with sysadmin permissions. I configured the report server database to connect to the database account. Based on my description, can you tell me what I'm missing? To elaborate more, this is the error I get: Non-Windows user credentials were supplied for a non-http connection to Analysis Services. The Microsoft SQL Server Analysis Services data extension requires Windows Integrated Security unless connecting via http or https.

[@ewenabrahams722]

Hi there, I have a Excel Pivot Report that I created from a Power BI Dataset - please could you point me in the right direction for how to replicate this Excel pivot in Power BI Desktop ?

[@GuyInACube]

The closest you can get is the Matrix visual, but it doesn't have all of the functionality of the pivot table in Excel. I know the team is continuing to improve on it though.

[@suresh_msd_7]

How to generate the link in that dashboard

[@aaronrodriguez6833]

What is the cost of Power BI Report Server?

[@stugryffin3619]

Report server seems quite limited in terms of gating access to specific reports. Looks to be the case that everyone that has access to the report server has access to all the reports?

[@carltonseymour869]

Microsoft Power BI Desktop (March 2018) (X64) is optimized for use with power BI Report server. This would mean that we would not need to download a separate version of Power BI. is this a correct assumption

[@BajkeTheSerb]

Hi, Guy(s)! Could you refer me to the video link where you tackeled the Kerberos issue?

[@GuyInACube]

Here you go. kzbin.info/www/bejne/rHSraXmXaLSjh5I

[@BajkeTheSerb]

Thx! :)

[@michaelkarlsson1461]

Will reports created in SQL 2016 Report Builder be able to be imported in the upcoming Power BI Report Server, PBRS?

[@GuyInACube]

Yes! Definitely!

[@venkatr6474]

nice video,how do we map report server datasource to the deployed pbix report?

[@VivekBotlagunta]

Hi Adam, Great video! can you tell me if it's possible to publish a data model created in Power BI desktop to report server?

[@GuyInACube]

The dataset/data model is tied to the report when you publish the PBIX to Power BI Report Server. You can't access it the way you can from the Power BI Service though. It is technically there though and needs to be refreshed. Assuming you aren't doing DirectQuery.

[@CetilLee]

Am I correct to assume that you do not need to think about premium licensing, or any licensing at all for consuming users to be able to read the reports on the on-prem server? (PBI-licensing that is)

[@CetilLee]

Nevermind, I found the answer in the comments of your PBIRS installation video :) GiaC: "Riccardo Muti mentioned in the blog that you will either need Power BI Premium or a SQL Server Enterprise SA agreement to use Power BI Report Server. "

[@GuyInACube]

Glad you found the info. Thanks for watching!

[@aliounendiaye265]

hello, how to use the explorer function on power report server

[@TheJoshuawulf]

One very important question: I see how to find reports you've created and how to change permissions for reports you've created, but not how to share them. Do we just have to copy and paste the URL and send it to the user? Or do they have to navigate from the report server URL down through folders and find the report they want?

[@AnandShelke1212]

is it possible to do Auto refreshing once data has been changed ? or Can we set refreshing interval instead of doing manual refresh?

[@GuyInACube]

The concept in Reporting Services/Power BI Reporting Services is there for Paginated reports - Data-Driven Subscriptions. I don't believe this will work with Power BI reports though. I haven't tried it yet. You could give it a try to see if it is available.

[@shanhookah]

Is RLS the same in Power BI Reporting Services as in the main service?

[@GuyInACube]

With regards to Power BI Reports, you can still create roles within Power BI Desktop for imported models. So, that part is the same. For live connections and DirectQuery, the Windows token can be passed to the data source within PBIRS, so that will allow native support for RLS in that data source. Note, that Kerberos is required to be configured for that to work. For Analysis Services, you can configure the data source within PBIRS to use EffectiveUserName to bypass the kerberos configuration.

[@webdeveloperify]

Thank you for the interesting video. Is it possible to automate the permission of PowerBI Reports (server version) using API's?

[@zorro6323]

We are running Power BI Report Server and find that you can still publish to the report server and/or view reports without a Power BI Pro license. Does that make sense? It doesn't jive with the other voices I'm hearing out there that state that Power BI report developers/publishers (for the on-premises server) still have to be licensed with Power BI Pro. We have SQL Server 2016 EE + SA, so I don't know if that makes the difference, say per licensing a Power BI report server using Power BI Premium. Can you shed some light on this confusing licensing for Power BI report server publishing? Perhaps this a licensing "honor system" instituted by Microsoft as there seems to be no licensing requirement to publish to our Power BI Report Server that was deployed under our SQL Server EE + SA arrangement. All we have to do to ensure a user can publish to the assigned folder/space in Power BI (on-premises) Report Server is that they have the required permissions to the target folder they are publishing to on the report server itself.

[@rustice2]

Are there any plans to make a video about the Power BI Optionset challenge? I have been trying to use the PowerBI Optionset Assistant plugin in XRMToolbox, but I still haven't figured out how to. Since there are so many different optionset fields in CRM, I don't know how to handle repeated values. Cheers

[@GuyInACube]

Interesting. I'm not very familiar with optionset fields, or CRM in general. Although I think we could do something about that :) I'll put it on the list.

[@kannankandasamy2791]

Does Power BI report server supports report authoring using web?

[@GuyInACube]

It does not. You need to use either Report Builder/SSDT to edit paginated reports, or Power BI Desktop for Power BI reports.

[@nandinirachamalli2882]

What if multiple persons are working and need to publish the data into single powerbi report server?Is it possible?

[@khantanveeralam]

Hello Adam, How I can embed these report in web application which will run from same server in our secure premises. Also, can I add active directory login for embedded report, same way we are doing for cloud?

[@archanamahapatra3412]

Can we Publish a report to power bi service through power bi report server desktop ?

[@sammurthy8507]

Great video. Can I get a copy of the analysis services database you are using . Thanks

[@AndrewMackay77]

Hi Adam, can I publish an existing PBI report to the PBI Server i.e a report created in the original Power BI Desktop software?

[@GuyInACube]

Your mileage may vary. No guarantee. If it was created with a version of Power BI Desktop before the released version of Power BI Report Server, it should work. The problem will be if you create a report with a version of Power BI Desktop released after the release of Power BI Report Server. There may be updates within Power BI Desktop that Power BI Report Server doesn't understand and could result in errors.

[@AndrewMackay77]

Guy in a Cube many thanks for getting back to me.

[@GuyInACube]

Not a problem! :)

[@Mrshivalg]

Hi Adam, i have installed power bi report server on my personal laptop and trying to save report created on power bi desktop but the Power Bi Report Server is not visible in Save as option . can you please let me know what setting i need to do in power bi desktop to deploy report on report server

[@asifrehman4214]

I have installed Power BI Desktop 2020(Evaluation) and Power BI Report Server(Evaluation) just fine...In power BI desktop I am not been able to find the option of on-premises deployment e.g. "Power BI Report Server"? Kindly suggest whats the problem... I can access Report Manager and Web Report Portal via url ...

[@kannankandasamy2791]

Can I implement custom authentication on PowerBI report server?

[@GuyInACube]

Yes. Custom authentication is handled the same way as SQL Server Reporting Services with a custom security extension.

[@VarahiFamousVlogsUSA]

Hi How can I pass parameters to a report to filter using URL in PowerBI report server Not in service

[@David-_-_-]

Currently it doesn't appear that on prem supports PowerBI dashboards only reports - any idea if they plan to add this in future or are we limited to just the PowerBI reports only when working on prem ? Also still shocks me they actually released the GA with only SAAS support. With those two limitations it really just feels like its barely a product at all.

[@GuyInACube]

Riccardo has commented that they are focused on reporting currently and they view the dashboard feature as one specific to the Power BI service itself. If this is important to you, i would vote up the idea item. ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/19317820-support-dashboards-in-power-bi-report-server

[@tedonmssql6550]

Is your PowerBI server on the same server as the Analysis server? If not, that could the he Kerberos error. SSRS does the same thing because you need impersonation to use them on different servers which Kerberos gives you.

[@GuyInACube]

:) they are not on the same machine. I actually have a doc showing you how to implement the Kerberos piece. For this video in question, I wanted to highlight that you didn't need to worry about that necessarily. Here is the video where I walk through that. kzbin.info/www/bejne/rHSraXmXaLSjh5I

[@TheFabdragon]

Thank you so much Guy in a cube. Great video. but I have a question. Is there any way that I can integrate a report residing in Power BI Report Server in a web application that I am developing right now?

[@GuyInACube]

The only way to embed items from Power BI Report Server, or SQL Server Reporting Services 2016 and later, is to use the following querystring parameter: ?rs:embed=true. You can then use that URL in an . Just note that it will require whatever authentication you have configured on the report server itself.

[@mshparber]

Hi Adam,If I am not mistaken, you need a special Desktop edition to publish to Server.There are many old visuals there, for instance: Matrix and Table that do not allow drill-down, you cannot change column headers, etc.When are the updates to the visuals (that are happenning all the time in the regular Destop) suppose to be updated to the Server edition?And another question: is there a possibility to use custom visuals on-prem Server?Thank you.Michael

[@GuyInACube]

Yes there are different desktop versions. the Power BI Desktop that is optimized for Power BI Report Server is only updated as often as the server is updated which is every 3-4 months. Custom visuals are supported with the GA version of Power BI Report Server (June 2017)

[@TheAj027]

Hello, I have a made a report in Power BI desktop by connecting to a overseas mysql server.I have embedded the report into a website. ALL I WANT TO DO IS MAKE THE REPORT LIVE. Can you please tell me or guide me to the link on how to do it.I can't seem to find a solution to this,if at all it exists. Appreciate your help I will :) Thanks, AJ

[@viniciusalmeida5526]

Hi there, is it possible to publish Power Bi Server reports in a direct Sharepoint library?

[@GuyInACube]

You can save a PBIX file to a SharePoint library, but it is just treated as a file store at that point. To open and interact with it, you would have to launch Power BI Desktop locally. To get the full integrated experience, PBIX files have to reside within Power BI Report Server or within the Power BI cloud service.

[@sanb4941]

Hi , if SSRS reports are migrated to Power bi reporting server and my source is MS SQL Server not analysis server, is it possible to update the report like creating few more measure , data data model level etc. can you please upload the SSRS to power Bi report server migration.

[@santiagoortizceballos8256]

Hello, is it true that python scripts are not supported in PBI RS? I created in PBI desktop for PBI-RS a report that retrieves data from an API consumed using python scripts, I published to a Report Server, and tried to open the report, it worked well and the visuals are loaded as normal, so what should be not supported about python scripts?

[@divyamaheshwari9808]

Hi I use a software called Intellumand intellum generates reports for us. We want these reports to be exported to power bi securely on a real time basis. What is the process to do this? Can youguide me to a video of yours?

[@dubeyniraj2010]

this will be on-premise deployment of Power BI. I see the possibility of a product which will be a mix of both SSRS and Power BI server.

[@GuyInACube]

Yes, this is the on-premises approach for running Power BI reports. It will be interesting to see how this improves over time.

[@rohitsingh8334]

how to add a group of users? please..

[@trkahraman]

Hi Adam. Thanks for your great informations. When u open report on report server I saw Explorer button near Edit in Power BI Desktop button. What is the function of this button? also is it possible to export data to excel on-premise Power BI ? thanks

[@GuyInACube]

The explore button is the same as it is in the service. Giving you options for drill down along with See data/see records. Export to Excel is not something that is available yet.

[@WardMorris20]

What's the benefit of using Report Server vs Power BI Online? It seemed like to me with the introduction of Power BI Online, Report Server would have been going away or at least going to the back burner.

[@dair919]

report server is an on premise solution. Power BI isn't.

[@WardMorris20]

There are still ways to deliver PBI content on-premise without RS like embedded content - especially with the introduction of Premium. This seems like a step backwards for the road map. I guess there are still plenty not willing to move to a cloud approach.

[@dair919]

Ward Morris yeah I guess you could just use power bi desktop and simply share the files

[@WardMorris20]

Sharing pbix files probably isn't a good approach. My comment is specific to embedding the content in applications.

[@GuyInACube]

There are some organizations that cannot use the cloud service. Thinking of banks, some government organizations and medical. Or there may be a company that doesn't trust the cloud. This provides an option to avoid having anything in the cloud. This is about options for the customer. If they want to publish in the Power BI cloud service, then they have that option. If they just want to use this in an on-premises approach, that is available too. A lot of folks have been asking for this capability.

[@arthurkonstantynov2379]

Hi! Can I use Power BI Report Server only, without Premium licence? And how much is this? Regards

[@GuyInACube]

To get a product key for Power BI Report Server , you have two options. 1. Purchase Power BI Premium 2. Have a SQL Server Enterprise Edition Software Assurance agreement.

[@TheHirenkapadia]

Hi Adam, How can we embed Power BI reports to the .net application which are published on Power Builder Report Server? Awaiting for your response.

[@GuyInACube]

The only way to embed Power BI reports hosted within Power BI Report Server is to use the query string parameter ?rs:embed=true. powerbi.microsoft.com/en-us/documentation/reportserver-quickstart-embed/

[@abhijeetdesai3350]

How I can publish our report on power Bi report server? Do we require Power Bi Pro for Publishing report on power Bi report server??? Or we can just save our Power Bi report on report server, it will work as you mentioned in above video?

[@GuyInACube]

From a licensing perspective, it states that any authors publishing a Power BI Report need to have a Power BI Pro license. Consumers/readers of the report do not.

[@sandeepyenni5274]

How to publish a report or a dashboard from Power BI Report Server? Please advice.

[@GuyInACube]

I"m not sure i understand the question. Of note, only reports are available with Power BI Report Server - not dashboards. You would create the Power BI report in Power BI Desktop and then manually upload the PBIX to the Power BI Report Server portal.

[@316sujay]

I got all of this to work. But when i embed the link in SharePoint 2013 page viewer the power bi report is stuck in "loading" do you know a fix for this?

[@GuyInACube]

how are you doing?

[@316sujay]

doing good...have you tried embedding power bi report server reports in SharePoint 2013 page viewer?

[@GuyInACube]

Will need to spin up a SharePoint server and give it a try. Not sure why it wouldn't work.

[@JaiswarRahul]

What is the difference between power bi server & Desktop its more or less looking the same

[@santiagoortizceballos8256]

Hello guys, actually python scripts are available in PBI desktop for PBI server, I can retrieve data from a python data source, publish the report to a report server and it works well, but the documentation says that python scripts are not supported, what does it exactly mean? because the report I built works well so I'm confused :s

[@yenGet]

Hi Adam, thx for the video.can you please do a video on how to connect power bi report server and mobile app? Or do u have a recommendation on resources to learn from. I appreciate what u do.Thx again

[@BCCartman]

I am having an issue working with a secure (HTTPS) report server, where I am NOT prompted for credentials after selecting the save location. I understand that this video is over 2 years old, but this is a difficult issue to find experience/ support on .

[@GuyInACube]

Sorry to hear you are hitting an issue. It would take some work to dig into that issue. I would recommend either posting something on community.powerbi.com or open up a support ticket.

[@asifrehman4214]

Hello... How can I access a report from the On-Premises Report Server in asp.net web forms? I am trying to render it in the like this : but it generates an error as "This content can not be displayed in a frame". Can you help me?

[@nazmulhossain5763]

how to set up Power BI Desktop

[@waltheed]

Hi Adam, Great video - thanks for that. 1 question though... If you have installed the Power BI Report Server as a different instance than the default, what path should be used when publishing the Power BI file to the server? In my case the report server instance name is PBIRS. So the url for my home page looks like this: edgarsb/PBIRS/browse/ I tried different options, like: edgarsb/reportserver$PBIRS/reports edgarsb/reportserver/reports$PBIRS but that did not work. Thanks for your help.

[@GuyInACube]

The instance name will always be PBIRS :) You can't change that. It will always be based on what you named your virtual directories within the Report Server Configuration Manager. The defaults are reports for the web portal and reportserver for the Web services/Report Server. It looks like you changed the web portal virtual directory to be PBIRS. so it would be server/pbirs to get to the web portal. What did you do for the other virtual directory? is it still reportserver? if it is, then just do edgarsb/reportserver. Just use whatever it shows within the configuration manager.

[@nyanyaa8043]

Why is it that you hardly post anything on Power BI report Server. I want to see how you do email subscription in RS Report Refresh in report server with Import mode How to connect to Oracle Database. Resolving the error while trying to connect. Step by step on how it is done.

[@goldwhispers]

Thanks for all these great updates! So useful - I'm assuming you can use imported mode from any source still? Just wanted to mention slightly off topic - not sure if you derived the data but hermaphrodite is an offensive word - the correct term is intersex. www.isna.org/node/16

[@GuyInACube]

Thanks for calling that out Vanessa! I will be more careful about that. I actually got the data from a third party. Imported data is not currently supported for Power BI reports within Power BI Report Server. It is coming soon though. Stay tuned to the Power BI blog as well as this channel for when it is available.

[@goldwhispers]

I am just busy testing the report server, and see that the only connection i can currently use is SSAS in direct query, is that correct? So i can't pull data from a SQL Server db either? Its just literally SSAS and thats it?

[@nehashahpatel1741]

Millions thanks

[@learnData-oo5yk]

pls make new video for power bi server and how to share it with other will be waiting for that

[@mykchavda]

Hello Guy in a Cube Team, I am uploading a Microsoft Excel file (our work report from different user and client) on Power BI Desktop. I want to create report in power bi dashboard with visualization tools and share this report to our different client and also report must be export in one PDF file by power bi page by page (one raw one page). It is possible or not, If Yes please guide me which visualization tools and setting is require for the same. Your this video help me to share report globally by Power BI Report Server. Thank you.

[@GuyInACube]

I'm not exactly sure what you are trying to do. You are importing Excel data into a Power BI Report. You are then publishing it to Power BI Report Server or the Power BI Service?

[@mykchavda]

@@GuyInACube No Sir, I am importing excel data into Power BI Desktop Version. Then after I want to create and export a report on multiple pages (one raw - one page) But I don't know how to do this type of report in Power BI Desktop. Suppose 500 rows in excel data, So the report creates in 500 pages in a single pdf file. Now you know what I want.

[@mikhailvakhlis835]

Great

[@GuyInACube]

Thanks Mikhail! 👊

[@buttercatz99]

This is random, horibally organized and basically worthless.

[@Mrshivalg]

Hi Adam, i have installed power bi report server on my personal laptop and trying to save report created on power bi desktop but the Power Bi Report Server is not visible in Save as option . can you please let me know what setting i need to do in power bi desktop to deploy report on report server