Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have some peformance questions about PowerBI. These questions related to the global settings:
Q1: Why the 4096 limit? Even Excel 32 bit can go higher than this...
Q2: Privacy Level? Does fast combine still exist and is there a way to measure the performance impact?
Q3: Why allow parameterization in data source and transformations dialogs? Will this hurt performance?
Q4: Parallel loading of tables? I've stopped using this because I want each table job to finish before I move on to another.
Has anyone else disabled this? I've disabled this because large datasets would not import completely.
Q5: What restrictions are there now for measures now in directquery mode now? I have not been a huge fan of directquery in practice.
Solved! Go to Solution.
A1: To what 4096 limit are you referring, visuals, data cache limit?
A2: Fast Combine ignores privacy level: https://powerbi.microsoft.com/en-us/documentation/powerbi-refresh-enable-fast-combine/
A3: Because users requested that feature in Ideas, I think their reasoning says it best:
You can turn this off.
A4: I have not disabled it and have not seen any issue but it does clearly state that parallel loading can "occasionally degrade performance or reliability"
A5: You can turn on unrestricted measures for DirectQuery now.
A1: To what 4096 limit are you referring, visuals, data cache limit?
A2: Fast Combine ignores privacy level: https://powerbi.microsoft.com/en-us/documentation/powerbi-refresh-enable-fast-combine/
A3: Because users requested that feature in Ideas, I think their reasoning says it best:
You can turn this off.
A4: I have not disabled it and have not seen any issue but it does clearly state that parallel loading can "occasionally degrade performance or reliability"
A5: You can turn on unrestricted measures for DirectQuery now.
A1: To what 4096 limit are you referring, visuals, data cache limit? Data Cache
A5: You can turn on unrestricted measures for DirectQuery now. I'm not really a fan of tabular or directquery.
Thanks for the reply smoupre
Smoupre,
Can we talk about this further. The September update is out and I have more questions.
2. Query Editor/Parameters -> Why always allow parameterization in data source and transformation dialogs?
3. DirectQuery/What is DirectQuery? How can I test/confirm if I have access to this? Should I allow “unrestricted” measure?Security/What is the difference between a new database query and a new native database query?
-
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |