Category Archives: Power BI

Power BI for Office 365 now available!

Microsoft has announced today the general availability of Power BI for Office 365! Microsoft describes it as: Power BI for Office 365 is a complete self-service Business Intelligence (BI) solution delivered through Excel and Office 365 providing you with data discovery, analysis, and … Continue reading

Posted in Power BI, SQLServerPedia Syndication | Leave a comment

Power BI for Office 365 pricing announced

Pricing for Power BI for Office 365 has been announced (see pricing).   It’s all very confusing to me but Melissa Coates does a great job explaining it (see Initial Pricing for Power BI Has Been Announced). More info: Microsoft pins a price … Continue reading

Posted in Power BI, SQLServerPedia Syndication | Leave a comment

Power BI Q&A Preview now works on your data

As I mentioned in Power BI first impressions, Power BI Q&A is an instantaneous search experience that uses a natural language query.  The user enters a question and it interprets it and serves up the correct interactive chart or graph.  It only … Continue reading

Posted in Power BI, SQLServerPedia Syndication | Leave a comment

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