Power BI

Rather than a measure, this is a python-tool that generates DAX code to implement a pre-trained neural network (or linear/logistic regression) for prediction. https://github.com/maka89/dax_neuralnet

Every year, in return for publicising the BI Survey (the largest survey of BI tool customers and vendors in the world) here on my blog, I get a free copy of the results and the chance to blog about so…

Hi & Welcome back to 24Days of PowerPlatform! As I mentioned in the first #24DaysPowerPlatform post, the Power Platform combines the power of Power BI, PowerApps, Microsoft Flow and the Common …

An aggregated table can be a layer on top of the source DirectQuery table. This table needs to have a proper relationship set up with other tables, and also the proper storage mode configuration. Stor…

I had a question from one of my online Power BI Training students just this week who was struggling to import data from a large *.xlsb Excel file. I suggested she save the file as an XLSX file and…

Let's say you're a senior BI developer responsible for several Analysis Services Tabular instances (Dev, Test, Prod), each of which may host multiple databases. Each database, moreover, may have multi…

I’m quite excited to announce the new Power BI skills assessment on Pluralsight is in beta. This assessment is the result of me spending dozens of hours writing questions and some wonderful peer revie…

A while ago I came across this interesting time intelligence solution that doesn’t use DAX measures to do time intelligence but rather solves it through the model. The pattern was...

Working in Power BI with layered objects can block or cover a visual. This is undesirable from a user Perspective hit this link to read how to resolve.

Microsoft Power BI Online Test - This Power BI Quiz Helps you to crack Power BI Developer interview, Power BI MCQ contains all Advance Power BI Questions

Aggregation can speed up the performance of DirectQuery sourced tables significantly. To use it, firstly you need to create an aggregation table, secondly, you need to set up proper storage modes for …

Connect with experts, collaborate with your community and maximize learning opportunities at Microsoft Business Applications Summit, returning June 10-11, 2019 in Atlanta, GA. Back for its second year, this is the premier place for power users, analysts and technical architects to get hands-on with ...

Back Story: Back in the day, I used to work for this company with a truly all-star / amazing team. We were all part of this company called 20Th Century Fox, and we were in charge of the Theatrical dis…

Analyzing the usage and tuning resources is a key responsibility in Cloud Management. We need to understand where we spent , what are the trends and where we can tune our spending. When it comes to an…

A short post today. Someone recently asked me: “How can I show the date and time this data has been refreshed last in my report and dashboard?”. Here are 2...

Rename Blank in a Slicer in Power BI (@ExceleratorBI) 24 Days of PowerPlatform – Day 6 – How and Where to Start? (@wstrasser) Respect Layers (@powerbitips) CHANGE BAR WIDTH ON A CONTINUOUS X-AXIS (@eS…

Aggregations are speeding up the model. However, the aggregated table is not just one table, It can be multiple layers of aggregations. Aggregation by Date, aggregation by Date and Product, aggregatio…

December is a huge month for us in terms of accessibility. With this release, the entire product is completely accessible for both report consumption and report creation. We are also previewing one of the most asked for features related to Q&A, support for live connect! We also have lots of smaller improvements across the product, such as customizable tooltips for buttons and a larger DAX formula bar.

I was chatting to a few of my Power BI buddies during the week about when we thought the December 2018 update would be released. It seemed to me that under normal circumstances the new version is …

It appears that there is one last massive push from the Power BI team before the end of the year. I would consider this my early Christmas present, so please enjoy and read below. Power BI Desktop …

On a previous series of blog posts, I explained how to grab the list of Data Platform MVPs from a website and add additional data about them as such as their GitHub contributions. In this sequel, I'll…

On a previous series of blog posts, I explained how to grab the list of Data Platform MVPs from a website and add additional data about them as such as their GitHub contributions. My last article also…

If you have used SSRS, you know that paginated reports are very customizable, and you can make almost any property expression-based. Power BI is yet to deliver expression-based properties to change se…

I recently did this webinar for Power BI in the studios in Redmond. The webinar goes into details on the data model with Power Query, importing data, relationships and DAX....

Welcome to post number 6 in my series concerning Microsoft Exam 70-778. The series aims to provide a revision tool for those who are looking at taking the exam and to also provide an introduction i…

Catch the last Power BI roundup for 2018! Merry Christmas, happy holidays and have a great New Year! 🎄❄🎅 Financial Times Visual Vocabulary: Power BI Edition (@SQLJason) Power Query Advanced Editor k…

Have you heard about Yammer? It is a social network for organizations, kind of a “private Facebook”. Let’s imagine your organization is using Yammer as an internal platform for di…

In my current project, one of the user requirement was to have a filter on the Year Slicer. To explain in detail, we have various measures to show metrics for…

I see a lot of Power BI users asking for the ability to set a default slicer selection in their reports. Although this isn’t natively supported as of yet, we can imitate this functionality with a little bit of DAX! A general overview of the process to accomplish this task is as follows: Create a slicer. Create a