Data & Analysis

Why Is My Relationship Inactive in Power BI Desktop?

The Power BI Desktop tool now attempts to utilize bi-directional relationships when it can. If any ambiguity exists, some of your relationships may become inactive. If you are seeing inactive relationships (the dotted line), take a look in Advanced properties to see if the “cross filter…

5 February 2016

Data & Analysis

The Table.Schema() Function In Power BI/M

Yet another new M function for you this week: the Table.Schema() function, which returns information about the columns in a table. There’s some fairly detailed documentation about what it returns here; a simple demo is always a lot more helpful though, I think. Bron : Chris…

27 January 2016

Data & Analysis

Descriptive Statistics In Power BI/M With Table.Profile()

As Buck Woody notes here, when you are exploring a new data set it can be useful calculate some basic descriptive statistics. One new M function that appeared in Power BI recently can help you to do this: Table.Profile(). This function takes a value of type…

18 January 2016

Data & Analysis

Monitor your Website Growth with one click with Google Analytics and Power BI

I use Google analytics to optimize my site, to make it useful and usable for my readers. Doing that, I am also hoping that my site will grow. It is the ultimate confirmation that I am doing it right. Measuring growth in Google Analytics itself is…

8 January 2016

Data & Analysis

Tables.GetRelationships() Function In Power BI M

There’s a new M function in the latest release of Power BI Desktop that I spotted: Tables.GetRelationships(). Here’s the help page for it: Bron : Chris Webb's BI Blog Lees meer...

8 January 2016

Data & Analysis

Avoiding Duplication Of Database Connection Information In Power BI

In a year’s time there will be a great opportunity for someone to present a session on “Power BI Development Best Practices” at the PASS Summit. Before then, we will all have to work out what those best practices actually are – probably the hard way.…

7 January 2016

Data & Analysis

Create a Power BI Dashboard using your Twitter Data

Recently I stumbled upon this blog: http://blogs.msdn.com/b/powerbi/archive/2015/12/18/3-twitter-kpis-to-share-on-your-business-dashboard.aspx It shows how you can export your Twitter analytics and use it as a source in a Power BI Dashboard: The process is very simple. Bron : Think about IT Lees meer...

7 January 2016