Power BI Blog

While the Power KPI visual has been a necessary building block for us in the presentation of KPIs, by itself it doesn’t provide a scorecard layout. Some users, including executives, really wanted a tabular, scorecard style of KPIs. For this, we developed a second custom visual called Power KPI Matrix.…

One of the new features in Reporting Services 2017 is the new REST API. The announcement is here: https://blogs.msdn.microsoft.com/sqlrsteamblog/2017/10/02/sql-server-2017-reporting-services-now-generally-available/ And the online documentation for the API is here: https://app.swaggerhub.com/apis/microsoft-rs/SSRS/2.0 Interestingly, the new API seems to be OData compliant – which means you can browse it in Power BI/Get&Transform/Power Query and build your…

Hello All, As you may or may not know the cloud has had PowerBi for a while now and it has been a great success at data visualization creating powerful dashboards and helping people make informed decisions every day. And now we have PowerBi moving on-prem with the PowerBi Report…

Data is at the heart of Power BI. Whenever you’re exploring data, creating charts and dashboards, asking questions with Q&A, all of those visualizations and answers you see are really getting their underlying data from a dataset. But where does that dataset come from? Well, from a data source. In…

SQL is neither the fastest nor the most elegant way to talk to databases, but it is the best way we have; here’s why Today, Structured Query Language is the standard means of manipulating and querying data in relational databases, though with proprietary extensions among the products. The ease and…