Sync Slicers & Sync Slicers Advanced Options

Power BI Bookmarks, Synced Slicers and Selections; these features transformed the way we report using Power BI. Now, most of the business users want reports with actionable interactivity. Well, it has pros and cons; today’s post is not to discuss that but to talk about Synced Slicers.

Synced Slicers were one of the most requested features. As the name says, this functionality enables you to Sync slicers among various Power BI Report pages, and you can manage the properties of it under Sync Slicers Pane.

Bron : Prathy’s Blog
Lees meer…

Excel.Workbook() And The delayTypes Option In Power Query/Power BI

A while ago I found myself wondering – as I often do about this kind of thing – about what the undocumented third parameter of the Excel.Workbook() M function (called delayTypes) actually does. I found a forums post from Guy Hunkin of the Excel Power Query team in 2017 here, which gives the following summary:

Bron : Chris Webb’s BI Blog
Lees meer…

The Is Nullable Column Property In Power BI

The new Relationships view (or Modeling view – it seems to have two names) in Power BI Desktop that has been in preview since November 2018 not only makes it easier to work with complex models and set properties more easily, it also exposes a brand new property on a column: the “Is nullable” property. It’s visible at the bottom of the new Properties pane when you click on a column:

Bron : Chris Webb’s BI Blog
Lees meer…

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…