wlayton
9 years agoNew Member
Status:
New
Importing Microsoft SQL Server tables with datetime columns causes high cpu and memory usage.
When importing a sql server table with datetime columns the cpu and memory usage spikes. This causes power bi and Windows in general to become unresponsive. The more datetime columns in the table the higher the memory spikes and the cpu is maxed for a greater length of time. For example, my data set has a table with 26 datetime columns, in addition to other column types, and power bi desktop returns an out of memory error when importing this table. If the query is limited to exclude the datetime columns then the table is imported quickly with little additional cpu and memory usage. As the datetime columns are included back into the query, cpu usage and memory usage increase at a near linear rate until the out of memory error occurs. This happens at approx. 20 datetime type columns.
1 Comment
- fbcideas_migusrNew MemberStatus added:New
Recent ideas
Access Variable Library in Semantic Models
Enable the Variable Library as a centralized location for storing all environment‑specific variables, allowing us to adjust them for promotion scenarios (e.g., from dev to prod) without relying on de...FreddyH2 hours agoAdvocate IINew910Views31likes2CommentsEnhance Fabric Pipeline Monitoring with Parent-Child Pipeline Lineage and Parameter Visibility
Currently, Microsoft Fabric Pipeline monitoring lacks several capabilities that are available in Azure Data Factory, making troubleshooting and operational support challenging in enterprise environme...dwramreddy2 hours agoRegular VisitorNew2Views0likes0CommentsDynamic ADLS-Gen2 path input for Spark Jobs Main definition file
I would like the ability to add a dynamic input box on a spark job definition's "Main Definition File" "ADLS-Gen2 path". this would be useful to set base and variable paths across all spark jobs...mfink_db7 hours agoNew MemberNew238Views2likes2CommentsReintroduce Tenant/Capacity Switch to Control "Users can create Plan items" Post-GA
During the Preview phase of Fabric Plan items, administrators had access to a dedicated tenant/capacity setting: "Users can create Plan items". With General Availability (GA), this granular administr...Sri-Surendra_Ku9 hours agoNew MemberNew106Views14likes1Comment