Power BI Development Basic Checklist And Recommendation

Posted Posted in Uncategorized, Work

Power BI Development Basic Checklist And Recommendation

This document offers guidance for building fast, robust and attractive Power BI reports. The document contains a checklist for:

  • Data Modelling

  • Visualizations

  • Power BI Site Admin

You can download the document from the below link.

Download checklist now

This document is built by taking reference of books, training, blogs, Videos, and websites etc. Please provide us feedback via email so we can keep an updated checklist.

RDL to RDLC Conversion

Posted Posted in Work

How to convert Rdl to RDLC?

Below is blank RDL or RDLC:

<?xml version="1.0" encoding="utf-8"?>
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
       <Width>6.5in</Width>
       <Body>
              <Height>2in</Height>
       </Body>
       <rd:ReportTemplate>true</rd:ReportTemplate>
  <Page>
  </Page>
</Report>

Comparison

RDL and RDLC – We can use both files in the report viewer. RDLC for client local report and RDL for remote server processing.

Both have same schema as we can see in XML – report definition.

The only Difference is in the data source, RDL is actual data source with the connection string.

RDLC is using dataset and data table to retrieve data from various sources.

Steps:

Steps to convert RDL to RDLC.

  • In report project file – Change extension of report file – rdl to rdlc

Before

After

  • Add existing item in your development project with report viewer:

  • Add dataset with required tables and data and fill the data into dataset

  • Assign data source property to report viewer in C# or VB using below code
DataSource RDS=new DataSource();                   
reportViewer1.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Local;
reportViewer1.LocalReport.ReportPath = "C:\\Users\\RASHIM\\Documents\\Visual Studio 2008\\Projects\\SSRS Test\\SSRS Test\\Report1.rdlc";
reportViewer1.LocalReport.DataSources.Clear();
reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("DataSet1_Employee", dt));
reportViewer1.DocumentMapCollapsed = true;
reportViewer1.RefreshReport();