SSIS – Using SSIS Variable within a SQL Script with Temp Tables – Error at Data Flow Task : No Column information was returned by the SQL Command
Below details what I was trying to do within SSIS and how I got it to work. Overview I was using a SQL Script which contained some temp tables which was used in the result set. When I then put this into an OLE DB Source I would get the error shown below: I then tried to see…
BI-NSIGHT – Power BI GA (24 July 2015) / Updates – SQL Server 2016 CTP2.2 (SSRS Treemap & Sunburst Charts)
This week has been another amazing and interesting week with regards to Power BI. So here are is the latest information that I could get my hands on! Power BI – GA (General Availability) This week finally Power BI will go into General Availability. Which has been a long time coming and something that I have been looking forward to…
BI-NSIGHT – Multiple Power BI Announcements – Cortana Analytics – Particle and Microsoft – Azure Data Catalog – Power Query Update
So the past week has been filled with a whole host of announcements, particularly in the Power BI space, but as well as with Microsoft’s cloud based solutions. A lot of the information that I have found due to the current World Partner Conference! So as we do every week, let’s get into the amazing details. There is quite a…
BI-NSIGHT – Power BI for Android Devices – Power BI Designer vs Excel – Power BI Refresh for On-Premise – Power BI Refresh from OneDrive – Power BI Interface Updates
Whilst I thought that this week might be a bit on the quiet side, I think that my previous suspicion is correct, and the wonderful people from Microsoft like to send out updates on a Wednesday. Power BI for Android Devices I was just browsing through twitter and I came across a tweet and clicked on the link, not entirely…
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,…