Wednesday, April 26, 2017

Vertical alignment property of Text is missing in Report Builder 3

The latest Report Builder v3 used with SQL Server Reporting Services has the vertical alignment property missing. In order to have proper formatting, this property should be back in Report Builder.




Sunday, April 23, 2017

KanaType and KanaType sensitvity in SQL Server

This is specifically for data in Japanese language databases. There are two types of Japanese phonetic scripts, the Hiragana and the Katakana. Of course there is also the Kanji which are modified/simplified Chinese characters used in Japan together with Hiragana and Katakana.

While dealing with Japanese data Kanatype is used to distinguish between Katakana and Hiragana. Katakana is usually used for words not found in Japanese, like, Bus, Laser, harassment etc.


For example, the 'dataset' in Reporting Services have this property:

DataSetDefinition.KanatypeSensitivity

Here is a piece of text in Hiragana
ふるい もの の なか に ある かくれた うつくしさを 「さび」 と いいます。 また、かざらない そぼくな うつくしさ を 「わび」 と いいます。ふたつ を あわせて、「わび・さび」 と いいます。

Source:     http://gakuu.com/haikyo-hiragana-reading-practice/

Here is a piece of text in Katakana

The same text written in Katakana using online translator:
フルイ モノ ノ ナカ ニ アル カクレタ ウツクシサヲ 「サビ」 ト イイマス。 マタ、カザラナイ ソボクナ ウツクシサ ヲ 「ワビ」 ト イイマス。フタツ ヲ アワセテ、「ワビ・サビ」 ト イイマス。

Source:  en.calc-site.com/letters/convert_kanaen.calc-site.com/letters/convert_kana

Monday, April 17, 2017

Saving Power BI reports to SQL Server Report Server - Part 3

The readers of my posts Saving Power BI reports to SQL Server Report Server - Parts1 and  2
  might have been under the impression that any report created in Power BI can be hosted on the Report Server. I am partly to blame for this and I apologize. Let me correctly present what kinds of reports can be saved to what kind of report server. The other reason for the problem was created by the Power BI itself for giving the wrong guidance for the users. It must be changed.

The only kind of reports that can be saved to Report Server (in fact you are only saving it to the Web Portal URL) are the ones created with data from the Analysis Services server.

In order to save you need to configure a stand-alone Report Server whose database is stored not on a SQL Server 2016 but an earlier version. In my case I use the SQL Server 2012.

After you fulfill the above conditions then only you can host the report.

I was able to get the correct server by an answer to my question on StackOverflow.com.

http://stackoverflow.com/questions/43402339/invalid-url-error-while-saving-power-bi-report-to-sql-server-reporting-services







Sunday, April 9, 2017

Saving Power BI reports to SQL Server Report Server - Part 2

In an earlier post the method to save a report from Power BI to SQL Server Report Server was described. In order to do so you need to use the Technical Preview of Power BI Desktop.

In this post the installing of the Technical Preview will be described. The present Windows 10 Professional is a x64 bit machine and therefore we start with the .msi file shown here.
PBIDesktopRS_x64.msi

When you double click the above file you will be launching the wizard.


Click Next> to open the License Terms window.


Accept terms and click Next>. The default directory for the program is displayed. If needed change. Herein default is accepted.


Click Next>.  You are now ready to Install.


Click Install. It is installed. It may take 10 to 15 minutes.


Click Finish and if you have agreed to launch the program, the Power BI gets launched.The splash screen shows that this Power BI Desktop goes with SQL Server Reporting Services.



The program is now ready to create/save reports.

 NOTE: If you already have configured a SQL Server 2016 Reporting Services server you will not be able to upload the reports from Power BI. You need to install the SQLServerReportingServices.exe mentioned in previous post and configure a Standalone SQL Server Reporting Services which will provide a http://<domain>/ReportServer.

Saturday, April 8, 2017

Saving Power BI reports to SQL Server Report Server

If you use the Technical Preview version of Power BI Desktop. You can save reports to your on- premises SQL Server.

NOTE: If you already have configured a SQL Server 2016 Reporting Services server you will not be able to upload the reports from Power BI. You need to install the SQLServerReportingServices.exe mentioned below and configure a Standalone SQL Server Reporting Services which will provide a http://<domain>/ReportServer.

You can download this for both x32 and x64 versions. With this you can,


  •     Connect “live” to Analysis Services models – both Tabular and Multidimensional (cubes)
  •     Visually explore data and create an interactive report
  •     Save that report to your report server running the Technical Preview
  •     View and interact with the report in your web browser

If you do have Power BI for Desktop on your computer you still need the (January 2017) Technical Preview. This can sit alongside your present Power BI.
=====================
Technical Preview of Power Bi for Desktop download link
https://www.microsoft.com/en-us/download/details.aspx?id=54610
=====================
Preview version details below:
Version:            Date Published:

0.1                1/11/2017

File Name:                                                               File Size:

PBIDesktopRS.msi                                      102.2 MB

PBIDesktopRS_x64.msi                           118.3 MB

SQLServerReportingServices.exe    49.6 MB



System Requirements:
Supported Operating System

Windows 10 , Windows 8, Windows 8.1, Windows Server 2012, Windows Server 2012 R2, Windows Server 2016

    You'll need
        .NET Framework 4.5.2 or later
        SQL Server Database Engine (2008 or later), to store the report server database
        SQL Server Analysis Services (2012 SP1 CU4 or later), to store your data models
    Links:
        Get SQL Server 2016 Evaluation
        Try SQL Server vNext CTP1.1









Wednesday, April 5, 2017

New in SQL Server 2016 Reporting Services: File Share

This is feature is applicable only for Native Mode.

In order to specify a single file share account ( a new feature of SQL Server 2016) you must get to the Subscription Settings page of the SQL server 2016 Reporting Services Configuration Manager shown here.


The file share account that you set up here allows you to set a single set of credentials in multiple subscriptions that deliver reports to a file share.

When you want to change credentials you just change the credentials of the file share and you need not change the credentials of every subscription in the shared folder. In the subscriptions in the file share each subscription will specify; Use file share account.

However you may also configure individual subscriptions with specific credentials as well or, have some on file share and some with individual specific credentials.

Uploading a Moble report to a Report Server

This post is about displaying a Mobile Report created by the SQL Server Mobile Report Publisher after publishing the report to a SQL Server Reporting Services which is actually the Web Portal URL of the Reporting Services.

The present Reporting Services configuration is pertinent to SQL Server 2016 Reporting Services on the local machine.

While it should also be possible to publish it directly from the SQL Server Mobile Report Publisher, it was not possible because there were errors connecting to the Report Server although the SQL Server 2016 Database Engine; the Reporting Services were all up and running and an empty folder 'Reports' was created on the Web URL. I have not tried to verify the problem yet. This could be because of the constant upgrades coming to the OS automatically.

In this post, I consider uploading a report to the Web Portal URL after saving the file created by the SQL Server Mobile Report Publisher to a local folder.

You need to make sure the Reporting Services database is accessible which the same as the SQL Server Database Engine  running; the Reporting Services has started and the Service and Web Portal URL have no problems.

Then use the Upload button on your Web Portal URL to upload the report created and saved (to local file system) to the computer. Once it gets uploaded the report gets into the WEB Portal URL as shown.




The Northwind Report has three charts, the creation of one of them is detailed in my earlier post here. I have just added two more grid items this upload.




You can view each of them on the WEB Portal URL as well as shown here.


http://hodentek8/Reports_OHANA/mobilereport/Northwind

Herein http://hodentek8/Reports_OHANA is my Web Portal URL.