Personal Bookmarks in the Power BI Service

Today, I’m thrilled to announce the general availability of personal bookmarks in the Power BI service. As a report consumer, you will now be able to create your own set of bookmarks for each report by capturing various states of a report page (including filters, slicers, and state of visuals), give them friendly names, and later return to each state with just one click!

Bron : Think about IT
Lees meer…

Power BI Data Privacy Levels And Cloud /Web-Based Data Sources Or Dataflows

I have already blogged in great detail many times about Power BI/Power Query data privacy settings (see this series for example) but there’s always something new to learn. Recently I was asked a question by Ian Eckert about how Power BI handles data privacy for cloud or web-based data sources after a dataset has been published, and it prompted yet more revelations…

Bron : Chris Webb’s BI Blog
Lees meer…

Update your report based on a website

A quick hack today. Got this question from someone who needed to be able to update a report and show users that something had changed. This is easy when you have access to a database and can add data to it but in this case that was not possible.

So I came up with a hacky (and great :P) way to do this. and wanted to share it in case it came handy in your box of tricks :).

Bron : Kasper on BI
Lees meer…

Power BI And Column Order In M Queries And Dataset Tables

The order of the columns in a table in a Power BI dataset doesn’t matter all that much, especially because the Fields pane in Power BI Desktop ignores the original column order and lists the columns in a table in alphabetical order. However there are a few situations where it is important, for example when you are using the DAX Union() function in a calculated table: as the documentation states, when you use Union() “Columns are combined by position in their respective tables”. You might also find it irritating if the columns you see in the Data or Relationships panes in the main Power BI Desktop window make it hard to browse the data or create relationships.

Bron : Chris Webb’s BI Blog
Lees meer…