Blog

Categories: AnnouncementsPower PivotPower QueryPower BIPAB

Connecting to APIs with Power BI (Power Query)–Part 1 of 2

Why is it so complex to connect to an API with Power BI or Power Query? The OAuth explained It’s easier to explain using analogies, so let’s go with that! Analogy: Imagine that you have a gym subscription and this gym also has a VIP lounge, but to get to the lounge you need to […]

Power BI Power Query
Read full article >

Advanced Power Query and other questions from ‘M is for Data Monkey’ readers

The #1 Power Query book in sales and ratings. THANK YOU everyone A little over a year ago, Ken Puls and I published a book called ‘M is for Data Monkey’ which came out from a cycle of iterations over our Live Online Workshop. The book, in essence, is a summarized version of our Workshop […]

Power BI Power Query
Read full article >

Announcements: Power BI Red Carpet Program + New Power Query book is out!

Power BI now in Panama! Powered Solutions is now part of the Power BI Red Carpet Program The Power BI Red Carpet Program is an invitation-only Microsoft Program for a few selected partners worldwide and Powered Solutions has now been nominated, selected and activated as the very first and only Microsoft partner to join this […]

Announcements
Read full article >

ABC Analysis with Power Query

After an amazing first Power Query workshop in English, we are providing our attendees with even more CRAZY cool content that they’ll be able to put into practice (and understand) right away! You might have already seen an ABC Classification Pattern with Power Pivot here, but this time you’re going to see this pattern being […]

Power Query
Read full article >

Power Query for Excel – Replace values using values from another column

Another video trick for Power Query. A glimpse of how advanced you can go with Power Query using custom M code. Be sure to check out more tips and tricks like this one on the oficial Power Query Training page

Power Query
Read full article >

Getting Started & Understanding Power Query and the M Language

Let’s put Power Query and the M Language under the scope Power Query is a breakthrough tool for self-service Business Intelligence and it’s the new best tool released by Microsoft within the span of 5 years. I’ve already posted about what Power Query is and what it represent to us but, How can I get […]

Power Query
Read full article >

What is Power Query?

It’s a bit crazy that at this point I haven’t posted anything clearly defining what Power Query is and where it fits in the whole self-service BI experience with Power BI. So it’s time to actually sum up some points and post them here so we can clear that doubt about what really is Power […]

Power Query
Read full article >

The Powerpivot Way – CALENDAR TABLE (Monthly and Weekly Totals)

New Video Up! have you ever wanted to group your aggregations by Month or Week? Check out this video where I use a calendar table to help me make things easier.

Power Pivot
Read full article >

Someone answered the million-dollar question! (What is Powerpivot?)

YES! IT’S CORRECT! Someone answered the million-dollar question and I feel like Steve Harvey or some other host about to give the million-dollar check to the winner. My friends at Portalfronthosting created this AMAZING video with subtitles in english and spanish! Sí, en español Check it out and don’t forget to share it! The revolution […]

Power Pivot
Read full article >

Understanding Tables, Relationships and Data Modeling in Powerpivot

Figure 1: Shows a fact table with 2 dimension tables for Customers and SalesPerson My response to the image above 2 years ago as an excel user: “What the heck is a FACT and DIM table?” One of the common questions that anyone using Powerpivot has is… How should I model my Data in Powerpivot? […]

Power Pivot
Read full article >

Cool trick: Always show Yesterday’s, Today’s or Tomorrow’s

                                             Executive: Are these values correct?                                             Excel-guy: yes, but you need to check the dates                                                              slicers to see what dates the report is using                                           Executive: Ugh… I just want to click on the report and                                                                    see the latest values If you ever had this situation before let me tell you that you’re […]

Power Pivot
Read full article >

What is Powerpivot? (The Million-dollar question)

(The Riddler) While the prize on whoever answers this question varies, it could potentially be worth more to any business in terms of ROI. In short, Powerpivot is the new tool that allows/enables the business users to take a much more important role in the creation of insights that are relevant to the decision making […]

Power Pivot
Read full article >