Forum Discussion

Matt_H_Clam's avatar
Matt_H_Clam
Frequent Visitor
4 years ago

Converting excel connection to Dax - ie SQL to Power Query and DAX

Ive inherited a spreadsheet that connects to a local SQL database with a command string and the following command text;   SELECT shipmentitems.partid, shipmentitems.ordertype, invoiceitems.quantity...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Matt_H_Clam , if data is really big, then having a dax table is not a good idea.  It can also issues because of system performance.  Check RAM and Hard disk availability

 

Try to bring this from DB, in not try in power query

Matt_H_Clam's avatar
Matt_H_Clam
Frequent Visitor
4 years ago

Thanks. I am using 20%CPU and 4GB of memory on my laptop as its trying to run.. I have 32GB RAM and a Core i7 2.8ghz Processsor so its pretty meaty