Tag: api

Aug 27 2024

Business Intelligence, Technology

PowerBI : refresh a PowerBI semantic model from a SQLAgent job step

by mattias

No Comments

The data warehouse technologies and architectures are changing at ever faster pace. Many organisations still have a large investment in a full SQLServer stack to load their data warehouse, but...

api, dataset, etl, PowerBI, powershell, refresh, ssis

Aug 02 2024

Business Intelligence, Technology

PowerBI : bulk PDF generation

by mattias

No Comments

Generating a PDF from a PowerBI report is simple, there is even a button for that. Or you can subscribe to one and it appears daily in your mailbox. The...

api, export, generate, PowerBI, reports, REST

Jul 30 2024

Azure, Business Intelligence, Technology

Fabric : Introduction to Fabric API

by mattias

No Comments

With Fabric taking a more and more prominent role in working with data and organising your data platform, the need for programmatical access or automation is also increasing. Many of...

api, automation, datawarehouse, fabric, powershell, scripting

Nov 09 2023

Azure, Business Intelligence, Technology

Use Power BI APIs from Azure Data Factory

by mattias

2 Comments

Prerequisites  The preferred way to use the PowerBI API from Azure Data Factory (ADF) is by using a Service Principal. This has the benefit of not requiring a license assigned to...

adf, api, azure, Azure Data Factory, PowerBI, REST, Service Principal

Jul 26 2023

Business Intelligence, Technology

Change PowerBI report dataset without republishing

by mattias

No Comments

When you try to implement a split workspace setup (Report workspace and Data workspace) in PowerBI starting from an existing set of reports, you could come across one practical challenge...

api, dataset, PowerBI