Or, at least, give it a try, since you can get Power BI Premium per User now, and it’s not even that difficult to try it out:

image

If you have missed that notification on your first login, you can still do it from the profile menu:

image

Which will bring you to this:

image

Now what is Power BI Premium per User? It’s, basically, Power BI Premium without the Premium price tag:

image

Note: those prices above are in CAD, so make sure to do the conversion.

You can find GA announcement for this feature here:

https://powerbi.microsoft.com/en-us/blog/power-bi-premium-per-user-now-generally-available-for-purchase/

Power BI Premium per User has almost all the same feature you’ll find in the Power BI Premium, although, there is no unlimited distribution. Which is understandable:

image

With this licence, you can now create a Premium workspace:

image

With that, you can create a publish a paginated report. Why a paginated report? Because it’s your SSRS report, just it’s in Power BI now:

image

Once you choose that option above, you’ll have to download Power BI Report Builder and start creating a report there. For anyone who worked with SSRS, this will look very familiar:

image

In the example above, while creating a Table or Matrix report using the Wizard, I’d have to specify the dataset, and that’s going to be my Dataverse instance:

image

Using that “Build” button on the screenshot above, it’s easy to set up the dataset:

image

From there, off we go to the next step to choose the table and fields (Dataverse table and fields):

image

If, somehow, you wanted to edit the query manually, there is that option there (Edit as Text).

So, go through the steps – it takes literally a few minutes, and you have a very simple report ready there:

image

Does this look familiar? How about the screenshot below, which comes straight from the SSRS tutorial (https://docs.microsoft.com/en-us/sql/reporting-services/lesson-1-creating-a-report-server-project-reporting-services?view=sql-server-ver15):

image

Anyways, you can run the report locally right away:

image

And you know what? You did not even need a license for that.

You will need a license to publish this report to the Power BI Service:

image

So, let’s publish it to the premium workspace created earlier?

image

And here it is, published there:

image

Now, before running the report, I have to update connection settings:

image

image

image

With that checkbox above selected (since we want each user to use their own credentials when accessing the data), I would sign in, re-run the report, and here we go:

image

Now the functionality there is, basically, what you always dreamed about in SSRS (at least as far as Dynamics/Power Platform goes). You can export to different formats, you can create a subscription (did not you always want to create a subscription?), and you can share the report:

image

There is one caveat with the “Share” option. Since I’ve been talking about “Power BI Premium per User” license in this post, users licensed that way can only share paginated reports (which require either a per user license or a Premium capacity license ) with the users who been licensed as well. Unlicensed users will be getting the message below:

image

That’s where “Per Capacity” licensing will come with unlimited distribution, but per user licensing will not have that included.

Once you have dealt with the licensing, you can start sharing those reports, though. This is where you have different options:

  • You can add links to the left-hand navigation in your model-driven apps
  • You can simply point users to the premium workspace
  • You can even organize those reports into an App in Power BI (although, keep in mind there is one app per workspace)

With all those updates and features, is there still a reason you need SSRS in Power Platform? Or, to ask a different question… what are you going to use to build your next pixel-perfect report and why? If you are not sure, give Power BI Premium a try, and see how it works out!