A post on how to use Power Query to audit file changes. A look at KPIs within Power BI. Keeping up to date with Azure Active Directory Connect. And a post about how to use custom thumbnails for mobile reports in Reporting Services 2016. Power Query as a File Audit Tool (@ExceleratorBI) KPIs and Power [...]
This last week was really full with announcements at the Microsoft Data Insight Summit, along with the release of SQL Server 2016 RC1 last Friday. This included updates to Reporting Services. Over 5 million subscribers are embracing Power BI for modern business intelligence Microsoft Data Insights Summit Livestream: day one Microsoft Data Insights Summit Livestream: [...]
I break down how to make a branding package for SQL Server Reporting Services 2016. I compare it from the original skin, to the multicolor brand package that Chris Finlan put together, to my custom brand package for Guy in a Cube. Branding the web portal (MSDN) Chris Finlan's Blog Post Color Hex codes
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 [...]
I look at three things you need to do to create and use KPI's in SQL Server Reporting Services 2016. This looks specifically at CTP 3.3. I go through creating a shared dataset, creating the KPI and then setting up refresh for the KPI/Dataset. Working with KPIs in Reporting Services
We start with a new content pack for Power BI for Insightly CRM. We got a new preview of the Mobile Report Publisher for Reporting Services. Matt Allington talks about a compression tip for Power Pivot. Patrick LeBlanc talks about Row-Level Security with SQL Server 2016 and how to take advantage of that from Reporting [...]
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 [...]
