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
Support QR codes in the barcode scanner in the Power BI app
I was surprised to find that the barcode scanner inside of a Power BI report in the mobile app only supports scanning barcodes, not QR codes. Our warehouse uses QR codes everywhere, so I cannot use t...Jaap_O_RFH5 hours agoNew MemberNew15Views0likes0CommentsAllow enabling Lakehouse Schemas on an existing Lakehouse
Right now Lakehouse Schemas can only be turned on when you first create a Lakehouse. If you already have one running in production and later decide you need schemas, there is no way to enabled them o...AlessioAndriulo5 hours agoAdvocate INew14Views0likes0CommentsAllow enabling Lakehouse Schemas on an existing Lakehouse, without recreating it
Today, Lakehouse Schemas can only be turned on when a Lakehouse is first created. There is no supported way to enable schema support on a Lakehouse that already exists — the only workaround is creati...AlessioAndriulo6 hours agoAdvocate INew33Views4likes0CommentsWorkspace Folder & Subfolder Inventory View for Power BI Reports and Apps
Problem: Many organisations use Power BI workspace folders and nested subfolders to organise reports by department, business area, project, or function. While this structure helps keep content organ...rijesh6 hours agoFrequent VisitorNew14Views1like0Comments