Ask Me Anything Unanswered Chat Questions Answered

Last week, I participated in an “Ask Me Anything” session where I answered questions around both Paginated Reports in Power BI, as well as questions around SQL Server Reporting Services and Power BI Report Server.

As I wasn’t able to get to all the questions posted in the chat, I said I’d answer those I didn’t get to in a follow-up post on my personal blog.  So, without further adieu, here’s a recap of the related unanswered questions with my responses.  I’ve broken them into sections focused on Paginated Reports in the cloud, as well as the on-prem offerings (SSRS/PBIRS).

Paginated Reports in Power BI

“any update on parameters? right now they are only on the page header, any chance that this area will get a makeover?”

– You’ll see us doing work to rationalize the toolbar in paginated reports with Power BI reports to the extent it makes sense.  There are certain patterns for paginated reports authors prefer in terms of parameter layout/grouping that we don’t want to disrupt, but the idea is to make the chrome around the reports look/feel similar across both report types.

Will the RLS will be available in paginated reports too?”

– Yes, when paginated reports support connecting to Power BI datasets, we will respect RLS.  We’ll also support it against other data sources when we support user-based authentication for them.

“Is there a recommended resource for testing / exploring paginated reports – i.e., a sample paginated report that can be used as a template?”

– Great question.  I’ll put together a list of resources in a follow-up post, but at a minimum recommend you download Report Builder and follow the tutorial.

“Is printing of multi-page table the main advantage of SSRS reports over Power BI tables/matrix?”

This is another good question – it isn’t an either/or, but rather which is the best tool for what you need to accomplish.  I’m going to cover this in a separate post as well.

“Is there plan to allow embedding Paginated report in SharePoint Online as we can today with PowerBI Report?”

– Yes, this is planned.

“power BI service will we get subscriptions for paginated reports in the same way we have now in SSRS? Also will this be extended to Power Bi reports and dashboards in Power Bi service. Including Data Driven Subscriptions?”

Yes!  You’ll see the current subscriptions in Power BI evolving to give you the options you have with SSRS today for both report types.  This includes scheduling, the ability to send with specific filters/parameters applied, attachment support, etc.

“for now I’m not able to find paginated reports using the search function on the Home page. Any timing when/if this is coming?”

This is a known bug that we’re working with other teams to get resolved.  You should see this fixed in the next couple months.

Power BI Report Server/SSRS

“can we share a .pbix report through emails?”

We aren’t planning to add subscription support for Power BI Reports in Power BI Report Server in the short term.

“Would love to hear about how RLS will be implemented to PBIRS.”

This work is well underway for the January 2019 release of Power BI Report Server.  It will be similar to what you do in the service today, where you set the roles in the desktop and assign users to those roles in the server through the web browser.

“And along the same lines, what about standard templates, such as headers/footers?”

This is an improvement we’d like to look at for the Power BI service as it relates to Paginated Reports, so we’d also look to bring it back to the on-prem product as well.

Looks like the other questions related these areas were all addressed either in the session or in the chat itself.  If you have additional questions, feel free to check the existing FAQ, or leave a comment in the blog comments below!

Download Paginated Report Bear’s sample paginated report for Power BI

image

Hi everyone, it’s guest blogger Paginated Report Bear!

Well, actually, Mr. Chris agreed to type for me since I don’t have fingers.  Anyways, if you watched my intro video, I promised you all I’d make a sample report and share it by the end of the week.  Since I always keep my promises (EDITOR NOTE: no he doesn’t), here is my first paginated report that you’re free to download and try out in Power BI!  It uses the Enter Data feature that was introduced a few months ago, so you can upload it as is into your Power BI (Premium) workspace and give it a try.  If you don’t have Premium capacity, use the steps in Mr. Chris’s last blog post to spin up a capacity and try it out yourself.  The report sample has a couple cool tricks in it, like dynamic images based on the parameter you select, so it might be a nice reference for you in the future.

I’ll be creating more samples and talking more about paginated reports in the future (or not, depending if my son gets tired of doing this).

Thanks for reading!

Paginated Report Bear Sample Report

How to use A SKU’s to try out Paginated Reports in Power BI without upfront cost or long term commitment

image

Since the Eagles game doesn’t start until later, thought I’d put this together for folks.

As many of you know, earlier this month we announced a preview of Paginated Reports in Power BI.  While folks were excited about this, there were those who were disappointed it was only available (for now) if you had Power BI Premium.

“I don’t have Premium (yet . . .),” they said,  “But I still want to try this out and use it.  How can I do so without committing to it for a month and paying $5000?”

The good news is, there is an easy way to do this.  See, as I’ve stated in previous interviews, you can try all the functionality out by spinning up an Power BI Embedded A SKU capacity, which is available to purchase through Microsoft Azure.  While normally A SKU’s are specifically used for embedding scenarios, there is no licensing restriction against using them internally if you’d like.  However, generally this makes little sense vs. purchasing a P SKU for most use cases, since each user would still need a Pro license to access the Power BI portal AND it’s almost $1000 more per month if you run it all the time.

But if you just want to try out the new functionality that is available only on Premium capacity, the big advantage of A SKU’s is you can stop/start them just like any VM in Azure, and you’re billed by the minute vs. having an initial upfront monthly cost.  This means you can spin up an A SKU, turn on the paginated reports capability in your Power BI portal, and start using it.  And when you’re done, you can go into Azure and pause the capacity until you want to use it again.  Since you’re only billed for the time it’s running, you can try this new functionality out for around 14 cents a minute! (this figure is based on my fuzzy math being done while my son is playing Fortnite right next to me, so forgive me if this is off by a few cents one way or another).  Let’s walk through how you’d go set this up yourself –

I have my own Power BI subscription (yes, I pay out of pocket for this), since I like to have access to the exact same experience as all of my users do (or I forgot to turn it off when I joined the team . . .).  In any event, I have a Pro license, but when I check the Admin Portal, I can see I have no Premium capacities right now.

image

Note another tab there which says “Power BI Embedded” – I don’t have any of those capacities, which you purchase in Azure, spun up currently either.

image

To get one of those going, I’m going to head to the Azure Portal and login with my credentials that I also use for Power BI.  Why? Because I’m the only user, so I’m also the admin.  Now, I can do a search for “Power BI Embedded”.  This will take me to the management page, which looks like this

image

I hit the “Create Power BI Embedded” button, which, if you haven’t signed up for an Azure account yet, you’ll be prompted to do so, and this includes a $200 credit for 30 days.  If you have signed up for Azure, you will skip this step (duh).

image

Now that I have that setup, I’ll go back to the portal and get back to the previous screen.  Here, I can click the button again to setup a new Power BI Embedded A SKU.  You need to select at least an A4 capacity size or higher to use Paginated Reports, so I’ll pick an A4 in my home location to spin up.  (NOTE: Paginated Reports are also supported in multi-geo scenarios, even during our public preview, so I could choose other regions outside my home region if I wanted to.)

image

Everything looks good, so I’ll hit create and wait for it to finish deploying.

image

If I check my Power BI Portal, I see that it is also showing as being deployed there under the Capacity Settings –> Power BI Embedded tab
image

Once it’s completed deployment, when I click on the capacity name, I’ll see I can manage this capacity just like I would any premium capacity in Power BI.

image

Under the Workloads, I see the two new preview workloads, and I’ll set Paginated Reports to “On” and assign 50% of the memory to that workload.  I can also try out the new Dataflows workload as well, but I’ll save that for another time.

image

After a few moments, I’ll see the message has changed from starting to Ready, and my workload is now ready to use.  I’ll assign all (one) of the workspaces for my organization to this new capacity.

image

Cool!  Now, I can upload my first paginated report to the workspace and view it.  I’m using a vintage Halo sample report, and it renders without a hitch.

image

But now I want to stop using the capacity and not get charged (since I finished this blog post).  No problem – I can go back to the Azure portal and just pause the capacity until I want to use it again.

image

When I’ve paused it, I can no longer view my paginated reports in Power BI, but they aren’t deleted or otherwise affected.  They’re still there waiting to be used again when the capacity is started up, and I can delete them if I need to.

image

And that’s it – in less than an hour, including the time it took to type this blogpost, I created a new Azure subscription, created my first Power BI “Embedded” A4 capacity, turned on the Paginated Report workload, assigned a workspace, uploaded and viewed my report, and then paused the capacity to stop the billing on it.  Whew!

Thanks so much for reading through the post today, and I hope you all take some time to try out the new paginated reports in Power BI Premium.  And if your organization doesn’t already have Power BI Premium, use this walkthrough to give it a try yourself!

Happy Thanksgiving (week)!

Use Outlook Shortcuts to organize your favorite Power BI Reports and Dashboards

image

I haven’t written in awhile, but wanted to get this up while it was still fresh in my mind (and had some time left at lunch).

Did you know Outlook had a shortcuts feature?  I didn’t (or at least I didn’t remember I did), and this video was the only one I could easily find on the topic.  Ostensibly, it’s used to create shortcuts to folders in Microsoft Outlook that you can quickly jump to.  However, as I found out, you can also use it to jump to web content, including content in Power BI!  Just follow these simple steps –

1. In Outlook (I’m using Outlook 2016), head to the shortcuts pane by finding the ellipsis at the bottom of your left-hand navigation area and choose “Shortcuts”
image

2. By default, you’ll see two shortcuts

image

To start adding web pages as shortcuts, I want to have them organized, so I’m going to right-click on the “Shortcuts” top menu option and create a new shortcut group called “Power BI”.

image

3. Once I’ve done that, it should look like this –

image

I can now add a web address as a shortcut, but I need to do this in a slightly different way than you might expect.  To do this, I’ll highlight the url in my browser that’s open like the following –

image

I’ll then drag this address under my new shortcut group in Outlook and give it a friendlier name (using my right-click menu option to rename the shortcut) so it looks like the following –

image

Now when I click the link, it looks like this in Outlook –

image

Not only that, it’s fully interactive and I can (seemingly) do all the same things with my dashboard or report I’d do in a separate browser

image

I have to be honest – I’m surprised this works as well as it does, and it’s much better than almost any other web page you might pull in there in my limited testing.  And maybe this isn’t that helpful to some folks, but I worked with a lot of former execs who would’ve LOVED to have been to simply to do everything right in Outlook.

Thanks for reading!

Using Power Update to refresh Excel Workbooks in Power BI Report Server

image

Happy Holidays!

With the latest release of Power BI Report Server, we introduced the ability to share and view Excel Workbooks in a web browser (assuming you Office Online Server setup for your server farm).  This included workbooks that had Power Pivot models embedded in them with external data connections that might need to be kept up to date.  However, there isn’t currently a way to automatically refresh the data for those workbooks on the server currently like you can in SharePoint.  Today, I’m excited to show you a way to get around that limitation using a tool called Power Update from a Power BI partner called PowerOn.

First announced on Rob Collie’s blog a couple years ago, Power Update is a standalone program that allows you to automatically refresh Excel files and load them to several destinations, including SharePoint, OneDrive, and Power BI Report Server.  Let me walk you through how simple it is to get started and use with PBIRS –

1. When you first start Power Update, you’ll want to create a new task.  Click “New” to get started –

Capture

2. Give your task a name and click Next –

screenshot2

3. You can decide how often you’d like to refresh your Excel workbook.  I chose to do it every hour on a daily basis

screenshot3

screenshot4

screenshot5

4. I can choose to either refresh a single file, or all the files in a particular folder.  I just need one workbook refreshed, so I choose that and proceed

screenshot6

5. For my publish location, I want to publish to Power BI, and then select the “Power BI Report Server” option.

Inkedscreenshot7_LI

6. I finish setting up the options for my server location and I’m done! (There are some optional items I can also choose in the last two screens, but I didn’t change anything on those for this exercise)

screenshot10

After I’ve set everything up, you’ll see the first task in my list is now populated.  As a test, I clicked the “Run Now” button to see if it works.  Everything was setup properly, so it’ll refresh the workbook, publish it to the server and then let me know it was successful.  I can even setup e-mail notifications to tell me this after each time it runs!

screenshot8

screenshot9

That’s it – it’s very simple to set up and manage your Excel Workbooks in Power BI Report Server and make sure they always have the latest data for your users.  And yes, anyone can use the public REST API’s for Power BI Report Server to do something like this on their own if they’d like.  Power Update just makes it easy to enable this functionality for their organization.

Power Update offers users both a free and paid version of their product – the free version offers all the functionality of the paid version, but is limited to only one workbook you can schedule and use.

Thanks for reading!

Tips when upgrading from the August preview to the October release of Power BI Report Server

Happy Thursday!

Many of you probably saw my blog post yesterday regarding the new release of Power BI Report Server.  I wanted to bring to your attention a couple additional items as it relates to that release, specifically when you’re upgrading from the August preview.  I am covering these in my session at PASS later today, but wanted to have something out before that time.

1. You must use the October 2017 version of Power BI Desktop that is optimized for Report Server with this release. You can download that October version directly here – https://www.microsoft.com/download/details.aspx?id=56136

2. If you have upgraded from August, any Power BI report that you used imported/embedded data in must be re-published. The simplest way to do this would be to download the file locally, open it using the October 2017 version Power BI Desktop for RS, and then save it back to the server.  You should then have no issues viewing the reports on your server.

While most folks won’t be affected by this scenario, some of our most passionate users (like those attending PASS Smile) will be, so please remember these tips as you upgrade.

If you’ll be at my session later today, I look forward to seeing you there!

Adventure Works brand package now available!

image

Super short post today.

With the release of an updated test/demo Azure VM for Power BI Report Server on Monday, we thought it made sense to provide a new Adventure Works brand package for everyone to use in their demos/presentations to go along with it.  Feel free to download and use with Reporting Services 2016/2017 or Power BI Report Server – https://1drv.ms/u/s!Au6-0xX27UdgnOIapntXPaoPcqqOWQ

Thanks!