Logo
banner

Blogs

Embed Power BI reports in Power Apps Portal

, April 8, 2022419 Views

We can now embed Power BI Dashboard/Reports in PowerApps Portal with few easy steps. Prerequisite:-    D365 Customer Service organization having a Global user with D365 and Power BI license. ENABLE POWER BI VISUALIZATION  In the PowerApps select the environment where you have provisioned the Portal. Go to Your Apps section from Power Apps home page and locate […]

Read more

Power BI > How to deal with a Text column having a length of more than 32766 characters.

, April 1, 2022338 Views

Power BI supports up to 32766 characters of data in a column of TEXT Data Type. What if we have more data stored in the data source? Recently, we came across a requirement where we had to show the content of an email in HTML format in the Power BI report. The report was built […]

Read more

Power BI > Using slicer for just highlighting values without filtering

, December 20, 2021923 Views

The general purpose of slicer visual in Power BI is to filter the data points in the report and view only the filtered information. They provide options (single or multiple) to a user, to click on & filter the visuals on the page.  Recently, in one of our projects, we were tasked with a requirement to highlight the bars of a bar chart instead of filtering the visual based on the selected value of the slicer. It sounded odd at first […]

Read more

Power BI > Drill-through feature from Card visual 

, November 19, 20213103 Views

In Power BI, a drill–through feature permits the report consumer to peer detailed facts associated with the primary page in the context of a particular  data point applied.  With drill via Power BI reports, one  can  create a  detailed  report  page on your  data  that  focuses on a  particular applied data point.  When the readers want to analyze a particular record or data point […]

Read more

Power BI > How to filter all the data by TODAY, by default?

, September 10, 20214012 Views

Ever wondered how we can filter the Power BI report to show only Today’s data by default but at the same time give the flexibility to change the Date filter? The approach we as developers generally take is – create a calculated column IsToday in the Calendar table and have it return “Yes” for today’s […]

Read more

Updating the SQL DataSource from Power BI using Power Automate Visual

, August 6, 20211416 Views

Ever thought of manipulating the data in your SQL data source directly from the Power BI Report? If yes, our prayers have been heard (as the use of Power Automate within Power BI is still in Preview as of writing this blog) and will be answered soon (when made GA)! An exciting new feature was […]

Read more

Calculation Groups in Tabular Editor

, June 11, 20211880 Views

Consider a scenario where your measure’s definitions are the same but the only difference is the base measures. For example, while doing time-related calculations like MTD, YTD, QTD for 3 different calculations/measures, we need to create 3 measures for MTD, 3 measures for YTD, and 3 measures for QTD, resulting in total 9 measures such […]

Read more

Power BI > Embed Dashboard/Report in D365 Sales with RLS – 5

, April 30, 20212415 Views

There are various approaches to embed Power BI Dashboard/Report in D365 Sales, but each approach comes with its own drawbacks and cons that might not complement your requirements. Earlier we have posted blogs that describe the 4 approaches but as I said they have their own pre-requisite and cons. With the advancements of Power BI […]

Read more

Power BI > Get Data from OneDrive for Business (Folder as a source)

, March 12, 20216351 Views

Power BI supports many data sources from where we can fetch data, but many times, we need to use some workaround to fetch data from certain data sources. One such case is to get data from a folder on OneDrive. There are no in-built data connectors available in Power BI Desktop using which we can […]

Read more

Power BI > How to easily copy Measures from one pbix file to another?

, February 5, 202117749 Views

Have you ever questioned if it is feasible to move all of the measures from one Power BI PBIX file to any other PBIX file? Imagine you’ve got 2 PBIX files with the same models, i.e all tables used in the measures have the same data structure. If someday you are in this position then there will […]

Read more