Sharepoint .Folder Or .Contents?

Sharepoint.Contents is faster then Sharepoint.Folder. This is because Sharepoint.Contents does not load all the unnecessary folder metadata. Sharepoint.Contents does require a special M query code + 2 parameters (sharepoint / sourcefolder).

Sharing is caring!

Have a look at my other blogs

The importance of custom totals

In the march 2026 update of Power BI, Microsoft gave us a new feature that has been a bit underexposed. It does however make a

ISFILTERED

You probably know that the ISFILTERED function returns TRUE when the specified table or column is being filtered directly. But did you know that if you add multiple ISFILTEREDs together, ISFILTERED will not return true or false, but will return a number. You can combine this returned number with a switch function to influence your total levels.

Un-Bold Row Headers

Have you ever created a matrix visual, with hierarchy, where your row headers are formatted 𝐛𝐨𝐥𝐝? You can not seem to turn if off, because