BI-NSIGHT – Power BI (Desktop Update, R for the masses, Barcode Scanner, New Visuals, Forecasting Features, Xero Content Pack)
It has been an interesting week with some great thing. Power BI – Desktop Update for July As I expected today 01 July 2016, there has been an amazing release in the Power BI Desktop and below are some of my selected highlights. In the Report View section, it is great to see that they have created a new Shape…
Power BI Report – SSRS (SQL Server Reporting Services) Report Performance
Have you ever wondered about how your SSRS reports performance was? How many people are using the reports? How fast are the reports being rendered? Are people running reports, or running them to export them? What is the size of the reports? In this blog post today I am going to give a brief overview of what I did to…
BI-NSIGHT – Power BI (Mobile App Update, Prevedere Content Pack, Visuals, Where is my Data Stored) Excel – (Power Query Updates)
Here are this week’s updates, which there are quite a few and I have no doubt that there might be some more updates released tomorrow or in the coming days. Power BI – Mobile App Update There have been quite a few updates with regards to the Mobile App in for Power BI and Reporting Services. It is great to…
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…