This month our reporting features focus on accessibility and more flexibility when formatting your charts. With filtering and sorting options now available, out data view is now more powerful. Several…
It is world’s cup fever: FIFA world cup 2018 in Russia!!! And we dont want to miss anything right? That is where Power BI comes to the rescue :) I am going to build a Power BI file to follow …
BI-RoundUp – Power BI (Power BI Desktop June update – Subscribe others to Email Subscriptions – Deve…
Here is my weekly BI-RoundUp, and once again the awesome people from the Microsoft Power BI Team have released some additional gifts. Power BI Desktop June Update Here is another month of big updat…
Using the Power BI API with PowerShell scripts – Refreshing your dataset
I know when I started trying to use the Power BI APIs, I was unsure of what I was doing, and how I could get it working. Not only that, but I could see that as with building any cloud platform the …
Power BI colors, data models, release notes and more... (June 4, 2018)
Choosing a Color Palette For Your Power BI Report (@mmarie) DATA MODEL ANTI-PATTERNS (@BrettPowell76) On-premises data gateway May update is now available Power BI Developer community May update Busin…
Power BI May 2018 version, released on: 9th of May – 2.58.5103.501 Here’s the complete list of May features: Reporting Conditional formatting by a different field Advanced slicer syncing Log …
In many cases, some small changes can go a long way in making your Power BI reports more accessible for users with different abilities. The checklist below lists considerations you should make in y…
Join my Session at Microsoft Business Applications Summit - DataChant
Are you going to Microsoft Business Applications Summit? (You can register here). I am looking forward to meeting you at my session: Be a Full Stack Power BI Jedi – A Walkthrough of Power BI’s Most Advanced Features through Star Wars Data. This session will include new materials and tricks beyond the original webinar below, …
This month I continued my series with my friend Manuel Quintana [Blog | Twitter] as we guide you through some of our favorite Power BI updates each month. In our June 2018 edition we highlighted th…
While working on Power BI, I came across a feature I found really impressive and easy to implement. It not only enabled me to present my information in a structured and concise format but also made the reports I designed look informative. Conditional formatting is a feature in Power BI and Excel t...
A brief comparison of different available Business Intelligence tools
Robert Mika's wrote an article called Halloween Candies Count - A Tableau/MicroStrategy Dashboard Rebuilt in QlikView. In this article he replicated A Tableau Dashboard Rebuilt in MicroStrategy over Qlikview to showcase the capability of Qlikview in delivering visualization of the same quality. Af...
Making Sense of the Power BI Ecosystem Presentation Materials
I just wrapped up my first presentation on Making Sense of the Power BI Ecosystem at SQL Saturday #755 in Davie, Florida at Nova Southeastern University. The room was full and unfortunately people …
Power BI Feature Discrepancies for Data Acquisition
Power BI churns out new features fast but not all features are available everywhere. As one of the most confusing aspects of Power BI, feature availability depends on the data acquisition method (data…
A quick two page report using LinkedIn data for creating an interactive CV including current/previous positions, skill ratings, recommendations and endorsements. eyJrIjoiYjAwYmMwYTYtODRmMS00MjA5LThjNzYtOTNmNDczMTBkMDBjIiwidCI6ImZiM2Q5MWE5LWU4NzMtNGJlOC1hYTc1LTcxNDEzY2Y5ZDNjOCIsImMiOjh9
The Counting Early in my BI career, I learned that telling friends and family I worked in “Business Intelligence” wasn’t very helpful. Most found the phrase meaningless and a few were relieved (or disappointed) to learn it did not mean I was involved in corporate espionage. So, I developed other go-to answers: “I
There have recently been quite a few changes and updates to Power BI, so in this blog post I have updated my Infographic. As well as put in references to where you can find more details on the upda…
Power BI Tutorial | From Flat File To Data Model | Guy in a Cube
In this Power BI Tutorial, Patrick looks at how to load data from a flat file to the data model. This could be a text, csv or excel file with a lot of columns. Don’t just pull it into Power BI. Take time to structure your data in your data model. From flat file to […]
ANNOUNCING! Our incredible speaker lineup for Microsoft Business Applications Summit
Get ready to connect, collaborate and pack in as much learning as possible at Microsoft Business Applications Summit, the event for Dynamics 365, Power BI, Excel, PowerApps and Flow users, July 22-24 …
Power BI Premium, DAX, Outlook and more... (June 18, 2018) | Guy in a Cube
Line Breaks And Auto-Indent In The Power BI DAX Formula Bar (@cwebb_bi) Power BI Feature Discrepancies for Data Acquisition (@tlachev) FOUR QUESTIONS TO ASK WHEN PLANNING A POWER BI PREMIUM DEPLOYMENT (@mmarie) Use Outlook Shortcuts to organize your favorite Power BI Reports and Dashboards (@cmfinlan) Easier set up of datasets in Power BI BONUS ITEMS: […]
What is Power BI Documenter - Business Intelligence Insights
On Saturday, 9th June 2018, we announced the existence of Power BI Documenter. As the name resembles, Power BI Documenter is a tool to help individuals and businesses to document their Power BI Desktop models. Everyone who already have several Power BI Desktop reports probably realized that documenting the solutions is not as easy as … Continue reading What is Power BI Documenter
Why the Default Summarization Property in Power BI is So Important
This post describes an issue I ran into this week on a project. If the Default Summarization settings in your data model are not correct, it results in wrong data being displayed, or even missing data, on your report. This post is based on Power BI Desktop as of mid November 2017. The concept also
Power BI Helper Version 2: Connection Types, Multiple PBI files, Relationship advise, and Not used t…
I started Power BI Helper with the intention to help to find issues in Power BI reports faster and easier. This tool over time became better and better. I’m excited now to let you know that the versio…