Tag: Power Query

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 (Mobile App Update, Prevedere Content Pack, Visuals, Where is my Data Stored) Excel – (Power Query Updates)

Here are this week’s updates, which there are quite a few and I have no doubt that there might be some more updates released tomorrow or in the coming days. Power BI – Mobile App Update There have been quite a few updates with regards to the Mobile App in for Power BI and Reporting Services. It is great to…

BI-NSIGHT – Power BI (May Service Update, Q&A for Enterprise Gateway, Solution Templates, UserName() in Power BI, Local Excel Files Upload, Download Dashboards / Reports to .pbix file, Forecasting Feature, Webinar Intro to Power BI for the Excel User – Newsletter

Here are this weeks updates Power BI – May Service Update There is a whole host of updates to the Power BI Service this week, and some great additions. The first improvement is the increasing in the file size to 1GB. And whilst we all know that the compression is really good with Power BI and Power Pivot, there are…

BI-NSIGHT – Power BI (Mobile App Update, Waffle Chart Visual, Alpine Metrics Content Pack, KPI Indicator Visual Explained) – SQL Server 2016 (Hear from the Engineers, Virtual Lab, KPI Data Refresh) – Excel 2016 (New Functions, Power Query Update)

There has been a lot happening in the BI space over the past week. Loads of things to read about and review and see how this can be integrated and used. So without any further delay let’s get into the details. Power BI – Mobile App Update They have made some great improvements to the Mobile App, currently only for…

BI-NSIGHT – Power BI Desktop (Monthly & Service Update) – Excel 2016 (Add-In for Machine Learning) – Power BI (Sankey Visual, Power BI Community, Office365Mon Content Pack)

As this year begins to really wind down it is good to see that the Microsoft machine also appears to be having a break. I have no doubt that in 2016 it will be full steam ahead and back into the swing of things. And before I could finish this blog post I checked if there was any news and…

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…