Category Archives: Power BI
Instead of viewing dashboard and report on Power BI Web Service, we can directly view it in CRM. We need to publish the Power BI dashboard to our CRM Environment. This Blog will guide you through it can be done.
In this blog we will learn how to append two or more table into new table or existing table. The Append Queries in Microsoft Power BI is an equivalent of UNION ALL in SQL. Consider two sample customer table; one for CustomerOne: And Customertwo: Open Microsoft Power BI for Desktop > Get Data > Excel … Continue reading Microsoft Power BI – Joining contents of two tables into one table using Append Power Query
This Blog will show you how you can Install and locate your Plugins in XRM new interface.
The following steps are to be followed to register an application entity in Azure Active Directory:- Go to Azure Active Directory and Click on App Registrations. Click on New Registration, Enter a name and the Redirect URL and click Register. Copy and save the Application(client) ID and Tenant ID in a text file. Generate a … Continue reading Register an application entity in Azure Active Directory
Introduction: This blog will show you how you can color individual rows differently based on different conditions and the row headers in matrix (Not alternating rows). Our Scenario: I want to apply colors to different rows of the following Buckets: Current – No Color 1-30 Days Past Due – Yellow 31-60 Days Past Due – … Continue reading Conditional Formatting by Row in a Matrix
In this blog I am going to explain you how to create a Date table in Power BI desktop. A date table is a table that contains one column of DateTime type with unique values. It’s also called CALENDAR table A data model typically contains a date table A date table is designed to slice … Continue reading How to create Date tables in Power BI. Why are they remarkably important in data models?
Power BI Embedded is a Microsoft Azure service that is useful for the ISVs and developers to embed visuals, reports and even dashboard into the application. As Power BI Embedded is a PaaS analytics solution which provide Azure based capacity, Power BI embedded charge customers on an hourly basis there are n annual commitment for … Continue reading Auto scale the Power BI Embedded capacity using Job Scheduler in Azure
In this blog we are going to embed a Power BI report into webpage, to do so below are the steps, 1. Go to https://app.powerbi.com/ and create new report or we can publish already created report, in this case, we have one sample report, which contain three pages Page1: Team Scorecard Page2: Industry Margin Analysis … Continue reading Embedding Power BI reports into Webpages- Part 1
In this blog we going to Set which page to open when the Power BI report is embedded We can do the customization in the embed code as per requirement for the page loading. We have to open the report and click on each page and note down the URL to get page name So … Continue reading Embedding Power BI reports into Webpages- Part 2
In this blog I am going to explain you how to create a custom URL for your text column in Power BI desktop. You can create hyperlinks in tables and matrix in Power BI desktop. Before jumping to use a new feature in Power BI desktop, I am showing you how we had done previously. … Continue reading How to use a Custom URL for your text column in Power BI
The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.