For particularly large oData exports it can sometimes be helpful to increase the default PowerBI timeout period. This is easily done in the advanced editor of the Power Query Editor. 1) To access the Power Query editor click the options menu on your table and select Edit Query 2) In Power Query select the Advanced Editor Read More
Month: October 2021
How to Configure the PAX D210 Payment Terminal Device
The PAX D210 device has the ability to read EMV chip cards, NFC, magnetic strips, and it has a keypad for keyed entry. It is both EMV and P2PE enabled. The PAX D210 device must have a 2.4 GHz wireless connection to the internet, and your point of sale terminal must be able to connect to it over your local Read More
Understand Excel File Types, XLSX, XLSM, XLSB, and More.
When you save an Excel workbook for the first time or use the “Save As” function, you are asked for a folder, file name as well as the file type. By default, Excel suggests the XLSX file type (unless your file doesn’t have VBA macros). The window looks similar to the screenshot on the right Read More
Excel VBA, How to Delete Entire Row if Contains Certain Text
Question I’ve searched on here, but every code I put in gives me an error back. Data in column D, If any of the cells contain “Record Only” I need it to delete the entire row. Solution
Power BI: Analyze in Excel – the Advanced Method
A common ask from users is the ability to view data related to visuals in excel. While there is an option to export data, the format is often unfriendly and has limitations. What’s more, this data becomes disconnected and is not updated if a user looks at after the data is refreshed. This post will Read More