SSIS – Creating a process which will check a condition, if it is not ready wait and try again.
So we had a requirement where we wanted to create a waiting for loop, so that if it was not ready it would wait, try again, and if still not ready wait and try again until it got to the Max Number of tries. We also did not want it to error whilst waiting. Example: Check to see if the…
Power BI – Scheduled Refresh changes next refresh when uploading Power BI File – How to fix
What we are going to show below is when you upload an existing Power BI File into the Power BI Service, if you have an existing scheduled refresh via the Power BI Enterprise Gateway, that it modifies your scheduled refresh. Current Scheduled Refresh scenario To start off with I will show you before I upload a Power BI Desktop file…
BI-NSIGHT – Power BI (Passing Report Filters to Power BI in URL, Row Level Security Explained, Madeira Content Pack)
There is not a whole host that has happened in the past week, but always some interesting things to read about. Power BI – Passing Report Filters to Power BI in URL I must have somehow missed this somewhere along the lines, but I had no doubt that this would be done in the Power BI Service. As I do…
BI-NSIGHT – Power BI (Mobile App Update, Waffle Chart Visual, Alpine Metrics Content Pack, KPI Indicator Visual Explained) – SQL Server 2016 (Hear from the Engineers, Virtual Lab, KPI Data Refresh) – Excel 2016 (New Functions, Power Query Update)
There has been a lot happening in the BI space over the past week. Loads of things to read about and review and see how this can be integrated and used. So without any further delay let’s get into the details. Power BI – Mobile App Update They have made some great improvements to the Mobile App, currently only for…
BI-NSIGHT – Power BI (Service Update, External Sharing, Admin Portal, Web & Video Widget, Zooming) – SQL Server 2016 (Mobile Publisher Preview 2)
This week has been another great week, with some great service updates in the Power BI space, as well as another release for SQL Server 2016 mobile reporting! Power BI – February Service Update There have once again been a whole host of Service updates to Power BI. And as per my previous blog posts I will touch on the…
BI-NSIGHT – Power BI (Q&A for SSAS Tabular, Weekly Service Update, Lithium Content Pack, Mobile App for Windows 10 Mobile) – Azure (SQL Server Virtual Machines) – Power BI and Leveraging the Cloud
Even though I think a lot of people took time off over the Christmas period it seems that the Power BI team at Microsoft was full steam ahead. Which is a great thing to come back to work and have all these updates and new things to look into. Power BI – Q&A for SSAS Tabular The reason for me…
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…
SSIS – Using Date and Time Cache Lookups for faster inserts into Fact Tables
What happened is that I found that when doing inserts on larger data sets, it would take a long time to complete the date and time joins. If I excluded this the data would be returned a lot quicker. So my solution to the problem was to use the Cache Transform and then the Loopkup Transform in the SSIS…
SQL Server 2014 Observations
Today’s post is not going to be about explaining something but more along the lines of my experience on SQL Server 2014. When I heard about all the new features in SQL Server 2014, the In Memory Tables, new cardinality estimator, new changes to how TempDB works, SSIS and Delayed Durability, I was excited to see how I could use…
SQL Server Integration Services (SSIS) – Using Send Mail Task for data validation checks
What I wanted to do was to be notified in my data if there were not enough rows of data, or if the financials were too low, indicating that there was a potential issue with the data coming in. And if it was too low to fire off an email. If it was correct then to not send an email….