Power BI Archives | Page 10 of 18 | Cloudfronts - Microsoft Dynamics 365 | Power BI | Azure - Page 10

Category Archives: Power BI

Filtering duplicate records in SSIS

Posted On December 29, 2017 by Simran Monteiro Posted in Tagged in ,

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

Posted On December 29, 2017 by Simran Monteiro Posted in Tagged in , ,

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

Posted On December 1, 2017 by Admin Posted in

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

Posted On December 1, 2017 by Admin Posted in

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

Posted On November 24, 2017 by Admin Posted in

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

Share Story :

Steps to configure Power BI Gateway

Posted On November 24, 2017 by Admin Posted in

Introduction: In this article, we will learn how to configure Power BI Gateway. Steps to configure Gateway Login to Power BI service. Select Downloads icon> Data Gateway. You will be redirected to Power BI Gateway Download Page and click Download Gateway. Run the PowerBIGatewayInstaller. Click Next and then Install. The Power BI Gateway will be Installed. … Continue reading Steps to configure Power BI Gateway

Share Story :

DLL Deployment Error on Scribe On-Premise Agent Server

Posted On November 24, 2017 by Admin Posted in

Introduction: Recently, we encountered a strange behavior of Scribe On-Premise Agent when we deployed a DLLs for a Custom Connector. After deployment of DLLs on the Agent, the status of the Scribe Agent was stuck at “Updating” and the Connector was not visible under the connector drop down. Troubleshooting: We checked the “MICROAGE1 Agent 2” Agent … Continue reading DLL Deployment Error on Scribe On-Premise Agent Server

Share Story :

Publish Workbook to Power BI from Excel File

Posted On November 13, 2017 by Jayant Patel Posted in

With Excel 2016, you can publish your Excel workbooks right to your Power BI site, where you can create highly interactive reports and dashboards based on your workbook’s data. You can then share your insights with others in your organization. Requirements: 1. Before publishing to Power BI, workbook must be saved to OneDrive for Business. 2. Only … Continue reading Publish Workbook to Power BI from Excel File

Share Story :

Import Excel Workbooks in Power BI Dashboards

Posted On November 9, 2017 by Jayant Patel Posted in

Yes, you heard it right, you can import Microsoft Excel Workbook to Power BI and show you selected section in you powered dashboards, let’s see how it works, as Microsoft Excel is one of the most widely used business applications around. It’s also one of the most common ways to get your data into Power … Continue reading Import Excel Workbooks in Power BI Dashboards

Share Story :