Category Archives: Power BI
Purchasing a Power BI Premium Node and assigning it to a Workspace
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
Share Story :
Export Power BI DataSet to Excel
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
Share Story :
Power BI new Visual : Ribbon Chart
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
Share Story :
Dynamic URL Filtering on Power BI
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
Share Story :
Dynamic data masking in SQL SERVER
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
Share Story :
PowerBI Visuals: ArcGIS
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
Share Story :
Power BI Tiles Embedded in Dynamics 365 Dashboards
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
Share Story :
Excel Report using SSIS without Physical Mapping
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
Share Story :
Deployment Document: TIBCO Cloud Integration Agent
Introduction: This document contains the steps on how the TIBCO Cloud Integration Agent with custom connector for Dynamics GP can be deployed on server. Install a TIBCO Cloud Integration on-premise agent A TIBCO Cloud Integration agent needs to be installed on the server where the target data store resides. Download TIBCO Cloud Integration agent You … Continue reading Deployment Document: TIBCO Cloud Integration Agent
Share Story :
Power BI Embedded in Microsoft Dynamics 365 Operations
Microsoft power BI is a collection of features and online services that enables you to share your findings, analyse and visualise data in the form of dashboard and reports and the whole process is termed as power bi analytics. Utilizing the Microsoft Power BI Integrations, you can import information that is huge from different sources … Continue reading Power BI Embedded in Microsoft Dynamics 365 Operations