Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Power Query Rss

   Items 1 to 5 of 5   
 

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,475 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,851 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,771 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,053 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 | 2,684 reads
   Items 1 to 5 of 5   
 
Tags
blogs (2)    
excel (2)    
data services (1)    
odata (1)    
power bi (1)    
r studio (1)