BI-NSIGHT – Power BI (Email Subscriptions, New APIs for Custom Visuals, Accounts Receivable Solution Template for SAP, Help Improve Direct Query) – SQLBI (Vertipaq Analyzer 1.7) – SQL Server (Power BI Reports in Technical Preview, Getting Started with Technical Preview of Power BI Reports)

It appears that we are now getting back into the swing of things, and this means more updates and additions to the Business Intelligence World.

Power BI – Email Subscriptions

This was a feature that I know I have personally been waiting for as well as a lot of other people.

And yes this is very basic at the moment but you have to start from somewhere. And with this initial public preview you have the option to subscribe to a report page, which will be emailed to you Once a day when there is a change.

The great thing is that they are already letting me know that in a future release I will be able to subscribe other people also. And I have no doubt as the year progresses there will be additional updates.

You can read the blog post details here: Introducing email subscriptions in Power BI: stay informed when it matters

Power BI – New APIs for Custom Visuals

As you can see above there are 2 new Custom Visuals in the Gallery.

For me personally this is great, whilst I do not develop custom visuals, what this update does mean that there will be even more amazing and imaginative custom visuals in the near future.

I would love to see what other people have actually developed internally for their own datasets, so if anyone is willing even to share a picture of the Custom Visual please let me know.

For those who do develop Custom Visuals here is the blog: New APIs available for custom visuals developers

Power BI – Accounts Receivable Solution Template for SAP

As with the other solution templates, the people from Simplement have created a solution template for Accounts Receivable for SAP.

You can find the details here: Announcing the Accounts Receivable Solution Template for SAP

Power BI – Help Improve Direct Query

Below is a survey from the Microsoft Power BI Team with regards to people who use Direct Query.

Survey Link: Direct Query Survey

Blog Link: Help Improve DirectQuery!

SQLBI – Vertipaq Analyzer 1.7

I have to say that the new additions in the Vertipaq analyser are really awesome.

I like that you now have the ability to analyze your Power BI Files and see what is taking up all the space.

As well as the capability to extract all your DAX Measures. Which when working on a larger project and having to document all the measures this can be quite a cumbersome task. And along with this you can easily format the DAX expressions you the DAX formatter which I think is worth it.

You can watch the video with a great explanation of the updates here: VertiPaq Analyzer 1.7

SQL Server – Power BI Reports in Technical Preview

I know that for On-Premise customers this is something that they have been waiting for. Now you can download and install the technical preview with a lightweight installer that will take minutes to install and get you going.

What really is interesting is that you only need SQL Server 2008 or later database engine. And then SQL Server Analysis Services 2012 SP1 CU4 or later. So that means you do not need SQL Server 2016 to run this in Premise.

As well as there is a technical preview for Power BI Desktop.

And finally they have also added more functionality into the On-Premise version which is to connect live to Analysis Services Tabular and Multidimensional.

You can find the details on their blog here: Power BI reports in SQL Server Reporting Services: January 2017 Technical Preview now available

SQL Server – Getting Started with Technical Preview of Power BI Reports

As with the above link, there is already a blog post explaining how to install and configure your Reporting Services to test Power BI On-Premise.

I read through this blog post and I have to say that it is really quick and simple to get this up and running. Compared to how installations were in the past, this is like a breath of fresh air.

You can find the blog post details here: Getting started with the Technical Preview of Power BI reports in SQL Server Reporting Services

Power BI Report – SSRS (SQL Server Reporting Services) Report Performance

Have you ever wondered about how your SSRS reports performance was?

  • How many people are using the reports?
  • How fast are the reports being rendered?
  • Are people running reports, or running them to export them?
  • What is the size of the reports?

In this blog post today I am going to give a brief overview of what I did to create the SSRS Report Performance and then how to use it after you have downloaded the Power BI Template File.

Overview for SSRS Report Performance

I had a requirement where we were looking for not only the usage of our SSRS reports, but also the performance and size of the SSRS reports.

So I created it in Power BI, so that this could be seen by the required people in the organisation.

To see the details of the query that I wrote you can go into the Edit Queries and see the TSQL Query that I wrote to extract the required data.

Further in the blog post I will explain how to easily take this file and run it against your own SSRS Reporting database.

Finally, this is the first draft for this report, so any suggestions, changes or additions will be welcome. Please leave me a comment.

Below is an overview of what each Page does.

Report Usage

As you can see above, this shows details around reports usage, who has been running the reports. As well as the execution times.

I have also put in a Report Name Filter (using the Smart Filter by Okviz.com) in order to filter for reports. As well as using calendar slicers to filter for specific periods.

Reports Performance

With this report we are looking for the report performance. This enabled us to view where the time was being taken for our reports that were being rendered.

I have used the Report Format, as a means to filter the reports.

As well as providing a legend with each report format type, so that you can easily see which one is taking the longest average time to complete.

I have also included the average times for the three area’s when a report is run. As this can help when trying to identify a specific report and where it is taking the longest. So by clicking on a report name at the top, it can then filter this below.

We have noticed that when people are exporting the reports to CSV or Excel that the majority of the time is spent in the processing of the report.

Report Format

What this page does is to show the Report Format that is being run and used over time, as well as reports usage.

This enables us to get an understanding of what reports the users are using, or are they running a report, to just extract the data? Or running mobile reports more than the standard SSRS reports?

I have also put in a Report Name Filter (using the Smart Filter by Okviz.com) in order to filter for reports. As well as using calendar slicers to filter for specific periods.

Report Size

The final report, is the report size. And this is simply to see which reports are the largest. And to see the report size over time.

A thing to note, is that the current screenshots are from SQL Server 2016, and I currently can identify which is a mobile report, but I cannot identify the name of the report.

I have also put in a Report Name Filter (using the Smart Filter by Okviz.com) in order to filter for reports. As well as using calendar slicers to filter for specific periods.

Download of Power BI – SSRS Reports Performance Template

You can download the Power BI – SSRS Reports Performance Template File here:

SSRS Report Performance.pbit

How to use Power BI Template File for SSRS Reports Performance

Below are the steps to complete once you have downloaded the SSRS Reports Performance template file.

Changing the Parameters

Once you open the file you will see a screen with the following parameters as shown below:

As you can see above we have got 3 parameters to enter.

  • The first is the SSRS SQL Server Name. EG: SQLServer\InstanceName
  • The second is the Report Server Database name. EG: ReportServer
  • The final parameter is a Future Scope with the Report Speed. You can leave this as the default for now.

Click Load to load your SSRS Reports Performance analytics reports.

Uploading to the Power BI Service – Enterprise Gateway Connection

If you want to use the Enterprise Gateway connection, you must ensure that you have got it installed and configured in both the Power BI service, and on your Server that has access to your SQL Server.

NOTE: I have found that it works as expected when both the SSRS SQL Server Name and the name that you configured in the Power BI Service for the Enterprise Gateway are identical.

Now you can create a scheduled refresh and share this with users in your organisation.

Keeping history for SSRS ReportServer Database

Just as a final note, currently the SSRS ReportServer database only keeps 3 months’ worth of history.

So if you want to keep the entire history I would recommend that you extract this data into another table. After which you can then modify the query to look at your historical table. If you do require assistance with this please let me know.

BI-NSIGHT – SQL Server 2016 CTP 3.0 (SSAS, SSRS, SSIS) – Power BI (Chiclet Visual, SparkPost Content Pack, Weekly Service Update, Personal Gateway Update, Tiles in SharePoint)

I expected this week to be a really interesting week with SQL Pass happening. As I was sure to see some really good and interesting updates from Microsoft and it sure is living up to this.

There has been a lot of information on Twitter and on other blogs, so here is my take on the developments.

SQL Server 2016 CTP 3.0 (SQL Server Database Engine, SQL Server Analysis Services, SQL Server Reporting Services, SQL Server Integration Services)

There was a whole host up dates with SQL Server 2016 CTP 3.0, which is great to see, as well as some announcements of what we can expect in subsequent releases.

I am just going to highlight below what I think is relevant in the BI space. But there will be links below where you can find the related blog posts, which have more information from the Microsoft teams.

SSAS

With regards to SSAS, it is good to see how much effort and work is going into the Tabular model. Which is what I thought would be the case.

I think that it is really great to see that they have changed the underlying structure from XMLA to JSON. The way that I see it, this is how they have implemented Power BI in terms of having the SSAS database sitting in memory in Azure. And without a doubt I am sure that they have learnt a lot, and from this they can then leverage this and bring it into the On Premise product. We all know how fast it is online!

The MDX Support for Direct Query is also a great update. I can see a lot of people leveraging this, and when you partner this with APS you can pretty much start to enable real-time analytics. Which can be a real game changer.

All the other updates that are coming into SSAS have mostly been completed either in Power BI Desktop or in Excel 2016. So it is great to see this in the Server product which will go a long way to ensure that it can scale and perform for enterprise workloads.

SSRS

I have eagerly been waiting to see what was going to happen in the SSRS space. And whilst I had seen some of the now released information it is great to see it being released to the general public. As well as how well it has been received.

The pinning of SSRS reports into Power BI is a really smart move. And the ability to also refresh this report in Power BI is pure Genius. What this means now is you can leverage both of your On Premise and cloud investments. And to the users this will be seamless.

What I also really like is that you can often create really interesting SSRS reports, and the executives and high level managers do not need to see the details. They just want an overview. And now by leveraging this all into Power BI, it becomes their one stop shop!

SSIS

There does not seem to have been a lot of love for SSIS, and to be honest it is a stable and really good product.

But what I did see is the Control Flow Template, and I am hoping that this is something similar to what you can currently do with BIML. What that is how I perceived it to be. And I am hoping that you can create different control flow templates for different control flows. So for example you could create a control flow template for a SCD Type 2. And then once you have it designed the way that you want, any other developers can then utilize it. This would go a long way in enterprises where you want to standardize the way of doing things.

You can read about all of the above here:

Power BI – Chiclet Visual Slicer

The one thing that I have been struggling with in Power BI was how to get a slicer to work, so that it looked good.

And low and behold there is a new visualization which can how do this. And to have it with images also is really smart. As people love to click on Images.

Another great announcement was from James Phillips that Microsoft would be releasing a new visualization every month, indefinitely. This is really great and I am sure that we will see some really interesting and useful visualizations in the future.

You can read all about it here: Visual Awesomeness Unlocked: The Chiclet Slicer

Power BI – SparkPost Content Pack

This week there is another interesting and great Content Pack. This time for SparkPost. Which you can now use to monitor your Email campaigns.

You can read about it here: Monitor Your SparkPost data with Power BI

Power BI – Weekly Service Update

Not only was there a host of announcements at SQL Pass, there was the weekly Power BI Service update.

Once again I am going to quickly highlight what there is in this week’s update.

They have made quite a few improvements with regards to the way we can share the dashboards in Power BI. All of these updates make it a lot easier to share the dashboard and to enable people to see how good Power BI is. The additions are (Sharing the Dashboards with AD Groups, People Picker and Sharing with a large number of Email addresses)

Along with this is the ability to start passing parameters into the URL. I have no doubt that passing URL parameters will keep on increasing and giving additional flexibility in the Power BI service.

You can read about it here: Power BI Weekly Service Update

Power BI – Personal Gateway Update

There was an update late last week for the Power BI Personal Gateway and it is mostly around bug fixes and performance improvements. Which is great to see because I do know that often we want it to run as smoothly and quickly as possible

You can find more information here: New version of Personal Gateway is now live!

Power BI – Tiles in SharePoint

And finally the guys from DevScope have now created a Power BI Tile for SharePoint.

I think that this will work really well, because it will give the ability to showcase all the work done in your Power BI reports, as well as not having to re-create reports over and over again.

If you want to find more details and pricing, you can find it here: Power BI Tiles for SharePoint

Power BI (Visual Contest, On the Go, Hyperlinks, Drill Up, Drill Down, tyGraph Content Pack) – SQL Server 2016 – CTP 2.3 (SSAS Tabular with a dose of speed, SQL Server Data Tools (SSDT), SQL Server Reporting Services (SSRS)) – Power BI (Personal Gateway for Power BI Update)

Right once again there is a lot to get into this week, and as with every week there are a whole host of Power BI updates.

Power BI – Visual Contest

I have to say that this is both a smart and fantastic move by Microsoft. This allows them to get or gain a whole host of new chart types that can be consumed within Power BI, without having to spend a lot of development time getting it all completed.

As well as there are a lot of smart people that have some great idea’s. And this gives them a great platform to showcase their idea’s. As well as get some recognition for their efforts.

As you can see in the above screenshot, this is a great KPI example. To me it does look similar to the Datazen KPI’s. But I do know that it would be welcome in Power BI.

You can read all about the contest details here: Announcing the Power BI Best Visual Contest!

Power BI – On the Go (Mobile Apps)

There has been another great update to the Mobile Apps for Power BI. And it is across all the current mobile platforms that are supported.

I like the idea that you can keep your favorites and have them on a dashboard within the Power BI Mobile application. This gives a very similar experience as with the Web based Power BI. Which is great when you potentially want to see data from different sources.

I also like the fact that you can enable Data Alert Rules, which means you can get alerts on your mobile device when the thresholds that you have set are exceeded. And just means that you do not have to go and keep on checking on reports or data. A much more proactive means of being notified.

There are some additional details which you can read about here: Power BI on the Go

Power BI – Hyperlinks, Drill Down and Drill Up

Once again this week the Power BI team has been very busy and has a whole host of updates to the Power BI Service.

Firstly, is the ability to put inline Hyperlinks, which I think is really great and will get the report consumer a much better and more streamlined experience.

The thing that I think is really fantastic is to have the ability to Drill Down as well as Drill up within the report. They have done another amazing job in making the process so simple to implement. As well as very easy to use when using the report. And I know that very often users ask if there is the ability to Drill Down. I also like the fact that you can then filter on your information once you have drill down. Which makes the entire report experience easy, quick as well as ensure that the users are really happy.

You can read all about it here: Power BI Weekly Service Update

Power BI – Content Pack tyGraph

Another week, another great Content Pack.

This time it is tyGraph, which is something that can be used or reported on if you use Yammer. Which I know more companies are looking to use, especially if it is part of your Office 365 Subscription.

You can read all about it here: Analyze and Monitor your tyGraph Data with Power BI

SQL Server 2016 – CTP 2.3 – SSAS Tabular with Direct Query

This was a very interesting blog post to read, due to the fact that in the past I never really thought of using the DirectQuery mode with SSAS OLAP or Tabular, due to the fact that in the past it did not perform well or fast.

From the blog post they have made some significant improvements in SQL Server 2016 CTP 2.3 And it is nice to see that SSAS is finally getting some attention. As well as looking at this example it would allow the report to be run and executed in real time. So if your source data is being updated on a regular interval, it means that going via SSAS Tabular to your Source SQL System you would be able to get up to date data. As well as it being so much quicker this really has the potential to be a game changer for a lot of organizations.

You can read all about it, as well as the details here: SQL Server Analysis Service 2016 CTP 2.3 DirectQuery in action

SQL Server 2016 – CTP 2.3 – SQL Server Data Tools (SSDT)

Just a quick note that they have updated how SSDT will be working going forward.

It appears that they have unified the setup for Database as well as BI (Business Intelligence). It makes perfect sense as the two work hand in hand.

You can read about it here: SQL Server Data Tools Preview update for August 2015

SQL Server 2016 – CTP 2.3 – SQL Server Reporting Services (SSRS)

It is nice to finally some actual changes and new things happening in SSRS. I am sure I am not the only one that agrees that it has almost been too long for SSRS to get an update. I personally was getting to the point where I was using SSRS as a last resort. But with all the upcoming changes I am sure that looking ahead this will become another alternative or an option for a reporting platform.

As you can see from above, it looks to me as if it will be along the similar lines of Power BI Desktop. Which I think is great so that report developers as well as people using Power BI will be used to a similar reporting experience.

It is also good to see, due to changing the way that they have created the new version of SSRS, that it is supported on pretty much any browser.

You can find out more about it here: What’s New in Reporting Services in SQL Server 2016 CTP 2.3

Power BI – Personal Gateway Update

It is great to see another update to the Power BI Personal Gateway. Along with the updates to SSAS OLAP (Multidimensional & Tabular) as well as the support for Custom ODBC drivers. Which means that you can connect to almost any database source.

This is a great alternative to ensure that your data in your Power BI reports are being updated and relevant. Which as I was writing about earlier, if your users are using the Power BI Mobile app, it then means that they can get notifications on the fly. Which can enable them to make the right decisions at the right time.

You can find out more information here: New version of Personal Gateway now available!

BI-NSIGHT – SQL Server 2016 – Power BI Updates – Microsoft Azure Stack

Well I have to admit that it seems that the Microsoft machine has been working flat out to get out new products and updates.

If my memory serves me, this is the third week in a row that Microsoft has released new products and updates. I am really enjoying it! But hopefully this will slow down, so that we can catch our breath and actually play with some of the new products and features.

So let’s get into it. There is quite a lot to go over!!

SQL Server 2016

So with Microsoft Ignite happening this week, the wonderful guys from Microsoft have started to announce what we can expect to be in the next version of SQL Server.

I am going to focus mainly on the BI (Business Intelligence) features, and there are quite a few! Some of what I am detailing below I have only seen pictures on Twitter, or I have read about it. As well as the preview not even being released yet, I am sure that there will be some changes down the line.

SQL Server Reporting Services

It finally appears that Microsoft has been listening to our cries and requests for updates in SSRS (SQL Server Reporting Services)!

Built-in R Analytics

I think that this is really amazing, even though I am not a data scientist, I think it is a smart move my Microsoft to include this. What this means in my mind is that you can now get the data scientists to interact and test their R scripts against the data as it sits in the transactional environment. And from there, this could then be used to create amazing possibilities within SSRS.

Power Query included in SSRS

From what I have seen people tweeting about as well as what I have read, it would appear that Power Query will be included in SSRS. This is fantastic and will mean now that virtually any data source can be consumed into SSRS.

New Parameter Panel, chart types and design

I am sure we can all agree, that SSRS has required an overhaul for some time. And it seems that finally we are going to get this. It would appear that the parameters panel is going to be updated. I do hope that it will be more interactive and in a way react similar to the way the slicers do in Excel. As well as getting new chart types. Here again I am going to assume that it will be similar to what we have in Power BI!

And finally there was also mention that the reports will be rendered quicker, as well as having a better design. I also am hoping that they will deploy this using HTML 5, so that it can then be viewed natively on any device. It is going to be interesting to see what Microsoft will incorporate from their acquisition of Datazen.

SQL Server Engine

Built-in PolyBase

Once again, this is an amazing feature which I think has boundless potential. By putting this into the SQL Server Engine this means that it is a whole lot simpler to query unstructured data. Using TSQL to query this data means that for a lot of people who have invested time and effort into SQL Server, now can leverage this using PolyBase. And along with this, you do not have to extract the data from Hadoop or another format, into a table to query it. You can query it directly and then insert the rows into a table. Which means development time is that much quicker.

Real-time Operational Analytics & In-Memory OLTP

Once again the guys at Microsoft have been able to leverage off their existing findings with regards to In Memory OLTP and the column store index. And they have mentioned in their testing that this amounts to 30x improvement with In-memory OLTP as well as up to 100x for In-Memory Column store. This is really amazing and makes everything run that much quicker.

On a side note, I did read this article today with regards to SAP: 85% of SAP licensees uncommitted to new cloud-based S/4HANA

I do find this very interesting if you read the article. What it mentions is that firstly 85% of current SAP customers will not likely deploy to the new S/4HAHA cloud platform. Which in itself does not tend well for SAP.

But what I found very interesting is that to make the change would require companies to almost start again for this implementation. In any business where time is money, this is a significant investment.

When I compare this to what Microsoft has done with the In-Memory tables and column store indexes, where they can be used interchangeably, as well as there is some additional work required. On the whole it is quick and easy to make the changes. Then you couple this with what Microsoft has been doing with Microsoft Azure and it makes it so easy to make the smart choice!

SSAS (SQL Server Analysis Services)

I am happy to say that at least SSAS is getting some attention to! There were not a lot of details but what I did read is that SSAS will be getting an upgrade in Performance usability and scalability.

I am also hoping that there will be some additional functionality in both SSAS OLAP and Tabular.

SSIS (SQL Server Integration Services)

Within SSIS, there are also some new features, namely they are also going to be integrating Power Query into SSIS. This is once again wonderful news, as it means now that SSIS can also get data from virtually any source!

Power BI

Once again the guys within the Power BI team have been really busy and below is what I have seen and read about in terms of what has been happening within Power BI

Office 365 Content Pack

I would say that there are a lot of businesses that are using Office 365 in some form or other. So it makes perfect sense for Microsoft to release a content pack for Office 365 Administration

As you can see from the screenshot below, it gives a quick overview on the dashboard to see what activity is happening. As well as details of other services. I am sure that this will make a quick overview of your Office 365 systems really easy to see. And also if there are any potential issues, this could also be highlighted!

Visual Studio Online Content Pack

Another content pack that is about to be released is for people who use Visual Studio Online, I personally do not currently use this. But it does look great for people to once again have a great overview of what is going on.

You can read more about it here: Gain understanding and insights into projects in Visual Studio Online with Power BI

And as you can see below, what you can view once you have got it setup within Power BI.

Power BI planned updates

Below are the updates that I had previously voted for in Power BI. It is great to see that the Microsoft team is actively listening to their customers and implementing some of the idea’s. I have to say that I do not think that there are many other software companies that are doing this currently. And also being able to roll it out as quickly as Microsoft is.

Set Colors and Conditional Formatting in visuals

  • This is great as it will allow the report authors to have more control in terms of how their reports look.

Undo / Redo button in browser & designer

  • This might seem like a small update, but I know personally from working with the Power BI reports, that sometimes you just want to see what a different report looks like. Or adding another element. And with the Undo / Redo buttons, it just saves that little bit of time, as well as to make the report authoring experience that much more enjoyable.

Power BI Announcements from Microsoft Ignite

Below are some announcements that I have read up about either on Twitter or one of the blogs that I follow. It is really great to see so many things in the pipeline.

This means that there is a lot to look forward to, as well as ensuring that we have new and wonderful things to show.

I got this picture via Twitter, which someone must have taken at the Microsoft Ignite Conference. As you can see it is not very clear, but it does show the next update in the Power BI Designer.

You can also see the undo and redo buttons.

It also appears that in the Power BI service, there will be support for SSRS files, namely the .rdl files! Here is another picture taken from Microsoft Ignite.

 

Then there is the Many to Many relationships and bi directional cross filtering will be supported in SQL Server 2016 tabular models, which I am sure will also be included in the new Power BI backend. As this is where it stored all the data.

 

For Hybrid BI, there will be support for live querying for SSAS, currently this is already in place for SSAS Tabular.

 

It also looks like there will be a scheduled refresh for SQL Server Databases as a source. Which is great for people who either do not have either of the SSAS cubes, or want to get some of their data into Power BI.

Microsoft Azure Stack

While this is not exactly BI, it is related to BI, in that with Azure Stack you can get the Azure functionality on your own hardware which is fantastic. And I am sure for a lot of businesses this will be welcomed.

You can read more about it here: Microsoft Brings the Next Generation of Hybrid Cloud – Azure to Your Datacenter

 

SSRS – Microsoft sql server fitler table/matrix with 2nd row of data

What I wanted to do, was to create multiple table/matrix, but to have them separate. And then to have 5 of them in total. But I wanted to have the top 5. So I wanted the first one to be the top value, then top 2, top 3, top 4 and top 5.

This is what the result looks like:

clip_image002[5]

1. Create your first table/matrix which will be filtered as shown below:

a. clip_image004[5]

2. Then copy and paste your first table/matrix and complete the filter like this to show ONLY the second one or top 2

a. clip_image006[5]

b. The thing to note here is that for the Top N value I put 2

c. And then for the Bottom N I put 1

3. Then to do this for the third or top 3, do the following:

a. Copy the above table/matrix and complete the filter as follows:

b. clip_image008[5]

c. The thing to note here is that the Top N was changed to 3

4. NOTE: For any additional table/matrix change the top N to the value you want.

SSRS – Viewing status of Data Driven Subscriptions

What I wanted to do, is to see the status of my data driven subscriptions which are emailed out.

I wanted to ensure that there were no errors when being sent out, as well as ensuring that they were indeed sent out.

NOTE: This follows on from the FRAMEWORK FOR AUTOMATING SQL SERVER REPORTING SERVICES (SSRS) DATA DRIVEN SUBSCRIPTIONS – PART 1 and FRAMEWORK FOR AUTOMATING SQL SERVER REPORTING SERVICES (SSRS) DATA DRIVEN SUBSCRIPTIONS – PART 2

1.       Log into your SQL Server and open SQL Server Management Studio, to where you have your Reporting Services installed.

2.       Then you can run the following query on your ReportServer$InstanceName

Select

                                 [Description]asDataDrivenSubscriptionName

                                ,LastStatus

                                ,ModifiedDateasLastRunDate

from[ReportServer$InstanceName].[dbo].[Subscriptions]with (nolock)

where[Description]=‘Internet Sales – Report Subscription from SharePoint’

a.       NOTE: For the above we used our Data Driven Subscription Name: Internet Sales – Report Subscription from SharePoint

3.       And as you can see below this was our output:

a.       clip_image001[6]

4.       In a future I will explain how to take this output and put it into an email via SSIS so that this can be emailed to you daily.