Visual Studio 2017 and the SQL Server Data Tool (SSDT), a tool that comes with Visual Studio, finally integrates the now familiar Query Editor (Power Query) capability to work with the Analysis Services Tabular Model. Query Editor is a data ingestion and transformation tool used by Excel Power Pivot as well as Power BI. Now,
I have run into this a few times now and every time it took me a while to figure out what’s going on, so I figured if I wrote about this on my blog, maybe I would not forget about it next time. Microsoft has a great article here that details how to setup Azure
We have an enterprise job scheduler which is used to execute ETL jobs. The last step of the job scheduler is to refresh the Power BI data set. Here are the steps to do it. Create a Service account in your Azure Active Directory. Assign Pro license to the Service Account. Add the Service Account
October update of Power BI Desktop was released a couple of days ago. One of the key feature update in this release is that the SAP BW Connector now supports additional member properties (attributes). Earlier version of SAP Connector exposed only text value of the BW object. To get additional member properties, we had to have
In the last post, I talked about flattening parent child hierarchy. Building upon that – the next question is how to make sure that an employee has access to only his/her data and that of the employee(s) reporting to them. This can be achieved using Roles in Power BI. In the previous post, we created
I have been working with SAP data source lately. And in SAP dimensions, parent-child hierarchy is very common and there is a need to flatten it in Power BI. A common parent child hierarchy is an employee table. The employee table has a manager column that determines the hierarchy. E.g We want to flatten the
Sometimes, in order to innovate, we have to take a step back before we take two steps forward. What that statement means in the context of this article is a mystery and for many of us such is the difference between Content Packs and Power BI Apps. Microsoft revealed Power BI Apps in this blog
In an earlier post, we talked about self-service process to hydrate the Data Lake Store. We also mentioned the need to use Power Shell to load data files larger than 2Gb. Here is the Power Shell script: Provide your credentials to login to Azure: $MyAzureName = “<YourAzureUsername>“; $MyAzurePassword = ConvertTo-SecureString ‘<YourAzurePassword>’ -AsPlainText -Force; $AzureRMCredential = New-Object System.Management.Automation.PSCredential($MyAzureName,
With recent updates to Power BI Desktop there have been a lot of enhancements to BW connector. The most significant of them is the ability to filter parameters to display only those that are required. This is achieved by clicking on Show on the top right corner of the Navigator dialog and selecting Only required parameters.
Do you have to be a developer in order to implement a solution that ties together Power BI and Azure Data Lake? I argue that you don’t. However, there are a several things that you need to be familiar with before you get going. Therefore, I decided to cover several of them in this article.