Table and column references using DAX variables - SQLBI
This article describes how to correctly use column references when manipulating tables assigned to DAX variables, avoiding syntax errors and making the code
Group rows or columns to create custom visual hierarchies in Power BI - Inforiver
While using multiple categories in a table/matrix, data analysts often prefer to rearrange, reorder or group specific rows or columns. Inforiver supports all these features this for table/matrix style reports in Power BI.
Power BI & Synapse Part 2 - What Synapse brings to Power BI table?
In the 2nd part of the series, learn what Synapse brings to a table for Power BI developers, and how you can leverage both tools to get indefinite number of use-cases!
This Power Apps tutorial explains, Power Apps Gallery Pagination, how to create Power Apps Gallery Pagination and how to display SharePoint list data using a Power Apps Gallery control.
Slicers or Filters – Comprehensive Guide - Self-Service Business Intelligence
Slicer and filter were around in Power BI for a long time now, and plenty of blog posts were created comparing them to each other. Because these features constantly get updated and there are considerations outside of just a single report, I thought to write a comprehensive guide that I can point to every time […]
#PowerQuery – Add Year, Month and Day to your date table with Date.ToRecord – #PowerBI
When you build a date table in Power Query you might use the functions under Date to add year, month and day And this will give you three steps in your Query But we can do this a bit faster, and yo…
Plan your Power BI sessions at Ignite Nov 2-4, 2021!
As we move into the last third of the year, the Power BI team have had a busy summer working on delivering exciting innovation for you, our community. We have a number of sessions during Ignite delivered by experts which gives you a great sense of the capabilities you can try, deploy or scale for your organization. As with everything we do, we’re grounded on the mission of empowering every individual, team and organization make better data driven decisions. Let’s take a look what sessions you can put into your backpack this Ignite.
Creating real-time dashboards in Power BI with push datasets - SQLBI
Though you can build real-time reports with DirectQuery, push datasets offer a more scalable, economical, and effective solution especially when combined wi
Chris Webb's BI Blog: Refreshing Power Pivot Excel Data Models That Use The Current Workbook As A Data Source In Excel Online
Something that got lost in all the excitement around Excel reports connected to Power BI datasets working in Excel Online is the fact that Excel reports connected to the Excel Data Model – ak…
A new, more powerful, and customizable Microsoft Bookings is here
Last March, at Ignite, we gave you a preview of the new powerful and customizable Bookings experience and starting today, we are rolling it out to everyone! To turn on the new experience, toggle the switch on the top right corner of the Bookings home page. Look for the toggle on the top right cor...
In this article, we share an idea to reduce the friction in using Power BI, by extending the DAX language with new visual calculations. At SQLBI, we teach D
🦸🏻♀️ Enhancements in Sales Accelerator using Adaptive Sequences by Inogic🦸🏻♀️ Build A Shopping Cart In Power Apps by Matthew Devaney🦸🏻♀️ Dynamic lists are here by Jesper Osgaard🧭 Raise of the citizen Data Analyst by Carsten Groth
How to return forecasted values as a table in a R visual
Scenario: Usually, we can forecast values and return a line chart by using R visual in Power BI. But since it can only return image, how can we return the values as a table? And how can we use these values in the subsequent analysis? Sample data: The sample data is as follows and the complete d...
Reflection on how “You have to be technical” during informationals or interviews, especially with lack of context can lead to undesirable outcomes, including gatekeeping and more.
Implementing real-time updates in Power BI using push datasets instead of DirectQuery - SQLBI
Push datasets are an efficient and inexpensive way to implement real-time updates in Power BI reports and dashboards. They can provide better performance an
Creating real time dashboards in Power BI with push datasets - SQLBI
Though you can build real-time reports with DirectQuery, push datasets offer a more scalable, economical, and effective solution especially when combined wi
In power bi is not easy to define arbitrary 2 level column headers in a matrix visual. In this article we try different approaches and a final solution
How to Create a Responsive Editable Grid in Canvas App
In this blog, we show you how to create a Responsive Editable Grid in Canvas App as quick as possible with the Horizontal container and Vertical container.