› BI

Category Archives: BI

Purchasing a Power BI Premium Node and assigning it to a Workspace

 Shannon Pereira   Leave a comment

Introduction: In this blog we will discuss the different Power BI Premium Capacity nodes available and the steps to purchase these. We will also discuss how to assign a premium node to a workspace in Power BI. Power BI Capacity Based SKUs: There are 3 categories of SKUs that can be purchased which gives us … Continue reading Purchasing a Power BI Premium Node and assigning it to a Workspace

Export Power BI DataSet to Excel

 Jayant Patel   Leave a comment

Introduction: There are times when you may want to use Excel to view and interact with a dataset that you have Power BI for quick stretching of data slice and dice. Few people feel comfortable with excel PivotTable and PivotCharts, so by using Analyze in Excel, you can do just that, and access PivotTable, chart, … Continue reading Export Power BI DataSet to Excel

Power BI new Visual : Ribbon Chart

 Sachin Dabre   Leave a comment

Introduction: In this blog article, we will explain about the new Visual of Power BI: Ribbon chart! Ribbon Chart: The visual is like a stacked column chart, but each column’s inner categories are sorted according to their rank for that column. Additionally, the inner categories are connected by ribbons across the columns. Refer below Screen … Continue reading Power BI new Visual : Ribbon Chart

Dynamic URL Filtering on Power BI

 Shannon Pereira   Leave a comment

Introduction: There may arise a situation where we may want to link one report to a more detailed report dynamically in Power BI. Although we can link dashboards to reports and also provide a custom link for a tile in a dashboard, report to report linkage is currently not a feature available in Power BI. … Continue reading Dynamic URL Filtering on Power BI

Dynamic data masking in SQL SERVER

 Jayant Patel   Leave a comment

In our day to day life we are more concern about our data security and sensitive information’s when we fill out some purchase form and other billing application which requires your Credit card and other personal information. This data can be viewed easily in the backed users if it’s not secure controlled. SQL Server 2016 … Continue reading Dynamic data masking in SQL SERVER

PowerBI Visuals: ArcGIS

 Simran Monteiro   Leave a comment

Introduction: In this blog article, I will demonstrate how to enable ArcGIS in PowerBI, its features and how to use it to display data. The ArcGIS Visual, created by Esri, displays data in a unique and immensely customisable way. The Visual allows the User to select the type of map, various ways to represent data … Continue reading PowerBI Visuals: ArcGIS

Power BI Tiles Embedded in Dynamics 365 Dashboards

 Anjali Hemmadi   Leave a comment

Introduction: In this article, we are going to learn how to embed Power BI Tiles in your Dynamics 365 / CRM Dashboards. Steps: Sign-in to Microsoft Dynamics 365 as a user with the system administrator security role Go to Settings > Administration > System Settings. On the Reporting tab in the Allow Power BI visualization … Continue reading Power BI Tiles Embedded in Dynamics 365 Dashboards

Excel Report using SSIS without Physical Mapping

 Jayant Patel   Leave a comment

Introduction: In this article, we will see how we can generate Excel Report in SSIS without doing Physical mapping. Steps: 1.    Create Excel file with one data connection in the Excel Sheet. 2.    Create a sheet in Excel pointing to the data connection. This will lead to point the connection to the data source, and help … Continue reading Excel Report using SSIS without Physical Mapping

Deployment Document: Scribe Online Agent

 Sachin Dabre   Leave a comment

Introduction: This document contains the steps on how the Scribe Online Agent with custom connector for Dynamics GP can be deployed on server. Install a Scribe Online on-premise agent A Scribe Online agent needs to be installed on the server where the target data store resides. Download Scribe Online agent You can download and setup … Continue reading Deployment Document: Scribe Online Agent

Power BI Embedded in Microsoft Dynamics 365 Operations

 Anjali Hemmadi   Leave a comment

Introduction: In this article, we will see how to embed Power BI in Microsoft Dynamics 365 Operations. Steps: Register your Dynamics 365 Operations as a web app on Azure AD. Open link: http://dev.powerbi.com/apps Login to your Power BI account Fill the required details: App Name App Type: Select as ‘Server-Side Web app’ Enter a redirect … Continue reading Power BI Embedded in Microsoft Dynamics 365 Operations