BI-NSIGHT – Power BI Designer Refresh – SQL Plugin for Excel – SQL Server 2016 In Memory Tables – Azure SQL Data Warehouse – Office 2016 Update – Power BI Content Pack (UserVoice)
Another week has gone by, so let’s get into what is currently out there and happening in the BI world. Power BI Designer Refresh I do know that this came out last week, but I still wanted to comment on this. Once again this is something that customers and myself have been waiting to be implemented and asked for on…
BI-NSIGHT Power BI Sweet IQ , Summer Release – SSIS Feature Pack for Azure – Excel 2016 New Chart Options (Treemap, Sunburst, Histogram, Box & Whisker, Waterfall)
Well this week there were some updates and fortunately not too many so where we go! Power BI – Sweet IQ This week, there was yet another release of a content pack for Power BI, this time it was relating to a company called Sweet IQ. They position themselves as provider that can leverage your local search and increase your…
BI-NSIGHT – Power BI Updates (comScore, appFigures, Mail chimp) – Microsoft Social Engagement
I was away on holiday so here is this week’s BI-NSIGHT.. Power BI Updates comScore and Microsoft Partner to Provide Big Data Mining and Visualization Solution comScore, is a Digital Media analytics company. And their relationship with Microsoft which has been ongoing for quite some years seems to be able to add additional values for their clients. Using the…
BI-NSIGHT – SQL 2016 Preview (CTP2) – SSAS Partition Manager – Power BI Quickbooks Connector – Excel 2016 Updates
What started out as a rather quiet week in terms of news and what is going on within the Microsoft space, when I started going through my daily routine today there was some pleasant updates! SQL Server 2016 Preview (CTP2) After the Microsoft Ignite conference it was announced if I can remember correctly that there would be a SQL 2016…
Power BI – Creating a Dashboard when not automatically created
What I found was that in some instances when you imported data into Power BI, it would not automatically create the dashboard. This would also result in your dataset not being indexed (if that is the correct terminology) so that you could then use Q&A in order to enable users to easily search for results using Q&A As with our example below,…
BI-NSIGHT – Power BI Designer Update – Power BI Twilio Connector – Excel 2016 Visualisations – Azure Data Lake
Fortunately this week, the Microsoft machine was a little quieter, but still as expected new updated in the Power BI Space. Power BI Designer Update I have read quite a few blog posts, downloaded and viewed the Power BI Designer update. And I have to say they are some welcome changes. In my mind I see that over time,…
BI-NSIGHT – Excel 2016 – Power BI Updates (Including new Data Sources) – Azure SQL Data Warehouse
So after last week, and the annual Microsoft Ignite conference, there was a whole stack of product announcements and updates. This was really great to see, and it once again amazes me how quickly Microsoft is able to get this to market. And being a Microsoft BI enthusiast, it excites me. I mean who does not like to play with…
BI-NSIGHT – SQL Server 2016 – Power BI Updates – Microsoft Azure Stack
Well I have to admit that it seems that the Microsoft machine has been working flat out to get out new products and updates. If my memory serves me, this is the third week in a row that Microsoft has released new products and updates. I am really enjoying it! But hopefully this will slow down, so that we can…
BI-NSIGHT – Azure Analytics Services – Power BI Dynamics AX Connector – Auto refreshing of Excel Files in Power BI – Excel 2016 Updates
Once again this past week Microsoft as released even more products. So let’s get started. Azure Analytics Services On 29 April at the annual Microsoft Build conference they announced new services on the Azure platform. I really think that Microsoft is doing a great job of having an entire cloud platform available for customers. Due to the digital age and…
Automating refreshing of Power BI Reports and Dashboards with Excel Workbooks and Power Update
I recently tested to see if it was possible to upload an Excel Workbook to One Drive for Business, and then use this within Power BI. This was successful. Then I saw, and it appeared that if you used an Excel Workbook from One Drive for Business, that it would automatically refresh the file. Which I thought it might possibly…