Power BI

Power Pivot Performance Gotchas! All the common reasons I see for slower models and workbooks when consulting with my clients!

Watch the table-relationships of your Power BI or Power Pivot model in Pivot-view to see at a glance on which fields they are connected to each other.

It’s downing a bit slowly on me how awesome the direct retrieval of DMVs in PowerBI and PowerQuery actually is. Just see how easy we can build a cool view (…) Read more

Here is this week’s BI-RoundUp with some great content below. Power BI – Usage Metrics You now have the capability to be able to view the usage metrics for your dashboards and reports in Powe…

A common question I get is what will we will be able to do around embedding Power BI reports with Power BI report server. To understand this it is important to look at how the Power BI reports are …

Using the R Script in Power BI does not exclusively have to be for advanced transformations or for connecting to sources that Power BI does not easily ingest. Sometimes, the R Script is simply fast…

After selecting an initial challenge category for the Power BI Analytics Challenge, it was time to get to work. I chose to visualize data from the American Time Use Survey, which is available from …

Dynamic TopN Reports via Slicers: Now you can click, slice, interact, touch (…dirty), and drill (dirtier!) with these reports to your hearts desire.

Today we are starting a new series on Power BI Row Level Security (RLS). Implementing RLS in Power BI can be a fascinating topic. Especially when you have design constraints, and cannot rely on a simple logic to apply RLS, or when your IT team cannot support your special security logic with customized AD groups. This is …

In this video, I look at how to install and configure the May 2017 Preview of Power BI Report Server. Power BI Report Server has a new standalone install experience and this product allows for Power BI reports to be rendered in the web portal along with paginated reports. This will get you started with […]

I had a requirement from the customer where I am consulting and what they wanted was to be able to have dynamic banding. So that no matter what they put into the table it would show the banding whe…

Even Very “Sophisticated” Reports/Dashboards are Often “Couch Potatoes” in Practice(They Sit There and Expect You to Do All the Work) Intro From Rob I’ve b

Power BI data sources can be almost anything. Here's how to estimate your market share using free information sources from the web.

You have a Power BI Desktop model and you need to have the same model in SSAS Tabular? Import Power BI Desktop to SSAS Tabular 2016 and save DEV time/money.

When looking for help in the forum regarding questions in the query editor, you will often come across M-code snippets because the solution cannot be done using the UI alone or it was simplythe most convenient way for the answerer.   If you have trouble to apply this to your existing solution, this ...

I  have a measure : "rupture" which is calculated (substraction) based on two other measures "Stock Week " and stock  Week-1.  I have good results when i'm in a weekly bucket, but when i'm in total, it gives me the result based on the total of "Stock Week " and "stock Week-1".   I would like to sum ...

Hi,   I've been trying to get my head around how to calculate a forecast accuracy. Here is how I usually set up a simply formula in excel:   First I calculate the absolute variance between sales and forecast. I do this for each individual "Material" (product).   absolute varian...

Does anyone have suggestions on how to average the YTD months to a target, and reforecast the remaining months based on that percentage?   For example,   If my first 5 month average sales was $40.00 but I targeted $50, I would take 40/50 and multiple that by next months target, say it was $48. The v...

As promised here, today we will web-scrap Office Store website, and extract the information to build a catalog of Power BI Custom Visuals. You can share this tutorial with colleagues, and use it as an exercise to improve your Power BI skills. Another great benefit of the tutorial, is its outcome. Following the steps below, you …

I just installed the Power BI report server following @SQLDusty YouTube 13 minute Step-by-Step video. You have to download both the Power B...

Although the Microsoft Power BI and Alteryx integration was announced back in October, due to time constraints and other factors, I was not in a position to dig into it at the time. Times change, a…

When you have 10's of thousands of Tweets about your event, how do you know what to focus on or what the sentiment of the crowd is?  tyGraph for Twitter allows you to do just that. It is purpose built for major events to process Twitter traffic and report it in different ways through 6 context fille...