Power BI and Excel are both extremely powerful reporting and data analysis tools. As people look to improve and modernize their processes, the question of which one is better comes up very often. Implementing a new business intelligence and reporting tool can be an intimidating task. We look at the differences between these two platforms …
Creating a set of Financial Statements in Power BI is a common request. Many companies would like to build an Income Statement, Balance Sheet and Cash Flow Statement in Power BI but don’t know where to start. We examine several methods and techniques while highlighting some current limitations of the platform. This article assumes that …
Sometimes you need to add a column to your data model in Power BI with a fixed value. Some common scenarios for this are categorizing or labeling a data source prior to appending it or merging it with additional tables. Other times it is a simpler method to get a sum of all rows without …
Have you ever been working with a new Power BI Dataset and received a DataFormat.Error notification while working with your data model? It can be very frustrating and confusing, but we will walk through a few ways you can address the Power BI error and avoid it in the future. It’s worth noting that this …
How to Fix Power Bi DataFormat.Error Invalid Cell Value Read More »
Learn how to setup and get the most out of the Microsoft Power BI Gateway. We explore the use cases and data security concerns that come with establishing a gateway to access on-premises data sources with the Power BI Service. What is a Power BI Gateway? A Power BI Gateway is used when you want …
ChatGPT is a must use tool for PowerBI developers. It can write DAX and SQL queries and help integrate systems and generate its own dashboards with AI
Power BI is one of the leading Data Visualization and Business Intelligence tools on the market today. It was released in 2011 and is aggressively updated with new features every month. It can be used for a wide range of tasks, from creating interactive dashboards of visually attractive data visualizations to enabling big data insights …
The Power BI Platform for Accounting and Finance Read More »
