Some of this is going to be dependent on interpretation but here goes an attempt at this:
Qlik Feature Necessities
o Formalized training for developers and end-users
Yes, this exists as DIAD and DIAH training for both users and developers and there is formal training from Radacad and others out there.
o Allow end users to make their own objects in the dashboard and share them
Yes, you can do this in either the Service or the Desktop
o App refresh scheduling
You can setup automatic refresh in the Service
o Centralized management console
There is a Power BI and Office 365 Admin/Tenant area that serves as a central management area. Failures are tracked in audit logs and ability to schedule other things, not sure what that is but there is native integration with Power Automate so you can pretty much do whatever you want.
§ Track failures
§ Gantt charts to track when apps run
§ Ability to schedule other things on top of power bi apps like batch files
o Ability to link into SAP
Yes, there are 3 different SAP connectors
o 3 billion rows with efficient speed
§ Curious to see a chart of load speed when comparing input and sql server stream mode
Microsoft demonstrates a trillion row dataset with extremely good performance. For something like this you would want to probably use Direct Query and aggregation tables. I've done tens of millions of rows in an import model but not sure I've ever done a billion plus.
o Access restriction between apps
Is there security? Yes. There are lots of ways to segment this in terms of workspaces, individual security on reports within workspaces and even row level security (RLS) so segmenting security even within the report itself.
o Centralized interface for all applications at once
No idea what this means. The Service surfaces everything you have access to.
o Restrictions between BI and IT since IT would own PowerBI ecosystem
You could do this with separate tenants or separate workspaces, there are tons of different usage models
o Error logging
Office 365 audit logs contain errors
o Variable usage
Assuming this means that you can use variables, yes. If it means there are various ways of using the system, that's also true
o Load scripting?
No clue what this means. You can setup automatic refreshes. There is also the Power BI REST API. Plus native integration with Power Automate so you can pretty much script whatever you want. Not to mention integration with Azure DevOps and Power BI deployment pipelines
o Relationship mapping for apps
Not quite sure what this means but there is functionality for seeing what datasets go with what reports, etc.
· NPrinting Functionality
In a broad sense, there is email and subscription capabilities and printing capabilities. They probably work differently than QlikView but, yes, in general, you can do all these sorts of things.
- o Ability to send emails with specific charts and tables in the body
- o Send attachments
- o Send one email to multiple people rather than multiple emails to multiple people
- o Let users own email distribution list
- o Custom expression modification/filters in objects extracted
- o Scheduling these runs
- o Determining if it is interstitial or third party program
o Explanation of full power of expressions inside PBI
Yes, all this exists in DAX, etc.
§ Nested statements
§ Case statements
§ Set Analysis
§ Bin ranges
o Pivot tables
Called matrix visualizations or you can use the Analyze in Excel to create an actual honest to god pivot table if you so choose
o Straight tables that allow shrinking and expanding columns to hide and auto-update sums and counts etc
Yes, you can do all that in Table visualizations
o Button functionality
Yep, has buttons
o Field groups and cycle between them with buttons in charts/graphs
Yes, you can create groups and hierarchies and there are techniques for making things dynamic like that although the specifics will depend on exactly what you are trying to do and will likely work differently in Power BI than in QlikView but should be able to achieve the same effects using bookmarks, etc.
o Drill downs of hierarchical fields
Yep, multiple, multiple ways of doing this, drill through between pages in reports, inside of visuals and even drill through between reports
o Embedded images
Yes
o Gauges
Yes, native plus additional third party
o Trellis charts
Yes, third party (free and pay) but native soon (small multiples) see roadmap
o Waterfall chart
Yes, native plus additional third party
o Plugins
Yes for just about everything, very extensible, connectors, visuals, etc.
o Color customization
Yes, themes, etc.
o Event triggers
Yes via Power Automate, etc.
o VB/Python/SQL/JS script embedding
Yes, but this is dependent on exactly what is meant here and what you are trying to do, has native integration with things like R, Python, SQL, etc. Very broad requirement
o Geo Mapping
Yes, has many different map visuals, native integration with Bing maps, ArcGIS, etc.
o Conditional formatting
Yes, for almost everything how, even visual titles, etc. Conditional formatting options include background color, font color, data bars, icons, web url
o Current selections visible to remove as a centralized location
No idea what this means. Might be referring to the equivalent of sync slicers?
o Type and text formatting
Yes
o Text boxes with expression
Yes, you use measures and card visuals for this if I understand the requirement.
o Real time update text objects
Yes, you can do real time connectivity via Live connections, Direct Query and streaming but not entirely sure of the specific use case here
o Calendar selections
Yes
o Sliders
Yes, relative date slicers, etc. Between slicers
o Bookmarks to save pre-selected selections
Yes, called bookmarks
o Multiple charts in a single space, visibility determined by tabs or buttons (grouping containers)
Yes, you can overlap visuals and hide them depending on bookmarks and you can group visuals
o Conditional charts that would go invisible if a condition is met
Yes, see above
o Nested expression variables
No idea what this means exactly. Nested IF statements? yes. SWITCH statements? yes In general, DAX can do pretty much anything
§ Front end buttons that house expressions
o Specify object sizes
Yes, you can set page sizes and specific sizes for visuals
o Exporting charts to excel
Yes, there is Export for visuals as well as Analyze in Excel
o Alternate states
This is broad, not well defined but almost certain yes
o Custom sorting
Yes there are various sorting options for visuals, etc.
o General chart animations
Not entirely sure what is meant here but supports SVG animations, etc. Also scatter charts can be animated.
o Object locking by user
Yes, you can lock visuals
o Object hiding by user
Yes, you can hide visuals
o Tab hiding by user
Yes, you can hid tabs
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
Some of this is going to be dependent on interpretation but here goes an attempt at this:
Qlik Feature Necessities
o Formalized training for developers and end-users
Yes, this exists as DIAD and DIAH training for both users and developers and there is formal training from Radacad and others out there.
o Allow end users to make their own objects in the dashboard and share them
Yes, you can do this in either the Service or the Desktop
o App refresh scheduling
You can setup automatic refresh in the Service
o Centralized management console
There is a Power BI and Office 365 Admin/Tenant area that serves as a central management area. Failures are tracked in audit logs and ability to schedule other things, not sure what that is but there is native integration with Power Automate so you can pretty much do whatever you want.
§ Track failures
§ Gantt charts to track when apps run
§ Ability to schedule other things on top of power bi apps like batch files
o Ability to link into SAP
Yes, there are 3 different SAP connectors
o 3 billion rows with efficient speed
§ Curious to see a chart of load speed when comparing input and sql server stream mode
Microsoft demonstrates a trillion row dataset with extremely good performance. For something like this you would want to probably use Direct Query and aggregation tables. I've done tens of millions of rows in an import model but not sure I've ever done a billion plus.
o Access restriction between apps
Is there security? Yes. There are lots of ways to segment this in terms of workspaces, individual security on reports within workspaces and even row level security (RLS) so segmenting security even within the report itself.
o Centralized interface for all applications at once
No idea what this means. The Service surfaces everything you have access to.
o Restrictions between BI and IT since IT would own PowerBI ecosystem
You could do this with separate tenants or separate workspaces, there are tons of different usage models
o Error logging
Office 365 audit logs contain errors
o Variable usage
Assuming this means that you can use variables, yes. If it means there are various ways of using the system, that's also true
o Load scripting?
No clue what this means. You can setup automatic refreshes. There is also the Power BI REST API. Plus native integration with Power Automate so you can pretty much script whatever you want. Not to mention integration with Azure DevOps and Power BI deployment pipelines
o Relationship mapping for apps
Not quite sure what this means but there is functionality for seeing what datasets go with what reports, etc.
· NPrinting Functionality
In a broad sense, there is email and subscription capabilities and printing capabilities. They probably work differently than QlikView but, yes, in general, you can do all these sorts of things.
- o Ability to send emails with specific charts and tables in the body
- o Send attachments
- o Send one email to multiple people rather than multiple emails to multiple people
- o Let users own email distribution list
- o Custom expression modification/filters in objects extracted
- o Scheduling these runs
- o Determining if it is interstitial or third party program
o Explanation of full power of expressions inside PBI
Yes, all this exists in DAX, etc.
§ Nested statements
§ Case statements
§ Set Analysis
§ Bin ranges
o Pivot tables
Called matrix visualizations or you can use the Analyze in Excel to create an actual honest to god pivot table if you so choose
o Straight tables that allow shrinking and expanding columns to hide and auto-update sums and counts etc
Yes, you can do all that in Table visualizations
o Button functionality
Yep, has buttons
o Field groups and cycle between them with buttons in charts/graphs
Yes, you can create groups and hierarchies and there are techniques for making things dynamic like that although the specifics will depend on exactly what you are trying to do and will likely work differently in Power BI than in QlikView but should be able to achieve the same effects using bookmarks, etc.
o Drill downs of hierarchical fields
Yep, multiple, multiple ways of doing this, drill through between pages in reports, inside of visuals and even drill through between reports
o Embedded images
Yes
o Gauges
Yes, native plus additional third party
o Trellis charts
Yes, third party (free and pay) but native soon (small multiples) see roadmap
o Waterfall chart
Yes, native plus additional third party
o Plugins
Yes for just about everything, very extensible, connectors, visuals, etc.
o Color customization
Yes, themes, etc.
o Event triggers
Yes via Power Automate, etc.
o VB/Python/SQL/JS script embedding
Yes, but this is dependent on exactly what is meant here and what you are trying to do, has native integration with things like R, Python, SQL, etc. Very broad requirement
o Geo Mapping
Yes, has many different map visuals, native integration with Bing maps, ArcGIS, etc.
o Conditional formatting
Yes, for almost everything how, even visual titles, etc. Conditional formatting options include background color, font color, data bars, icons, web url
o Current selections visible to remove as a centralized location
No idea what this means. Might be referring to the equivalent of sync slicers?
o Type and text formatting
Yes
o Text boxes with expression
Yes, you use measures and card visuals for this if I understand the requirement.
o Real time update text objects
Yes, you can do real time connectivity via Live connections, Direct Query and streaming but not entirely sure of the specific use case here
o Calendar selections
Yes
o Sliders
Yes, relative date slicers, etc. Between slicers
o Bookmarks to save pre-selected selections
Yes, called bookmarks
o Multiple charts in a single space, visibility determined by tabs or buttons (grouping containers)
Yes, you can overlap visuals and hide them depending on bookmarks and you can group visuals
o Conditional charts that would go invisible if a condition is met
Yes, see above
o Nested expression variables
No idea what this means exactly. Nested IF statements? yes. SWITCH statements? yes In general, DAX can do pretty much anything
§ Front end buttons that house expressions
o Specify object sizes
Yes, you can set page sizes and specific sizes for visuals
o Exporting charts to excel
Yes, there is Export for visuals as well as Analyze in Excel
o Alternate states
This is broad, not well defined but almost certain yes
o Custom sorting
Yes there are various sorting options for visuals, etc.
o General chart animations
Not entirely sure what is meant here but supports SVG animations, etc. Also scatter charts can be animated.
o Object locking by user
Yes, you can lock visuals
o Object hiding by user
Yes, you can hide visuals
o Tab hiding by user
Yes, you can hid tabs
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
@Anonymous - Thanks, I have no preference on that kind of thing. I wrote DAX Cookbook because it was the book that I wanted to write and Packt gave me that opportunity. I had a great experience writing it and I thought it approached the subject from a different perspective, one more rooted in everyday business problems. But, it is not the only book on DAX out there or even necessarily the absolute best book on DAX. Marco Russo's book is great, so are Phil Seamark's and Matt Allington
Also, DAX Cookbook is more about DAX. If you want to cover features of Power BI, my book Learn Power BI might be better. But, again, there are lots of other great content and books out there for that, including Microsoft's free documentation site on Power BI.
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - January 2025
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
Fabric Community Update - January 2025
Find out what's new and trending in the Fabric community.
