Power BI – Finding the data type when using Variables in Measures
I have been working with an Organization where I have had to create some rather complex measures. And within these measures I am using a fair number of variables. I found that at times it was a challenge to understand what data type was being returned by the variable. Which at times would lead to a different result, because the…
Power Query – How to get same row number for x number of rows
I was answering a question on the Power BI Community Forum where a user was looking to get some data from an Excel spreadsheet into Power BI. And in order for me to complete it, I wanted to get the same row number for x number of rows. Example I had some sample data where the same data was repeated…
BI-NSIGHT – Power BI (Community Blog Highlights – Power BI Germany – Latest Updates for Power BI Desktop – How Microsoft uses Power BI to run its Cloud Business – Connecting Datasets to Power BI Service) – SQL Saturday Brisbane (I’m presenting) – SQL Server (SQL Server 2017 – DAX Editor for SSDT – New Get Data Experience for SSDT)
I thought that this might be a quieter week, but once again there are a whole host of updates from Power BI updates, to SQL Server 2017 announcements. Quite a bit to read through so I hope you enjoy it. Power BI – Community Blog Highlights I actively participate in the Power BI Community, as well as when I feel…
BI-NSIGHT – Power BI (Desktop Update April – Quick Measures Preview – Mobile Apps Summary – Video Gallery & Ask a Partner Anything – View Related Content Pane – Sneak Peak add new Columns from Example – Tracking Adoption via Power BI Audit Logs)
There has been a whole host of updates and interesting things in Business Intelligence in the past weeks, so please find below the updates. Power BI – Desktop Update April This month’s Power BI Desktop update for April has a whole host of great updates and new features this month, which I will highlight what I think is most relevant…
BI-NSIGHT – Power BI (Granular Tenant settings, Amazon Redshift connectivity in Power BI Service, Featured Data Stories, Availability Monitoring Publish to Web) – Excel (Get & Transform updates) – SQL Server (DAX support in Report Builder and SSMS)
Here are the weekly updates. Power BI – Granular Tenant Settings I can personally say that I know a few of my clients who are very happy that the Power BI team has already implemented the Granular Tenant settings for Power BI. I have to say that I am once again impressed by the Power BI Team really a great…
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 – Multiple Power BI Announcements – Cortana Analytics – Particle and Microsoft – Azure Data Catalog – Power Query Update
So the past week has been filled with a whole host of announcements, particularly in the Power BI space, but as well as with Microsoft’s cloud based solutions. A lot of the information that I have found due to the current World Partner Conference! So as we do every week, let’s get into the amazing details. There is quite a…
BI-NSIGHT – Power BI for Android Devices – Power BI Designer vs Excel – Power BI Refresh for On-Premise – Power BI Refresh from OneDrive – Power BI Interface Updates
Whilst I thought that this week might be a bit on the quiet side, I think that my previous suspicion is correct, and the wonderful people from Microsoft like to send out updates on a Wednesday. Power BI for Android Devices I was just browsing through twitter and I came across a tweet and clicked on the link, not entirely…
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,…