cancel
Showing results for 
Search instead for 
Did you mean: 

Find articles, guides, information and community news

Most Recent
ibarrau
Super User
Super User

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.

Read more...

TedPattison
Microsoft
Microsoft

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.

Read more...

Pragati11
Super User
Super User

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 Comicgen custom visual in a particular scenario to show how this visual can add a bit of emotion and pose visually to your report. 

Read more...

amitchandak
Super User
Super User

There are 2 ways to install Power BI Desktop for the end users. Organizations has additional options. 

Read more...

TedPattison
Microsoft
Microsoft

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. 

Read more...

ashanthakumar
Helper II
Helper II

 When we create Report using SAP BW data source. There will be data transformation issue in the  Power BI service for Non- American Users.

 

Read more...

TedPattison
Microsoft
Microsoft

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.

Read more...

monaraya
Microsoft
Microsoft

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

Read more...

TedPattison
Microsoft
Microsoft

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.

Read more...

hp_2198
Helper I
Helper I

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. 

Read more...

AbhiSSRS
Super User
Super User

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!!
Read more...

PriscillaCamp
Advocate II
Advocate II

TitleDescriptionLink
Power BIOfficial MSFT Power BI Website that contains links to all you need to knowhttps://powerbi.microsoft.com/
Power BI DocumentationProvides tehnical information while also giving answers to common questionshttps://docs.microsoft.com/en-us/power-bi/
Power BI Planned FeaturesShares what's new and planned for Power BIhttps://docs.microsoft.com/en-us/power-platform-release-plan/2019wave2/business-intelligence/planned...
Power BI BlogMSFT Employee Blog site that gives the latests updates and news for Power BIhttps://powerbi.microsoft.com/en-us/blog/
Power BI TrainingFree training for Power BI that consists of learning paths and moduleshttps://docs.microsoft.com/en-us/learn/browse/?products=power-bi
Power BI Guided LearningSequenced courses for learning Power BIhttps://docs.microsoft.com/en-us/power-bi/guided-learning/
Power BI ServiceSite to collaborate and share content with other Power BI Pro Usershttps://app.powerbi.com/home
Power QueryTechnical documentation for Power Query with examples and tutorialshttps://docs.microsoft.com/en-us/power-query/
DAXProvides technical documentation for DAX that consists of code, examples, and tutorialshttps://docs.microsoft.com/en-us/power-bi/desktop-quickstart-learn-dax-basics#prerequisites
Power BI User GroupConnect with your local Power BI User Group (PUG)https://www.pbiusergroup.com/home
Power BI CommunityForum to connect, learn, and discuss ideas with other business intelligence experts and peershttps://community.powerbi.com/
Read more...

TedPattison
Microsoft
Microsoft

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.

Read more...

TedPattison
Microsoft
Microsoft

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.

Read more...

vinaypugalia
Resolver I
Resolver I

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.

1.png

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.

 

2.png

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.

 

3.png

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

Happy Reporting!

Helpful resources

Join Blog
Interested in blogging for the community? Let us know.