get & transform

I'm working with some seasoned realtors that are looking to combine their client data for an import into their CRM, one realtor has data that is stored in iCloud, Yahoo, and Gmail, which are exported to separate CSV files. The trouble is that the exported phone numbers, email addresses, and...

I'm looking for a solution that would use the Get Data function in excel to query and combine all files that reside in a Sharepoint document library. I'm able to connect to specific files but the number of files in the document library may change over time (expected to increase). Is there a...

In workbook 1, columns A-D have employee info (first name, last name, division, and supervisor) and columns E-H have dates trainings were completed In workbook 2, columns A-D have the same employee info but columns E-K are tracking employee schedules and attendance In workbook 3, columns A-D...

Hi all! Recently I learned about the PowerBI features (Excel's data-model, Get&Transform, etc.). This seems like THE thing I need in my regular job, as I keep compiling reports from different data sources and updating them. My question is: What is the proper way to regularly update data if...

I've added a table using Power Query to the PowerPivot data model. No problem. I decided to delete it as another table has better data. So I delete the bad table Workbook Query in Power Query (Get & Transform). No problem. But the table still resides in the data model of PowerPivot. When I try...

I'm trying to learn how to use parameters in my Power Query queries. The "main" query gets order data from an Excel table and I'm trying to build a Calendar table based on Order Dates in that query. Normally I'd create the calendar table in the Power Pivot (yeah, I'm doing this in Power Pivot...

Hi all. This is my first post. I hope I can make it as explicit as possible. I am using Get & Transform to load a table that has three parts. Relevant links are shown below: http://mlb.mlb.com/stats/sortable.js...tType=hitting&page=1&ts=1493041844740&position='O'&playerType=ALL...

Hi, I'm having an issue with Excel (2016) is connected to a SharePoint (2013) list using Get & Transform; I'm using the imported data to populate columns in a field via Index(Match()) formulas Table[Field] type references. The issue I'm having is that modifying the underlying SharePoint List...

Suppose I have 30 tables to append in Power Query. Does there have to be 30 separate queries made, or is there a way to make 30 queries all at once?