Note: Query Editor is part of Power Query. For a quick video on how to display Query Editor, see the end of this article.

Power Query enhances self-service business intelligence (BI) for Excel with an intuitive and consistent experience for discovering, combining, and refining data across a wide variety of sources including relational, structured and semi-structured, OData, Web, Hadoop, and more. Interested in seeing Power Query at work?

The has a section that shows Power Query being used to create a workbook that connects to external data, transforms data, and creates a data model. You can read the entire guide, or jump to its section.

With Power Query, you can share and manage queries as well as search data within your organization. Users in the enterprise can find and use these shared queries (if it is shared with them) to use the underlying data in the queries for their data analysis and reporting. For more information about how to share queries, see.

With Power Query, you can. Find and connectdata across a wide variety of sources. Merge and shape data sources to match your data analysis requirements or prepare it for further analysis and modeling by tools such as Power Pivot and Power View.

Create custom views over data. Use the JSON parser to create data visualizations over Big Data and Azure HDInsight.

Perform data cleansing operations. Import data from multiple log files. Create a query from your Facebook likes that render an Excel chart. Pull data into Power Pivot from new data sources, such as XML, Facebook, and File Folders as refreshable connections. With Power Query 2.10 and later, you can share and manage queries as well as search data within your organization. Power Query Data Sources. Web page.

Excel or CSV file. XML file. Text file.

Folder. SQL Server database. Microsoft Azure SQL Database.

Access database. Oracle database. IBM DB2 database. MySQL database. PostgreSQL Database. Sybase Database. Teradata Database.

SharePoint List. OData feed. Microsoft Azure Marketplace. Hadoop File (HDFS).

Microsoft Azure HDInsight. Microsoft Azure Table Storage. Active Directory. Microsoft Exchange.

Facebook Related topics.

Recently, I noted that the All My Files feature present in macOS for several releases until macOS 10.13 High Sierra, replaced by an inferior Recents display—and that it couldn’t be restored. A Macworld reader wrote in to note that with the use of Spotlight’s lightly documented underlying query language, you could restore the function.

I avoided this in this previous column for two reasons, but if you’re willing to go through some configuration and picky details, you could find it worthwhile. First, it requires learning some programming-like syntax to construct a query, and even the tiniest error in typing or construction will keep it from working without any errors that give you clues of how to fix it. That can be frustrating, but I can at least provide the recipe to paste in. Quadro ode graphics driver for mac. Second, depending on the age of your Mac and how many files on yoru drive, the All My Files replacement could take a long time to run or update, or even slow the Finder down. With those provisos, here’s how you do it.

Spotlight has an underlying “raw query” language for which Apple in 2011. This language lets you specify a search parameter that’s not available through a preset popup menu selection in Smart Folders in the Finder.

In the Finder, open a new folder and click the Recents item in the Sidebar. From the gear menu, select Show Search Criteria. In the field next to Raw Query, enter exactly the following: (kMDItemFSName='.'

). Click the Date Modified column to sort them from newest to oldest. Click Save. Name the search query All My Files, and check the box to put it in the Sidebar. Note that above the query, the Spotlight constraint will show “Search: This Mac Recents Shared,” where Recents is selected. That limits the scope to document types in common locations instead of files found everywhere on your Mac. If you click This Mac, you’ll see the same query performed against the entire set of locally indexed files, which will include database files and other documents used for system and app purposes that you never need to know have changed and with which you don’t interact.

(You can also use these steps to get to a similar place, although it won’t be bound within the Search: Recents parameter. Choose File New Smart Folder. Click the + next to Save.

Select the pop-up menu with Name in it. Choose Other. Type Raw Query into the search field.

Select the Raw Query match and click OK. Proceed from step 3 above. The Smart Folder should populate fairly quickly with results. If it takes a long time or slows the Finder (or your Mac) down, you can limit the query, which should speed it up. If you wanted to get all files modified in the last week, you could change the query above to: (kMDItemFSName='.'

) && (kMDItemFSContentChangeDate = $time.thisweek(-1)) IDG The Raw Query field doesn’t show long queries, so you might want to type it in and edit it elsewhere to be sure it’s correct. On Apple’s main documentation page, it describes how to define date ranges. You can string required conditions to the query with && with a space on either side. (Yes, two ampersands for “and” to connect conditions, not a single one, which does a binary comparison.) You may still see too many results from files that are indexed and show up in these results, but about which you don’t care to see.

For me, that’s individual email messages, which I can find in my email program. If you want to get more baroque, you can look up more parameter types at, although you’ll have to puzzle out valid values and other details. I have a more elaborate query for my All My Files that looks like this: (kMDItemFSName='.' ) && (kMDItemFSContentChangeDate = $time.thisweek(-1)) && (kMDItemKind!='Mailsmith message file') && (kMDItemFSName!='.freelist') && (kMDItemFSName!='.plist') && (kMDItemFSName!='.messageData') This reads in English as, “Find all files modified within the last week where the file kind isn’t ‘Mailsmith message file’ and the file’s name doesn’t end with ‘.freelist’ or ‘.plist’ or ‘.messageData.’” This gives me a more readable list of files about which I want to see recent activity. Ask Mac 911 We’ve compiled a list of the questions we get asked most frequently along with answers and links to columns: to see if your question is covered. If not, we’re always looking for new problems to solve! Email yours to including screen captures as appropriate, and whether you want your full name used.

A Query For Mac Pro

Every question won’t be answered, we don’t reply to email, and we cannot provide direct troubleshooting advice.