Logo
banner

Blogs

Power BI > How to identify referenced Measures and Columns in Model – II

, July 8, 2022345 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 more

Power BI > How to identify referenced Measures and Columns in Model – I

, June 24, 20221268 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 more

Embed Power BI reports in Power Apps Portal

, April 8, 20221692 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

Updating the SQL DataSource from Power BI using Power Automate Visual

, August 6, 20212755 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, 20212596 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, 20213054 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, 20219482 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, 202128044 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

Power BI > USERELATIONSHIP Vs. CROSSFILTER

, January 21, 20217022 Views

Power BI has different DAX functions using which we can have our results in many different ways. As far as the result is concerned, it doesn’t matter which road we take to reach the destination but, we would always strive to get the most optimal solution. We often need bi-directional relationships to let the filters […]

Read more

Power BI > How to make PBI Reports pointing to deleted Power BI Dataset working again?

, November 26, 20203365 Views

Recently, we had come across an issue which we thought is very common and is easily resolvable. But, we were highly mistaken. We had several reports which were using a shared Power BI Dataset. We accidentally deleted the dataset on Power BI Service. Naturally, it deleted all the other reports pointing to this dataset. The […]

Read more

Want to know how we can help move your business to cloud? Enter your email address below