If you are wondering when to use USERNAME() and USERPRINCIPALNAME() in RLS  for Power BI Embedded scenarios, then you are on the right blog.

Learn how to use the Tabular Editor to perform advanced data modeling techniques not available when working with Power BI Desktop. Michael Kovolsky will introduce the Best Practice Analyzer and discuss how to use this powerful tool to scan your Power BI data model to find areas for improvement.

Do you every dream of becoming the Heavy-weight Power Query Champion of the World? Join our Power BI Dev Camp session on March 25th for a fast-paced primer on the fundamentals of the M programming language. The goal of this deep dive session is to give campers a stronger foundation for working directly with M code in the Advanced Editor when designing queries for datasets in Power BI Desktop or when designing queries for dataflows in the browser.

What's on tapfor Power BI Dev Camp in February? We'll be looking at developing web applications using .NET 5, Azure AD and the App-Owns-Data embedding model in Power BI. Campers will get increasingly excited as the learn how to implement App-Owns-Data embedding in a custom .NET 5 web application which involves first calling the Power BI Service API and then afterwards calling the Power BI JavaScript API with client-side code in the browser to complete the embedding process.

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 be a lot of measures to move from one file to another. Copying and pasting measures one by one can be a test from hell. It is a wolf in sheep’s clothing. It takes your efforts as well as your time.

So how to do it at one go? 

Here is the solution for it!

You will need an external tool Tabular Editor for this. If you already don't have it, then please install it first.

You can visit the Tabular Editor website to download the latest installer.

You will then have 2 running instances of Power BI Desktop on your PC as you need to open both the pbix files at the same time. Make sure you are clear which file is which. Just rename your files for better understanding.

Here I have 2 files one is ‘Employee_details with Measures’ and another is  ‘Employee_details without Measures’.

Launch Tabular Editor for both PBIX files

Go to each file, one at a time, and launch Tabular Editor. Do it carefully, one at a time, ensuring you understand which model belongs to which PBIX file.

Copy the Measures

If you can’t see measures in the source file, make sure they are not hidden.
In Tabular Editor, from the View menu, select Measures. We can see that the measures are visible in the ‘Employee_details with Measures’ file shown in the image below(left side).

In our case, all the measures exist in the _Measure Table.

Below are the steps to copy measures from one file to another:

• Select all measures from the list you want to copy.
• Copy the measures. Press Ctrl+C.
• Switch to the second instance of Tabular editor(one that’s not having measures)
• Select the destination table to store the measures.
• Paste the measures. Press Ctrl+V.

Click save on Tabular Editor in the destination workbook.

After saving the destination model, you will be able to see all the measures in the destination file.

Happy Reporting!

Context transition -  one of the most complex topics to understand and master but have you ever wondered, what actually happens behind the scenes? To be honest at least for me the behind the scene stuff is much more clear and easy to understand and here is why.

Everyday Power Bi Desktop is making the cleaning and transformation of data easier. We can do great thing with one click over a button in edit queries window. This is awesome, but it can mess your solution.

Maybe we have made the desired table but that doesn't mean we are using applying the best methods or ways to get there. We can be adding a lot of complexity and problems with all those clicks from an operative standpoint.

In this article I'll try to share all the good practices I try to apply on every Power Bi Desktop Solution I make.

Dataset refresh failure with 'The key didn't match any rows in the table.' error even though the data source connection under Manage Gateways was successful. The data source was SQL Server.

Step up your game as a Power BI developer by learning how to develop single page applications (SPAs) to embed Power BI reports and dashboards using the ever-popular React.js library. If you're able to attend the December session of Power BI Dev Camp on Thursday, December 17th, you'll learn how to design and develop SPA applications using React components to handle routing, navigation and Power BI embedding.

When Data has been provided between the start date and end date. Output needs to be viewed by month or period. 

Customers ask you to show total values in a bar-chart for all years along with each year individually.

WordCloud custom visual in Power BI gives a great way to visualize the most occurring words in the data. The size of the word depends on how frequently it appeared in the data-set. One can limit the number of words to be displayed in WordCloud. The defualt setting displays 200 words in this visual.

But, have we ever thought of modifying this word limit without changing the underlying word-limit setting in the visual. Basically creating a slicer in the report and then changing the number of words to be displayed in the WordCloud.

This article here gives a workaround on how one can achieve this functionality in Power BI.