Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Power Query Rss

   Items 1 to 7 of 7   
 

Power Query Formula Language in Power BI Desktop

The Power Query Formula Language (PQFL) is a functional language that drives the Power BI transformations, and allows you to create mashup queries from scratch. In this article, Rob Sheldon demonstrates how to use it in Power BI Desktop to extract data from its source, filter rows, specify the columns, clean the data, and create visualisations.  Read more...
By Additional Articles 2015/10/05 | Source: SimpleTalk | Category: power bi
Rating:  Rate this |   Briefcase | 2,399 reads

Retrieve file sizes from the file system using Power Query

Koen Verbeeck shows how to easily extract metadata from files in your directories with Power Query.  Read more...
By Additional Articles 2015/09/23 | Source: MSSQLTips.com | Category: power query
Rating: (not yet rated)  Rate this |   Briefcase | 2,605 reads

Query Folding in Power Query to Improve Performance

In this tip Koen Verbeeck discusses query folding, how you can take advantage from it and how to make sure query folding takes place.  Read more...
By Additional Articles 2015/06/03 | Source: MSSQLTips.com | Category: power query
Rating: (not yet rated)  Rate this |   Briefcase | 2,762 reads

Data Warehouse to OData to Excel and R

How do you make data available to analysts who want to blend data with R or Power Query tools? Why with OData services.  Read more...
By Benjamin Seidle 2015/03/03 | Source: SQLServerCentral.com | Category: odata
Rating: |  Discuss |   Briefcase | 5,953 reads

Getting Started with Microsoft Power Query for Excel

Power Query, provided as part of Microsoft Power BI self-service solution, is an Excel add-in that can be used for data discovery, reshaping the data and combining data coming from different sources. Power Query is one of Excel add-ins. Read on to learn how to install and get started using it.  Read more...
By Additional Articles 2013/12/04 | Source: Database Journal | Category: power query
Rating: (not yet rated)  Rate this |   Briefcase | 2,897 reads

Why the MS Power Query (PQ) for Excel is an invaluable Business Intelligence tool

Dear reader, I would like to share with you some of the capabilities that the Power Query for Excel brings...  Read more...
By Ziek's SQL Blog 2013/08/22 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 3,467 reads

Using Parameters in Power Query Extracts

Introduction By now you have likely heard a little about Power Query (formally known as Data Explorer). While you may have...  Read more...
By Devin Knight 2013/08/14 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 3,197 reads
   Items 1 to 7 of 7   
 
Tags
blogs (2)    
excel (2)    
power bi (2)    
data services (1)    
odata (1)    
power query formula language (1)    
r studio (1)