Power BI – (Twitter Solution Template, Real-time Data, Embedded GA Pricing Update, On-Premise Data Gateway Update, Monitor On-Premise Gateway) – SQL Server 2016 (SSDT Update, SSMS Update)
Here is this week’s BI updates Power BI – Twitter Solution Template This is the second solution template offered by the Power BI team and this time I think they have done a fantastic job. As I know of many companies who are active on Twitter and currently either do not have the resources or the time to be able…
Power BI – How to resolve “Q&A is not available for any of the datasets on this dashboard”
I was recently working on a Power BI project and I had uploaded my Power BI desktop file to the Power BI Service. I had then added an item to a newly created dashboard. Determining why I could not use Q&A When I went into the dashboard I did not see the option for the Q&A box as shown below,…
Automating running PowerShell script which required Administrator elevation via SSIS
UPDATE (08 AUG 2016): I have updated this to use a SQL Server Agent Job instead of the Task Scheduler which proved to not be reliable. What we are going to explain below is the following via an example. Example – We are required to run a PowerShell script which will snapshot a database using Xtreme IO from EMC. In…
BI-NSIGHT – Power BI (Desktop & Service Update, Amazon Redshift Connector, Data Driven Alerts Deep Dive, Impala Connector) – OkViz (PBIX Tools)
As it is now becoming tradition at month end is when we get the release of the Power BI Desktop and Power BI Service, as well as other related BI things happening in the past week. Power BI – Desktop Update So this latest release has a whole host of updates, and as before I will highlight what I think…
BI-NSIGHT – Power BI (Embedded Pricing) – SQL Server 2016 (CU1, Mobile Report Publisher for July) – Excel (Power Query Update)
This week has been a good week in the BI domain. Power BI – Embedded Pricing As you can see from above they now have released what the pricing model will be for Power BI Embedded. You can find the link below to view what your pricing will be based on your data center you use. Power BI Embedded Pricing…
BI-NSIGHT – Power BI (Dataset API Updates) – Excel (Connect to Power BI from Excel)
Here are another week’s updates in the world of BI. Not a significant week! Power BI – Dataset API Updates If you currently use the Dataset API they have released a whole host of changes and additions to the API. I am sure that some of them will be very welcome and I am sure that also some of them…
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…