BI-NSIGHT – Power BI (Publisher for Excel Public, New Visuals) – SQL Server 2016 (Temporal Tables)
It would appear this week that there is not a lot of news in the BI world. Which is a welcome change. I have no doubt that by the time I am finished this blog post or wake up tomorrow morning there will be some updates! Power BI – Publisher for Excel Public It would appear that I started this…
BI-NSIGHT – Power BI (Pin Excel Range to Dashboard, Weekly Service Update, New Custom Visualizations, Power BI Community, R, VMOB Content Pack) – Azure (Data Science Virtual Machine)
So I have been offline for a little while, quite a few things going on, but I am back on track and here are the latest BI-NSIGHT updates that I have been looking into! Power BI – Pin Excel Range to Dashboard It is really great to see that the Power BI team is realizing that having the ability to…
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 – 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…