Create Dynamic Periods for Fiscal or Calendar Dates in Power BI
I came across Chris Webb’s excellent post (Creating Current Day, Week, Month And Year Reports In Power BI Using Bidirectional Cross-Filtering And M) in which he demonstrated how to leverage the Bi-Directional filtering in Power BI. Chris goes into great detail to explain how he goes about creating the functions, tables and how it all pieces together. This got me…
BI-NSIGHT – Power BI (Secure and Audit Power BI, Data Driven Parameters, Snowflake Data Connector) – Excel (Get & Transform Updates / Power Query Updates)
Here are the BI updates for this week. Power BI – Secure and Audit Power BI One of the questions that is regularly asked with regards to Power BI is around how secure the data is. And along with that is how do people gain access. This new update goes a long way not only to make Power BI more…
BI-NSIGHT – Power BI (Desktop Update for August, R Showcase, Content Pack Certification Program Overview, Power BI Publisher for Excel Update) – OkViz (Sparkline Visual)
Here is another week of BI news and information. Power BI – Desktop Update for August This month there is another great list of updates in Power BI Desktop. As I have done previously I will highlight what I personally think are great updates. Report View Updates There have been quite a few updates in the report view. The ability…
Power BI – Creating Dashboard Items that show MTD (Month to Date), or WTD (Week to Date), or YTD (Year to Date) dynamically changing based on your current period
I have been working quite a lot with Power BI, and one of the great features is Q&A So what if you wanted to create a dashboard item that would always show you your sales for the current month (MTD), or current week (WTD) or current Year (YTD)? And always show the correct current period, without you having to go…
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…