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:
Power BI Site Admin
You can download the document from the below link.
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.
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">
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 to convert RDL to RDLC.
- In report project file – Change extension of report file – rdl to rdlc
- 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.Add(new Microsoft.Reporting.WinForms.ReportDataSource("DataSet1_Employee", dt));
reportViewer1.DocumentMapCollapsed = true;