Category: Power BI
Power BI > Accessibility of reports published in same app workspace
Inkey, November 4, 2022644 Views
Usually, Power BI Reports are shared with users by giving them access to the App Workspace where we have reports published. So, when we have 2 groups of users – let’s say, Manager and Salesperson. And there are 2 sets of reports, Set1 & Set2, where Set1 is to be shown only to Salesperson, and […]
Read morePower BI > How to identify referenced Measures and Columns in Model – II
Inkey, July 8, 20221205 Views
In the earlier blog post, we stated how to identify referenced measures or columns, i.e. whether they are used in other measures or not. If you haven’t visited the blog post, please click here. It is a very useful blog, especially in the big Power BI models. But this won’t be helpful when we would […]
Read morePower BI > How to identify referenced Measures and Columns in Model – I
Inkey, June 24, 20223481 Views
Most of the time, while updating the existing model, it’s hard to identify which measures or columns are being used in report visualization and which are referring to other measures or columns. Many times, while developing a report, there are frequent changes in the requirements and we need to modify/update the data model accordingly, which […]
Read moreEmbed Power BI reports in Power Apps Portal
Inkey, April 8, 20222730 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 morePower BI > How to deal with a Text column having a length of more than 32766 characters.
Inkey, April 1, 20228989 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 morePower BI > Using slicer for just highlighting values without filtering
Inkey, December 20, 20215220 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 morePower BI > Drill-through feature from Card visual
Inkey, November 19, 202111730 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 morePower BI > How to filter all the data by TODAY, by default?
Inkey, September 10, 202112219 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 moreUpdating the SQL DataSource from Power BI using Power Automate Visual
Inkey, August 6, 20214355 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 moreCalculation Groups in Tabular Editor
Inkey, June 11, 20213244 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