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 – Excel 2016 – Power BI Updates (Including new Data Sources) – Azure SQL Data Warehouse
So after last week, and the annual Microsoft Ignite conference, there was a whole stack of product announcements and updates. This was really great to see, and it once again amazes me how quickly Microsoft is able to get this to market. And being a Microsoft BI enthusiast, it excites me. I mean who does not like to play with…
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…
Power Query – Adding Leading Zero to Number (EG: Month Number)
Below is an example if you have a requirement and you want to add a leading zero Example: You have a Month Number that starts with “1”, and you want it to start with “01” In your Power Query Window, click on Add Custom Column and then put in the following syntax Text.PadStart(Text.From([Month]),2,”0″) NOTE: In the above example, we have…
Error: An Item with the same key has been already added – Unable to load the tables in the Power Pivot Window
NOTE: First thing to do is to make a copy of your Excel Workbook, before making any changes to your Power Query Source. If you do NOT, and change your Power Query source, your Power Pivot Model could become unusable! 1. I had an issue where if I changed the Power Query source from a CSV after I made changes…
Sharepoint 2013 – refreshing excel workbook with direct connection to sql server analysis services (SSAS) cube
I have not blogged in a while, due to moving countries and starting a new job. So i do hope that this blog will help someone or let them know how easy it is to use SharePoint 2013 to refresh data in an Excel spreadsheet. What I needed to do, was to use an existing Excel spreadsheet which connected directly…
Excel–Power Query–Automating SSIS job duration report
Following on from our query to get our SSIS Job duration information, I decided to start using Power Query and see if I could use it to facilitate the automation of my reporting requirements. Detailed below is how and what I archived. Example · We are going to use our SSISDB to see if there have been any changes in…