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
Power BI UX Suggestion: Preserve Selection When Switching Between Report and Model Views
When developing a Power BI report, if I select a visual in Report View and then switch to Model View, the selected table/column context is lost and everything becomes unselected. This can be inconv...Murtaza_Ghafoor3 hours agoSuper UserNew3Views0likes0CommentsPower BI UX Suggestion: Preserve Selection When Switching Between Report and Model Views
When developing a Power BI report, if I select a visual in Report View and then switch to Model View, the selected table/column context is lost and everything becomes unselected. This can be inconv...Murtaza_Ghafoor3 hours agoSuper UserNew4Views0likes0CommentsDefault Scrollable Time-Series Charts to Most Recent Data
Currently, Power BI time-series charts always open scrolled to the earliest (leftmost) date by default, which is inconvenient for reports where users are interested in the most recent (rightmost) dat...CStillwell5 hours agoNew MemberNew3Views0likes0CommentsPower BI Desktop Data Load: Can We Get Better Progress Visibility?
One UX improvement I’d really like to see in Power BI Desktop is better visibility when loading large datasets from Power Query. Currently, when Power Query finishes processing and the data starts l...salmansaifee776 hours agoRegular VisitorNew16Views0likes0CommentsImprove support for calculated tables on remote semantic models
When a report is connected to a remote semantic model, Power BI Desktop allows users to create calculated tables and calculated columns based on that remote model. The issue is that this architectur...alaeddinegaaya10 hours agoNew MemberNew10Views0likes0Comments