In many opportunities the most important thing for the users is the privacy. Knowing who can see what. Those scenarios usually follow two rules. From one hand avoiding access to a full report and on the other hand avoid read access to a specific page of the report and rows. What would happen if they want them both in the same report? I have seen Microsoft recommendations and many users talking about connecting a new blank report to the dataset and just copy the pages that the user should see. However, that's not a very good solution because each modification you have for the report you must do it twice. That's two reports and not even one with an admin permission to see all pages and a regular permission to just see one or two pages. This will become even more complicated if you have more than 2 types of users. You should build new reports for each of them.
This article will help us to handle page navigation permission with RLS. The solution might be similar to dynamic RLS solutions like this blog post.
Looking for a way to surface Power BI reports on pages in a Salesforce organization? This session will teach you how to embed reports in Salesforce using either User-Owns-Data embedding or App-Owns-Data embedding.
Power BI gives us a flexibility of using custom visuals in variety of scenarios to take our reports to the next level. Today in this blog I will be talking about Comicgencustom visual in a particular scenario to show how this visual can add a bit of emotion and pose visually to your report.
Power BI provides all the features required to design and implement multi-language reports. The good news is that it's no longer necessary to clone and maintain a separate PBIX project file for each language. However, the path to success with building multi-language reports is not overly intuitive. Join the Power BI Dev Camp session on Thursday, July 22 to learn more about the Power BI features for Internationalization and localization and to get the technical guidance you need for building reports that support multiple languages.
Next week's Power BI Dev Camp session on Thursday, June 24 will introduce campers to the App-Owns-Data Starter Kit which is a sample solution for developers built using .NET 5 to provide guidance for organizations and ISVs who are using App-Owns-Data embedding with Power BI in a multi-tenant environment. If you are planning to use Power BI embedding to reach customers and other types of external users, the App-Owns-Data Starter kit provides the fastest way to stand up a custom application which embraces best practices for tenant provisioning, user authorization and activity monitoring.
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.
We all write our codes in a proper format so that readability and understanding of codes become easy. While working with POWER BI, we use DAX Expressions to write our measures and calculated columns. We know that formatting is not required in DAX. It’s normal to see DAX expressions that span over 10 to 20 -lines or more, depending on the complexity and requirements. Sometimes we ignore DAX format as it is time-consuming, and we need to press ALT+ENTER for the new line, which is out of habit for all of us. There is too much ambiguity, and a lack of official specification makes it even harder to comprehend. Whenever I am working with Power BI, I use the following technique to measure it.
An exciting addition to Power BI April release is Power Automate Visual. This adds a host of capabilities to Power BI directly without relying on Power Apps. Users can now activate PA flows directly at the click of a button from Power BI passing necessary action values. This is not only restricted to operations like Send Mail or Create tasks but could also bring the Powerful Data Manipulation capabilities within Power BI. Here we take up a simple example to show how users can now delete records from Database with a click from Power BI. We were familiar with these SQL actions in Power Automate but there was no way to use them in power BI directly so far without having to use Power Apps. More Power to the platform!!
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.
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 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.