I walk through using a DirectQuery connection with SQL Server and the Power BI service. I start with Power BI Desktop, show how to configure the enterprise gateway, and then show how it looks in the Power BI service.
Steve Howards looks at working with OData and OAuth with Power BI. Bill Anton looks at prototyping and comparing Power BI Desktop to Power Pivot/Excel. We also had a few updates from the Power BI team regarding Q&A working with direct connections via the enterprise gateway, Query Parameters and Templating with Power BI Desktop and [...]
I mention a feature that dropped over the weekend for Analysis Services live connections. I then answer several questions, from the community, centered around AS live connections and Power BI. Walkthrough: Analysis Services live report in Power BI Authentication with Analysis Services live connections in Power BI Power BI Gateway - Enterprise: Port information
I walk through how to create and publish a report that uses a live connection to Analysis Services. This starts with Power BI Desktop, and makes use of the enterprise gateway once the report is published.
There is a sandboxing update for custom visuals within Power BI. RC0 landed for SQL Server 2016. I mention the updates for Reporting Services and Analysis Services. Also, Microsoft announced that Linux will be supported for SQL 2016 Database Engine. I highlight a community blog post looking at creating a report. And lastly a look [...]
In this roundup, we had a bunch of updates for Power BI and Power BI Desktop. This included custom hierarchies, improvements to report design, and a bunch of updates for connectivity. There was an update for the enterprise gateway which included DirectQuery for Oracle and Teradata along with the ability to use scheduled refresh with [...]
This week the enterprise gateway for Power BI has GA'd. So, that means it is time to move off of the Analysis Services Connector. There were a lot of new updates for Power BI Desktop, including the ability to add measures to a DirectQuery model. Chris Webb looks at how to query DMVs for Power [...]
This last two weeks, because of Christmas break, had a lot of items which included the CTP 3.2 release of Microsoft SQL Server, along with updates for the Power BI Gateway for enterprises. Also, a little fun with some Star Wars data in Power BI. Introducing mobile reports and a brand-new web portal How to [...]
