Please Vote on Microsoft Connect Items

I’ve posted two feedback items on the Microsoft Connect today, suggesting feature enhancements to Power View and Reporting Services.  If you think these capabilities would be important, I encourage you to follow the links below to the Microsoft Connect site and vote on these items.

Power View reports can be published to SharePoint in a couple of different ways with some inconsistent behavior

https://connect.microsoft.com/SQLServer/feedback/details/779456/publish-or-save-rdlx-from-xlsx-files

Publish or save RDLX from XLSX files

In order to give user a consistent experience in SharePoint, we need to be able to publish Power View reports as separate documents if they were authored in Excel. As it stands, a PowerPivot model can be published and then Power View reports are created separately. Each reports has multiple views that can be exported as a single PowerPoint presentation.
If a user were to author a PowerPivot model and Power View reports using the respective Excel 2013 add-ins, and then publish that xlsx document to SharePoint, consumers will have a different experience all together. This is inconsistent and confusing.  If the reports could be saved from Excel as separate RDLX files, they could then be published separately.

I suggest the following capabilities:

– Save RDLX files from Excel 2013 to separate files
– Save all Power View reports in an XLSX to a different views in a single RDLX file
– Extract the RLDX content during publishing and deploy it as a single Power View report with multiple views.

 

Reporting Services URL string limit:

Reporting Services has a URL command limitation that vary a little because of the URL limits of browsers and web servers.  In most cases, the limit is 260 characters which doesn’t give you much opportunity to pass in multiple parameter values.  This is especially true for multi-value report parameters.  Internally, SSRS uses stored parameters to pass values for report actions.    When a report action is used, all of the parameter values are actually written to the report server content database and an ID is used to pass the request token to the target report.  If we could utilize that same mechanism for URL actions, we could work-around this limitation.

https://connect.microsoft.com/SQLServer/feedback/details/779454/use-stored-parameters-to-work-around-url-size-limit

Use stored parameters to work-around URL size limit.

Per feedback item #752496 (which has received no response), please enable to ability to set stored parameters for a report execution to allow a report to run with a URL request. There are several common scenarios (such as working around the lack of a linked report feature in SharePoint) that would need to support multiple parameter values being passed in a URL request. This has been a known , serious limitation for a long time. Now that integrated mode is the recommended method for delivery RS reports, this capability is absolutely critical.

6 thoughts on “Please Vote on Microsoft Connect Items

  1. Hello, I think your blog might be having browser compatibility
    issues. When I look at your blog site in Safari, it looks fine but when opening
    in Internet Explorer, it has some overlapping.
    I just wanted to give you a quick heads up! Other then that, great blog!

    Like

    • Thanks for letting me know. Although I can’t reproduce the problem you are describing in IE, I’ll keep an eye out for page rendering problems. I’ve generally had a very good experience with rendering quality since moving this blog to WordPress several years ago.

      Like

  2. Provisionary officer deals with all banking important tasks.
    * FOR PRACTICE — Upkar’s Bank Probationary Officers examination preparation book. These connections allow people to share ideas, data, products and services, even information like this article or just to let all of your followers know that you just woke up.

    Like

  3. I know this if off topic but I’m looking into starting my own blog and was curious what all is needed to get set up? I’m assuming having a
    blog like yours would cost a pretty penny? I’m not very web smart so I’m
    not 100% sure. Any tips or advice would be greatly appreciated. Many thanks

    Like

    • There are several blog hosting services that are free or very inexpensive; like WordPress and BlogSpot. I personally prefer WordPress. You can setup a free blog if you’re OK with the domain name they assign you and can put up with a little bit of advertising. You can start there and then upgrade to a paid service later if you like with your own domain and more control over the content. Just go to WordPress.com to investigate the options. I like to use Windows Live Writer to compose and post, rather than the web-based form offered through WordPress. It’s a free app that’s part of the Windows Live Essentials collection from Microsoft: http://windows.microsoft.com/en-US/windows-live/essentials-home
      Good luck and happy blogging.

      Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s