close

How To Publish Reports Using SSRS In Power BI?

Posted by Sas Chatterjee on Apr, 21, 2021 09:04

The SQL Server Reporting Services (SSRS) is a part of Microsoft SQL server services power Business Intelligence (BI) since the year 2000. Every ordinary Microsoft user with the basic knowledge of SQL can prepare reports using SSRS in Power BI using the below-mentioned steps.

Requirements

Before a user starts to use SSRS, the user must ensure that their device meets the following requirements:-

  • Microsoft SQL Server 2014 database engine.
  • SQL Server 2014 reporting service (SSRS).
  • SQL Server Data Tools.
  • Any database to be used as a data source.

Creating a Report Server Project

The steps involved in creating a new report server project and report definition file are:-

  • This starts with opening the SQL Server Data Tools, then click on the File menu, then finding New, and then Project.
  • After this, the user needs to click on the option for Business Intelligence.
  • Then click on the Reporting Services and then Report Server Project.
  • If the user wants to display the Report test project to get started, he or she can type the Report test in the Name option.
  • The last step is to click OK to finish the creation of a new server project.
  • Go to the View menu, the user needs to find the Solution Explorer, and then right-click on the Reports folder. In the Add section, click on New Item.
  • In the window Add New Item, click Report.
  • As you can see Report Designer has two available views. In the Design view, the user needs to define their report layout, and in the Preview view, the user can run his or her report.
Publish Reports Using SSRS In Power BI

Adding Tables and Fields to Report Layout

After completing the technical part, the user can try doing the interesting part of designing the SSRS report which is much easier as compared to the technical part. The steps involved in adding tables and field on the report are:-

  • Firstly in the View menu, click on the option for Toolbox, then find and click the Table option and drag the mouse to the design area of the report.
  • On the left side, the user can expand the dataset of the Dataset1 in order to see all the fields which would be a part of the report.
  • Then the user needs to drag one of the fields ( for instance field Date) from Report Data to the column in the table
  • Similarly, the user can continue adding fields and the table will automatically add more columns.
Report layout in Power BI

Formatting the Report

For formatting the data field to only show the date, the user needs to follow the following steps:-

  • In the Design tab, right-click the desired cell and then click on the option for Text Box Properties.
  • Find and click Number, then in the field Category, choose the option for Date
  • As in the option for Type, the user needs to select the date format which he or she wants, and click OK to finish.

If the report contains information about money which include currency changes as well but the user only finds them as ordinary numbers, he or she needs to follow the following steps to get the number as currency:-

  • In the Design tab, right-click the desired cell, then click on the option of Text Box Properties.
  • Find and click Number, then in the field Category choose Currency
  • In accordance with the needs, the user can change the defaults
  • Click OK to finish.
Formatting the report

Conclusion

The above steps can help the user publish reports using SSRS in Power BI. With proper Microsoft Power BI Training, organizations can learn to create Power BI reports. EPCGroup provides Power BI Consulting services using which organizations can implement BI solutions.

EPC Group Microsoft Gold Partners
[gravityforms id=41 title=”true” description=”false”]
<div class='gf_browser_unknown gform_wrapper exit_intent_popup_wrapper' id='gform_wrapper_41' ><form method='post' enctype='multipart/form-data' id='gform_41' class='exit_intent_popup' action='/how-to-publish-reports-using-ssrs-in-power-bi/'> <div class='gform_heading'> <h3 class='gform_title'>Exit Intent</h3> <span class='gform_description'></span> </div> <div class='gform_body'><ul id='gform_fields_41' class='gform_fields top_label form_sublabel_below description_below'><li id='field_41_1' class='gfield gform_hidden field_sublabel_below field_description_below gfield_visibility_visible' ><input name='input_1' id='input_41_1' type='hidden' class='gform_hidden' aria-invalid="false" value='https://www.epcgroup.net/how-to-publish-reports-using-ssrs-in-power-bi/' /></li><li id='field_41_9' class='gfield gfield_contains_required field_sublabel_below field_description_below gfield_visibility_visible' ><label class='gfield_label' for='input_41_9' >Full Name<span class='gfield_required'>*</span></label><div class='ginput_container ginput_container_text'><input name='input_9' id='input_41_9' type='text' value='' class='medium' placeholder='Full Name' aria-required="true" aria-invalid="false" /></div></li><li id='field_41_6' class='gfield gfield_contains_required field_sublabel_below field_description_below gfield_visibility_visible' ><label class='gfield_label' for='input_41_6' >Email<span class='gfield_required'>*</span></label><div class='ginput_container ginput_container_email'> <input name='input_6' id='input_41_6' type='text' value='' class='medium' placeholder='Email Address' aria-required="true" aria-invalid="false" /> </div></li><li id='field_41_7' class='gfield gfield_contains_required field_sublabel_below field_description_below gfield_visibility_visible' ><label class='gfield_label' for='input_41_7' >Phone<span class='gfield_required'>*</span></label><div class='ginput_container ginput_container_phone'><input name='input_7' id='input_41_7' type='text' value='' class='medium' placeholder='Phone Number' aria-required="true" aria-invalid="false" /></div></li><li id='field_41_10' class='gfield gfield_contains_required field_sublabel_below field_description_below gfield_visibility_visible' ><label class='gfield_label' for='input_41_10' >Company Name<span class='gfield_required'>*</span></label><div class='ginput_container ginput_container_text'><input name='input_10' id='input_41_10' type='text' value='' class='medium' placeholder='Company Name' aria-required="true" aria-invalid="false" /></div></li><li id='field_41_8' class='gfield gfield_contains_required field_sublabel_below field_description_below gfield_visibility_visible' ><label class='gfield_label' for='input_41_8' >Message<span class='gfield_required'>*</span></label><div class='ginput_container ginput_container_textarea'><textarea name='input_8' id='input_41_8' class='textarea medium' placeholder='Type your message here...' aria-required="true" aria-invalid="false" rows='10' cols='50'></textarea></div></li> </ul></div> <div class='gform_footer top_label'> <input type='submit' id='gform_submit_button_41' class='gform_button button' value='Submit' onclick='if(window["gf_submitting_41"]){return false;} window["gf_submitting_41"]=true; ' onkeypress='if( event.keyCode == 13 ){ if(window["gf_submitting_41"]){return false;} window["gf_submitting_41"]=true; jQuery("#gform_41").trigger("submit",[true]); }' /> <input type='hidden' class='gform_hidden' name='is_submit_41' value='1' /> <input type='hidden' class='gform_hidden' name='gform_submit' value='41' /> <input type='hidden' class='gform_hidden' name='gform_unique_id' value='' /> <input type='hidden' class='gform_hidden' name='state_41' value='WyJbXSIsIjEwNTJhNGVmMWMyNzI3YTJmMjdiZTA1NjU4ZDMzYzY3Il0=' /> <input type='hidden' class='gform_hidden' name='gform_target_page_number_41' id='gform_target_page_number_41' value='0' /> <input type='hidden' class='gform_hidden' name='gform_source_page_number_41' id='gform_source_page_number_41' value='1' /> <input type='hidden' name='gform_field_values' value='' /> </div> </form> </div><script type='text/javascript'> jQuery(document).bind('gform_post_render', function(event, formId, currentPage){if(formId == 41) {if(typeof Placeholders != 'undefined'){ Placeholders.enable(); }jQuery('#input_41_7').mask('(999) 999-9999').bind('keypress', function(e){if(e.which == 13){jQuery(this).blur();} } );} } );jQuery(document).bind('gform_post_conditional_logic', function(event, formId, fields, isInit){} );</script><script type='text/javascript'> jQuery(document).ready(function(){jQuery(document).trigger('gform_post_render', [41, 1]) } ); </script>