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…
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 (May Service Update, Q&A for Enterprise Gateway, Solution Templates, UserName() in Power BI, Local Excel Files Upload, Download Dashboards / Reports to .pbix file, Forecasting Feature, Webinar Intro to Power BI for the Excel User – Newsletter
Here are this weeks updates Power BI – May Service Update There is a whole host of updates to the Power BI Service this week, and some great additions. The first improvement is the increasing in the file size to 1GB. And whilst we all know that the compression is really good with Power BI and Power Pivot, there are…