How to Write Data to Snowflake From Azure Data Factory

Data from Azure to Snowflake

Like many other ETL tools in the market, Azure Data Factory is just one that allows you to bring in data into your reporting environment. Azure Data Factory can be a powerful tool to use for businesses with pre-existing environments that already have it configured and for organizations familiar with the Microsoft Ecosystem. In this […]

How to Create a Power BI App

We know that Power BI is a robust business intelligence tool. But did you know that with very little effort, you can create a Power BI App for your end users to use? And I’m not talking about the Power BI mobile application or mobile layout. A Power BI App is an effective wrapper for […]

Implementing Power BI Premium Capacity

Implementing Power BI Premium Capacity

Implementing Power BI Premium Capacity This blog was co-written by Spencer Baucke, Gavin Pedersen, Ahmed Ansari, and Spencer Hamilton. Choosing Power BI Premium for your organization is a big decision – one that can really enhance your organization’s analytics capabilities. Moving forward with Power BI Premium is also an investment in your analytics infrastructure, so […]

What Are Power BI Datamarts?

Power BI Datamarts are the newest major addition to the Power BI ecosystem and an indication of the level of investment and overall direction that Microsoft is taking with the power platform. In this article, we’ll share an overview of what Power BI Datamarts are, why they’re important, and finally, highlight some real-world use cases. […]

How to Get Activity Data From Power BI Service with REST APIs

How to Get Activity Data From Power BI Service with REST APIs

In this blog, we’ll cover the importance of gathering event activity data, and how to utilize the REST APIs effectively to do so. This process will entail everything from understanding all of the different operations within the Power BI REST APIs and all the ways to configuring your Azure Data Factory Studio to pull the […]

How to Load Large Datasets in Power BI Desktop Using Parameters

When you try to import large sets of data in Power BI Desktop (think 25 GBs or larger), it can often consume a lot of time and in certain scenarios, the import may actually fail due to limitations of your desktop machine. The good news is that you can use Parameters in Power BI to […]

Power BI Workspace Strategy for Self Service within Premium Capacities

When deploying Power BI, it is common for organizations to overlook having a strategy for what would seem to be a simple task – creating workspaces. It is important for organizations to have a strategy for partitioning workspaces to avoid big problems down the road. As consultants, we’ve come across many organizations that have simply […]

How to Set up Power BI Gateways on Azure Virtual Machines

Whether you are setting up an On-Premise Gateway to provide authentication for an on-premise data source to the cloud or for cloud to cloud connections (such as connecting to the Snowflake Data Cloud), using Virtual Machines (VM) to house your gateways is generally considered best practice for security purposes.  In this blog, I am going […]

How to Create a Bridge Table in Power BI

Within data modeling, the cardinality of a join between two tables describes the relationship between the rows of one table and rows in the other. Common cardinalities include one-to-one, one-to-many, and many-to-many. In a one-to-one relationship, one record in a table is associated with one record in another table. In a one-to-many/many-to-one relationship, one record […]

How to Provision Access to Power BI Workspaces and Licensing

Having a detailed plan for provisioning Power BI licenses and Power BI Service workspace access in your organization will help keep your deployment functioning smoothly and efficiently. This blog will be helpful for anyone who is either overseeing a Power BI deployment or who already administers a Power BI Service instance. In this post, we […]