Dynamic SSAS (SQL Server Analysis Services) Tabular Role Security – One Role to multiple cubes.
It has been quite a while since my last actual blog post. I do hope that this will help people to use a simple security model, which is easy to implement and maintain. The idea is further down the line to have an application sitting above the security table, so that the right people can add and remove access without…
BI-NSIGHT – Power BI (Desktop Update, Service Updates, API Updates, Mobile App Update, Visual Contest Results, Content Pack – Stripe) – Office 2016 (Excel Updates, Power Query Update, Excel Predictions) – SQL Server Analysis Service 2012 Tabular Update – SQL Server Analysis Services 2016 Extended Events
So this week there was once again a whole host of updates with Power BI, as well as finally the official release of Office 2016. It sure is a busy time be in Business Intelligence space, especially in the Microsoft space. So let’s get into it… Power BI – Desktop Update So I woke up this morning to see that…
BI-NSIGHT – Power BI – (Pin to Dashboard, Extending Power BI Pro Trial, Mobile App Update, All About Dashboards, comScore Content Pack) – Cortana Analytics (Azure Data Catalog) – SQL Server 2016 (SQL Server Analysis Services (SSAS) Tabular Parallel Partition Processing) – Office 2016 (Official Release Date 22 Sep 2015) – Project Prajna
Once again there was a lot of updates from Microsoft, as well as some other really interesting information within the BI Space. So let’s get going! Power BI – Weekly Service Update (Pin to Dashboard, Extending Power BI Pro Trial) I have to say that they are rolling out service updates almost every week now. Which is great to see…
BI-NSIGHT – Power BI (Collaboration, Mobile, Webtrends, Natural Language, Resizing Reports, Increased Limits, Dynamics AX Support) – SQL Server 2016 CTP 2.3 – APS Update 4 – Office 2016 (Updates, Publishing Directly to Power BI)
There is a whole stack of updates with regards to Power BI this week, as well as some other updates within the BI space. I have to quickly point out that I was very fortunate to finally meet Jen Underwood. t (Twitter) It is really great to have the opportunity to have meet up with people that you have followed…
Power BI – Creating a Dashboard when not automatically created
What I found was that in some instances when you imported data into Power BI, it would not automatically create the dashboard. This would also result in your dataset not being indexed (if that is the correct terminology) so that you could then use Q&A in order to enable users to easily search for results using Q&A As with our example below,…
BI-NSIGHT – Power BI Designer Update – Power BI Twilio Connector – Excel 2016 Visualisations – Azure Data Lake
Fortunately this week, the Microsoft machine was a little quieter, but still as expected new updated in the Power BI Space. Power BI Designer Update I have read quite a few blog posts, downloaded and viewed the Power BI Designer update. And I have to say they are some welcome changes. In my mind I see that over time,…
BI-NSIGHT – SQL Server 2016 – Power BI Updates – Microsoft Azure Stack
Well I have to admit that it seems that the Microsoft machine has been working flat out to get out new products and updates. If my memory serves me, this is the third week in a row that Microsoft has released new products and updates. I am really enjoying it! But hopefully this will slow down, so that we can…
BI-NSIGHT – Azure Analytics Services – Power BI Dynamics AX Connector – Auto refreshing of Excel Files in Power BI – Excel 2016 Updates
Once again this past week Microsoft as released even more products. So let’s get started. Azure Analytics Services On 29 April at the annual Microsoft Build conference they announced new services on the Azure platform. I really think that Microsoft is doing a great job of having an entire cloud platform available for customers. Due to the digital age and…
Automating refreshing of Power BI Reports and Dashboards with Excel Workbooks and Power Update
I recently tested to see if it was possible to upload an Excel Workbook to One Drive for Business, and then use this within Power BI. This was successful. Then I saw, and it appeared that if you used an Excel Workbook from One Drive for Business, that it would automatically refresh the file. Which I thought it might possibly…
BI-NSIGHT | Power Pivot & DAX in Power BI – SharePoint 2016 – Power BI AS Connector – Power BI Designer Preview Update – New Power BI Content Packs
In a week there have been a whole host of updates and changes within the Microsoft BI space. So let’s get to it. Power Pivot & DAX in Power BI This is related to my blog past that I created earlier this week (Power Pivot and DAX in Power BI). And it was amazing to see that later on in…