How to Automate and Customize Power BI Deployments with CI/CD Pipelines
If your organization is utilizing Power BI Premium Capacity for your Power BI reporting, deployment pipelines are an easy feature available to help manage and move Power BI content through development, test, and production workspaces. Although the out-of-the-box deployment pipelines can be very useful, there are times when the deployment requirements necessitate using a customized […]
How to Write Data to Snowflake From Azure Data Factory
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 […]
Leveraging SharePoint to Streamline Excel Usage in Power BI
Power BI is a business intelligence platform that equips individuals and businesses to generate insights by connecting to their data and building interactive reports and data visualization. Excel files (xlsx) are a common type of data source file that Power BI can connect to for building these reports, and these files can be stored locally […]
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
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 […]