Category Archives: Power BI

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 | 1 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 | Comments Off on Power Query Preview December Update

Power BI for Office 365 FAQ

As I have been giving demos on Power BI for Office 365, I have received a tremendous amount of positive feedback, with many clients really loving it.  There are common questions that I hear, and I thought I would list them … Continue reading

Posted in Power BI, SQLServerPedia Syndication | 3 Comments

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 | Comments Off on Power Query Preview November Update

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 | 14 Comments

Power BI for Office 365 preview released

I first blogged about Power BI for Office 365 two months ago (see Power BI for Office 365) when it was announced.  Microsoft has started inviting participants subscribed to the Power BI for Office 365 Preview to test the prerelease version … Continue reading

Posted in Power BI, Power Map, SQLServerPedia Syndication | 2 Comments

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