Tips and Tricks to Merge Two Power BI Reports

As of software development there is no version control and TFS or Git for Power BI to work multiple data analyst or Power BI engineer on same file at a time. On the other hand, we may need to finish design on time, and more than single Power BI Engineer need to work in same Power BI reporting project at the same time. For such … Continue reading Tips and Tricks to Merge Two Power BI Reports

What is Blockchain

Background In centralized database system, it is easy to control access and consistency where everyone is using same database. Additionally, in centralized database there is a central trusted authority to control the access because there is only one database and all participants or clients using same set of data. It should be trusted by all the participants or clients that the owner of database never … Continue reading What is Blockchain

Publish Power BI Paginated Report To Power BI Service Cloud and On-Premises

Introduction Power BI Report Builder is a standalone tool to design paginated reports for Power BI. In previous article, we have learnt what is Power BI Report Builder and how to design paginated report for Power BI. This article will describe steps to publish power BI paginated report to Power BI Service cloud and Power BI on-Premises which is known as Power BI Report Server … Continue reading Publish Power BI Paginated Report To Power BI Service Cloud and On-Premises

What is Power BI Report Builder And How to Design Paginated Report Using Power BI Report Builder

Introduction This article describes what is Power BI Report Builder and how to get started with Power BI Report Builder to design paginated report. In this article I will describe about power BI Report Builder, it is purpose and steps to build report using it with an example. We will use SQL Server Database as data source in the demonstration to design report. Prerequisites SQL … Continue reading What is Power BI Report Builder And How to Design Paginated Report Using Power BI Report Builder

How to Show Filter pane in Power BI Desktop

This blog describes how to show and hide filter pane in Power BI Desktop report designing tool. If the filter pane is not available by default in your existing report file and now you need to show the pane you can follow this blog as well as it helps you to hide or show filter pane to the report users. Steps to turn on filter … Continue reading How to Show Filter pane in Power BI Desktop

How To Import Or Restore BACPAC File Using SQL Server Management Studio?

Introduction  Backup package (BACPAC) contains schema and data for SQL Server database. We can export the database into BACPAC and import it in new environment as a new database. This can be used as per our convenience to migrate data from one environment to another or one SQL Version to another. This restore option has become best choice for Database Administrator and developer for migration … Continue reading How To Import Or Restore BACPAC File Using SQL Server Management Studio?

What are the Options for Database Backup and Restore? How to Export BACPAC using SSMS?

Background  Developers use one database to develop the solution and then need to create another environment such as Testing and Production. Once everything is ready in a development environment, we need to deploy it for a testing or staging environment. To deploy the application from one environment to another, we need to create a database or deploy a database too. We may need the same … Continue reading What are the Options for Database Backup and Restore? How to Export BACPAC using SSMS?

How to Publish Report from Power BI Desktop to Power BI Service?

Introduction Once we develop or design the Power BI reports using Power BI Desktop, we need to publish it and share with the user. This article describes how to publish Power BI reports to Power BI Service online with necessary steps and guidelines for deployments of reports to Power BI Service. Mainly, this article explains the steps to publish reports from Power BI Desktop to … Continue reading How to Publish Report from Power BI Desktop to Power BI Service?

How to Configure Power BI Report Server

Introduction Many organizations are reluctant to go to cloud environment due to various reasons such as data privacy, security, compliance or data-sovereignty and data sensitivity. Power BI Report Server is best option for those who has compliance issue to keep their data in the cloud or Power BI online and want to use Power BI reports for reporting, business intelligence and data analysis. In previous … Continue reading How to Configure Power BI Report Server