-
Microsoft Fabric Cost Optimization: Pause Capacity & Reservations
Microsoft Fabric offers a powerful analytics platform with entry-level pricing starting around CHF 300/month for Swiss users. This post explains how Fabric capacity billing works and details two key strategies for reducing operational costs: reservations and pausing idle capacities. It is intended for both newcomers evaluating Fabric and professionals seeking to optimise enterprise spending. Fabric Pricing…
-
How to Handle API Pagination in Power BI
Getting data from web sources in Power BI is often straightforward with an HTTP request to a web service. The Power Query M formula language provides the Web.Contents function, which can retrieve results from APIs. However, most APIs impose limits on the number of results returned per request – a mechanism known as pagination. To…
-
Asana Power BI Report
We are working on multiple projects with Asana and wanted to have insights over some project and task management KPIs within Power BI. There is a dedicated connector within Power BI to integrate data from Asana. However, the licensing requirements to use the connector are the enterprise or enterprise+ tiers. We had a look around…
-
Google Analytics 4 Data in Microsoft Fabric
Google Analytics 4 data is essential for understanding website performance and user behavior. The native dashboard is great for initial analysis but there are other use cases where it is just not quite enough. What if you want to export the data to combine it with other sources? Or give new users the required permissions…
-
Login to Power BI with Guest Account
As a Power BI developer you are sometimes working for different organizations and have to access multiple tenants. To do this, you either have a dedicated account in each tenant or you are added as a guest to an organization. Accessing Power BI in an external tenant via browser at app.powerbi.com or via Power BI…
-
Automated Power BI Testing with Selenium
Working with Power BI can become challenging as the size and complexity of your workspaces increase. Initially, managing a few reports linked to your dataset is straightforward. However, as the number of reports and their dependencies grow, keeping track of everything becomes more difficult. Power BI offers the option to see, what artefacts in your…
-
Analyse bexio Data with Power BI
Like many other SME in Switzerland, we are using bexio as our administration and accounting tool. bexio allows for some limited standardized reporting within the service but we needed more flexibility. So we created our own report with Power BI, focusing mainly on two points: Our report allows to compare liquid assets year over year…
-
Implementing Fabric Eventstream & Data Activator With Real World Data
Understanding a tool’s utility is directly proportional to our knowledge of its use. This blog post aims to evaluate the advantages and disadvantages of using Fabric Eventstream & Data Activator with real-world data. We aim to achieve this while minimizing infrastructure requirements and costs. In essence, this post demonstrates how to implement continuous location data…
-
How-To Access Azure Key Vault Secrets from Fabric Notebook
This blog post focuses on how to handle authentication within Fabric Notebooks using secrets without storing them in your code. To access Key Vault from a Fabric Notebook, use the PyTridentTokenLibrary to handle the call while using an access token. Specify the name of the secret in Key Vault and provide the URL of the…
-
Building AI Apps – Quickly And Efficiently
What can Artificial Intelligence (AI) do for your business? An interesting question which, at the moment, seems to have an answer more anchored in hype and less in reality. We at syntera believe, that AI is here to stay and the gap between hype and reality is closing – At last, the current state of…
