Tables, Numbers, Immutability And Power Query Performance

Following on from my last two posts on Power Query performance, I thought I would write about another trick that can make a big difference to your query execution times. It’s actually something that Ehren from the dev team mentioned in a forums thread that I blogged about here but it deserves to be better known.

Source : Chris Webb’s BI Blog
Read more…

Adding More Aggregate Columns To The Output Of Table.Profile

A few years ago I blogged about the Table.Profile M function and how you could use it to create a table of descriptive statistics for your data:

https://blog.crossjoin.co.uk/2016/01/12/descriptive-statistics-in-power-bim-with-table-profile/

Since that post was written a new, optional second parameter has been added to the function called additionalAggregates which allows you to add your own custom columns containing aggregate values to the output of Table.Profile, so I thought I’d write a follow-up on how to use it.

Source : Chris Webb’s BI Blog
Read more…

5 Reasons We Love Microsoft Power BI

With data clearly taking the position as king in today’s business world, it’s important to have a tool that can help you tame it and use it to your advantage. Microsoft is all about helping you create a “data culture” in your organization—in other words, taking advantage of data across the organization to tackle any problem and meet any goal. Microsoft Power BI does just that…but what about other tools? Yes, there are other options, but there are so many benefits offered by Power BI that we believe it’s clearly the best choice. Here are 5 reasons why we love Power BI:

Source : ArcherPoint
Read more…

Sharing Data Between Organisations With Azure Data Share

If you’ve ever built a BI solution it’s likely you will have had to integrate third party data, and if that’s the case you will know how painful it often is to get your hands on that data. Badly designed portals you have to log into every week to download the data, CSV files emailed to you, APIs with complex authentication – it’s usually an unreliable, slow and manual process.

Source : Chris Webb’s BI Blog
Read more…

Why Power BI Slicers Sometimes Show Values That Do Not Exist

The problem of blank values being shown in a Power BI slicer is fairly well known, but did you know that in some circumstances slicers can show other values that you would not expect to see? While there’s a good reason for this it can nevertheless be mildly confusing for developers and end users alike when it happens.

Source : Chris Webb’s BI Blog
Read more…

Power BI Deployment Reports Tips for Business Central Users

In addition to integrating Power BI into Business Central, it could be useful to be able to use a fast access portal or receive scheduled reports from Power BI automatically without going through the complete Power BI (Pro and Premium) solution. All this is already existing and usable if I use Power BI Premium license or Pro license, or if I integrate MS-Flow, MS-Sharepoint Online etc. etc

Source : Roberto Stefanetti NAV & Business Central Blog
Read more…