BI-NSIGHT – Power BI (New On-Premise Gateway, Data Stories Gallery, Embedded GA coming soon – Publish to Web GA, New Visuals,) – SQL Server (R Client, Migration Assistant for Datazen) – Excel (Faster Pivot Tables in Excel 2016) – Azure (Azure SQL Data Warehouse GA)
There sure has been a whole host of updates and additions in the world of BI in the past week. So here they are below. Power BI – New On-Premise Gateway This is another great update that I did not see coming. But it does make total sense. As well as great to have a single point in which you…
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…
BI-NSIGHT – Power BI (Notifications, Help Improve Power BI) – Excel – (Power Query Update)
Another week and some more updates to the world of BI Power BI – Notifications It is great to see that we now have got some notifications in a similar way in which we have had in the Mobile App. As often I am sure that I have shared dashboards with people and they either are not aware or missed…
Automating running PowerShell script which required Administrator elevation via SSIS
What we are going to explain below is the following via an example. Example – We are required to run a PowerShell script which will run with elevated privileges. So in order to complete this we have to complete the following below but use a simple PowerShell script which will get all the FileNames from a Folder. Create a BAT…
BI-NSIGHT – Power BI (Smarter Auto Generated Insights, OkViz) – SQL Server 2016 (SSDT GA) – Microsoft Flow (Updates)
Not a whole host of updates this week, but still some great things to look into. Power BI – Smarter Auto Generated Insights Another great service update in Power BI, with regards to the Quick Insights. You now have the ability to put in complex filters and then generate insights based on your complex filters. This can enable you to…
BI-NSIGHT – Power BI (Desktop Update – May, New Visuals, Gateway Enterprise Update, Azure ML Predictions, Planned Work started) – SQL Server 2016 (Generally Available, Mobile Report Publisher,SSMS
Here are the weekly BI Updates, with a lot of great things within Power BI as well as the major release for SQL Server 2016 Power BI – Desktop Update for May Well this week there is a whole stack of updates to the Power BI Desktop which once again is great to see so many updates and actual user…
BI-NSIGHT – Power BI (Mobile App Update, Improvements started – Top N Filters – Support for Custom Maps – Download Dashboards/Reports to .pbix – Better Date Range Filters)
Another week, another great amount of updates, I am sure that there will be additional updates later this week. I always look forward to them. Power BI – Mobile App Update It is great to see that now they have got the SSRS capabilities to Windows 10. Along with this they have also enabled the feature on all versions of…