Category Archives: Power BI
Hide Report page in Power BI report
With Power BI latest release, you can now hide the page in Power BI reports, this page is available while you are developing and when you hide it by right click on the package and selecting Hide Page, then that page will not be available in Reading mode. When you select the Hide page option … Continue reading Hide Report page in Power BI report
Share Story :
SQL Server 2017 | New function : TRIM
TRIM Function has haunted SQL DBA for ages. If you have been using SQL Server for a while, you will totally agree with me over here. In this blog post we will see how the new feature TRIM of SQL Server 2017 works in few simple words. SQL Server DBAs and Developers have always dealt … Continue reading SQL Server 2017 | New function : TRIM
Share Story :
Power BI New Update : Responsive Slicers, Field properties pane and field descriptions.
Introduction: The field properties pane allows you to change the name and description of a field from your fields list. Responsive slicers are the latest update to responsive visuals work. Responsive slicers: Responsive slicers are the latest update to responsive visuals work. With responsive slicers, you can resize them to a variety of different sizes … Continue reading Power BI New Update : Responsive Slicers, Field properties pane and field descriptions.
Share Story :
Narratives for Power BI
Introduction: Narratives for Power BI is a product that automatically delivers dynamic narratives that explain the insights within your data. No more manually writing explanations and spending time interpreting data. Instead, the narratives, which are powered by advanced analytics, are perceptive and dynamic and explain what is most interesting and important in your data. Drill … Continue reading Narratives for Power BI
Share Story :
Filtering duplicate records in SSIS
Introduction: In this blog, I will demonstrate how to remove or filter duplicate records in SSIS using Sort Tranformation. Steps: First, configure you OLE DB as your Source using the OLE DB Source as shown below. Bring the Sort Transformation and configure it as shown below. Check the box at the bottom of the Window … Continue reading Filtering duplicate records in SSIS
Share Story :
How to split an ‘Address’ column into multiple columns in SSIS
Introduction: We can split an Address column into multiple columns for Flat Number, Building, Road, City etc. in order to make it easier to process the data. In order to do this, we can use the Derived Column Transformation in SSIS. Steps: In the screenshot below, you can see the Address column has an aggregated … Continue reading How to split an ‘Address’ column into multiple columns in SSIS
Share Story :
Analysis Services Live Connection in Power BI
Introduction: In this article, we will learn how to configure Live connection for Analysis Services in Power BI. Requirements: Power BI Licence SQL Server Analysis Service Power BI Gateway (Refer this link to configure Power BI Gateway) Steps to Connect Analysis Services Live in PowerBI Open PowerBI Desktop Click Get Data and Select Analysis Services … Continue reading Analysis Services Live Connection in Power BI
Share Story :
SQL Live Connection in Power BI
Introduction: In this article, we will learn how to configure Live connection for SQL in Power BI. Requirements: Power BI Licence SQL Server Database Engine. Power BI Gateway (Refer this link to configure Power BI Gateway) Steps to Connect SQL Live in PowerBI: Open PowerBI Desktop Click Get Data and Select SQL Server. In the … Continue reading SQL Live Connection in Power BI
Share Story :
November 2017 Updates for PowerBI Desktop
Introduction: In this blog article, I will talk about the November Updates for PowerBI Desktop. Conditional Formatting based on Rules: You can now set the colour of the text based on a predefined rule depending on your business logic. This enables you to colour-code your data based on a set of rules that you set … Continue reading November 2017 Updates for PowerBI Desktop
Share Story :
Analysis Services Connection Configuration in Power BI for Live Connection
Introduction: In this article, we will learn how to successfully connect to Analysis Services in Power BI for Live Connection. Checklist for Connection: The Domain Account must be a Server Admin in Analysis Server. Right Click on the Analysis Server > Select Properties > Select Security > The domain account must be added/present here. … Continue reading Analysis Services Connection Configuration in Power BI for Live Connection