Category Archives: Power BI

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 | 2 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. The Power … Continue reading

Posted in Power BI, SQLServerPedia Syndication | 1 Comment

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

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

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