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
Semantic model connection bindings should be in source control (Git)
Semantic model data source connection bindings should be source controlled. A semantic model can contain multiple data source references, each of which can be mapped to a separate Fabric data connec...frithjof_v1 hour agoCommunity ChampionNew10Views1like0CommentsBulk changing column names in Visualizations Pane
We often use raw/api column names or measures with a set nomenclature to be consistent and to keep track of them but we do not want to display these names in the visuals. Currently we have to change ...vishal1401974 hours agoFrequent VisitorNew5Views0likes0CommentsAbout "Download SQL database project" and fix the downloaded project
1. The sqlproj must be fixed, it is downloaded without the xml markup line <?xml version="1.0" encoding="utf-8"> 2. The sdk must be updated: Actual: <Sdk Name="Microsoft.Build.Sql" Version="0.1...Jarrinf14 hours agoFrequent VisitorNew48Views3likes2Comments