Power BI Connector for CBS Open Data / Statline

Since this post primarily concerns a Dutch data source, the rest of this post will be in Dutch. English summary below.

De open data die het Centraal Bureau voor de Statistiek (CBS) via Statline (http://statline.cbs.nl) aanlevert is van onschatbare waarde voor analisten. Over diverse thema’s wordt informatie gepubliceerd, zoals woning, demografie, inkomen en arbeid

Bron : Dutch Data Dude
Lees meer…

The Diagnostics.ActivityId() M Function

I’ve blogged a few times about the tracing functionality that is built into Power Query/Get&Transform and Power BI (see here and here). The trace files themselves clearly contain a lot of interesting information, but there’s no official documentation about what they contain and the format seems to have changed several times.

Bron : Chris Webb’s BI Blog
Lees meer…

Connect Power BI Desktop to Dynamics 365

Do you want to connect to hundreds of data sources, simplify data prep, and drive ad hoc analysis, produce beautiful reports, then publish them for your organization to consume on the web and across mobile devices. Well, then you can use the Power BI suite of business analytics tools that deliver insights throughout your organization.

Bron : Thread Punter
Lees meer…

Microsoft Power BI Map Visualizations

Microsoft Power BI is a powerful tool that allows users to pull real time data directly from Microsoft Dynamics NAV and other sources for analysis and reporting. Included in the analyzation options are two map visualizations that show data by location. These maps are an impactful and creative way to display data. However, sometimes it can be frustrating trying to navigate the map visualizations recognizing your data.

Bron : ArcherPoint
Lees meer…

Formatting Data to Create an Issue-Free Report in Power BI

Microsoft Power BI is an amazing tool. It allows me to build reports that update with real-time information from our ERP system, Microsoft Dynamics NAV, so that all of our team members can access information about financials, projects, cash flow, and various statistics in one click. However, Power BI is anything but perfect, especially when it comes to formatting.

Bron : ArcherPoint
Lees meer…