Category Archives: Power Query

Power Query load settings

One point of confusion I see with Power Query is some people believe Power Query adheres to the Excel limit of a max of 1,048,576 rows that can be imported.  However, there is a way around this limit.  When using Power … Continue reading

Posted in Power BI, Power Query, SQLServerPedia Syndication | Leave a comment

Power Query Preview December Update

Microsoft keep turning out updates to Power Query.  For December, some of the new features (download): Connection to three more data sources: Sybase IQ, Exchange, and Dynamics CRM Online When using the Navigator pane in the Power Query search, it … Continue reading

Posted in Power BI, Power Query, SQLServerPedia Syndication | Leave a comment

Power Query Preview November Update

As I mentioned in my previous post (see Power BI first impressions), Power Query is a great new tool and Microsoft has been updating it frequently.  The latest update has many new features, among them: Connectivity to Windows Azure Table Storage … Continue reading

Posted in Power BI, Power Query, SQLServerPedia Syndication | Leave a comment

Power BI for Office 365 requirements

“Power BI” is an umbrella name for a lot of products, which I explain at Power BI first impressions (also I have a video at Power BI for Office 365 video).  Power BI is an Office 365 marketing offering (see pricing).  Each of … Continue reading

Posted in Power BI, Power Map, Power Pivot, Power Query, Power View/Project Crescent, SQLServerPedia Syndication | 3 Comments

Power BI for Office 365 video

A demonstration of Power BI for Office 365, showing you how all the various tools and technologies work together: Power Query, Power Pivot, Power View, Power Map, Power BI sites, Data Management, Power BI Admin center, Power BI for mobile, … Continue reading

Posted in Power BI, Power Map, Power Pivot, Power Query, Power View/Project Crescent, Presentation, SQLServerPedia Syndication, Videos | 4 Comments

Power BI first impressions

I have been using Power BI the past few weeks (see my video of all the features) after I was invited by Microsoft to test the Power BI for Office 365 Preview (register here).  I have to say I am extremely impressed. … Continue reading

Posted in Power BI, Power Map, Power Pivot, Power Query, Power View/Project Crescent, SQLServerPedia Syndication | 11 Comments

I’ll take “Products that start with Power”, Alex

FYI: Geoflow (see Geoflow Preview for Excel 2013) is now called Power Map, and Data Explorer (see Microsoft Data Explorer) is now called Power Query. Microsoft Power Query for Excel has reached General Availability and is now available for download. More info: “Data … Continue reading

Posted in Excel, Power Map, Power Query, SQLServerPedia Syndication | Leave a comment

Power BI for Office 365

Announced at Microsoft’s Worldwide Partner Conference 2013 is Power BI for Office 365: Power BI for Office 365 is a cloud-based business intelligence (BI) solution that enables customers to easily gain insights from their data, working within Excel to analyze and visualize … Continue reading

Posted in Power BI, Power Map, Power Pivot, Power Query, Power View/Project Crescent, SQLServerPedia Syndication | 2 Comments

Microsoft Data Explorer/Power Query

UPDATE 10/21/13: Data Explorer is now called Power Query (download). Data Explorer (download), which I first mentioned in my blog about PASS Summit 2011 (SQL Server 2012 and other PASS announcements), has finally taken the next step and is now … Continue reading

Posted in Excel, Power Query, SQLServerPedia Syndication | 5 Comments

SQL Server 2012 and other PASS announcements

Some announcements and notes from SQL PASS Summit 2011, going on this week: It was announced that the official name of the SQL Server “Denali” product is SQL Server 2012 and will be released in the first half of the year 2012.  There … Continue reading

Posted in PASS, Power Query, Power View/Project Crescent, SQL Server, SQL Server 2012, SQLServerPedia Syndication, SSDT/Juneau | 2 Comments