Category Archives: Power BI

PASS Summit Announcements: Power BI reports on-prem in SSRS

Microsoft usually has some interesting announcements at the PASS Summit, and this year was no exception.  I’m writing a set of blogs covering the major announcements.  Next up is the technical Preview for Power BI reports on-prem in SSRS. The … Continue reading

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

The art of possible with the cloud

One thing I try to do in my role with Microsoft is to get clients to think of possible use cases for building solutions in the Azure cloud.  To set off light bulbs in their heads.  Sometimes this is accomplished … Continue reading

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

Power BI Made Simple

In an effort to understand Power BI and all the products it encompasses, I have made this slide deck to hopefully make things easy for you: Power BI Made Simple. It is a presentation that covers all the products under the Power … Continue reading

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

Power BI Designer and Power BI Dashboard

Long has the question been asked “Which Microsoft tool do I use for dashboards?”.  SSRS, Excel, PowerView, Report Builder and PerformancePoint are all candidates.  But that has all changed, and the future of dashboarding is here: Power BI Designer [since renamed … Continue reading

Posted in Power BI, SQLServerPedia Syndication | 3 Comments

Using Power BI to access on-premise data

The following blog describes how to use certain cloud-based Power BI for Office 365 products (Power View and Q&A) on a Power BI Site that will reference data on-premises.  To do this you will use certain on-premise Power BI products … Continue reading

Posted in PDW/APS, Power BI, SQLServerPedia Syndication | 5 Comments

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 | 1 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 | 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 | Leave a comment