Fabric Archives - Ben's Blog

Connect to ODBC data source with Fabric

2024-11-08 Ben Comments 0 Comment

What is ODBC Open Database Connectivity (ODBC) is a set of database access APIs that connect to the database, prepare, and then run SQL statements on the database. An ODBC driver application can access non-uniform data sources, such as spreadsheets, comma-delimited files, and almost any other DBMS (database management systems) such as SQL Server, Oracle, MYSQL, Intersystem etc… Of course, there are pros and cons to using ODBC over a native connector, especially on the performance side, but the advantage…

Read More Read More

Migrate SSAS to Power BI Premium

2024-03-08 Ben Comments 2 Comments

In this post, we will cover how to migrate SSAS to Power BI Premium using Tabular Editor. While there may be some more advanced techniques using scripting to Migrate SSAS to Power BI Premium this post focuses on a simple solution which is probably just fine for most small to medium-sized companies. Why migrate SSAS to PowerBI Premium instead of Fabric? Why Migrate SSAS to Power BI Premium instead of opting for Fabric? Well, surely migrating an on-premise architecture to…

Read More Read More

Pagination in Fabric Notebook Using Fabric Rest API

2024-02-12 Ben Comments 0 Comment

In this post, we will see how to perform pagination when calling Fabric Rest API from a notebook. Note that at the time of writing this post the Fabric REST API is still in preview. What is pagination Pagination is a process used to divide a large dataset into smaller chunks and each smaller chunk contains a pointer to the next smaller chunk until there’s no more chunk. As Fabric REST API limits the number of records it returns it also…

Read More Read More

Generate Large Sample Data in Fabric

2024-02-05 Ben Comments 4 Comments

In this post, we will explore how to generate large sample data in Fabric. Why do we need to Generate Large Sample Data in Fabric? I can think of many many reasons to generate large sample data in Fabric but one of the reasons I see as crucial is for testing performance or to help us decide which tier we should buy for now or in the future. Today, Fabric offers built-in sample datasets, but they may not suffice for…

Read More Read More

Load data from Synapse to Fabric

2023-11-05 Ben Comments 0 Comment

In this short post, we will cover how to load data from Synapse to Fabric or from Azure Data Factory using Sznapse/ADF pipelines. Note that at the time of writing this post the feature to load data from Synapse to Fabric is still in preview.Note that loading data from Synapse to Fabric using Synapse notebooks was already feasible, but these notebooks don’t natively support connections to on-premise SQL databases. Why loading data from Synapse to Fabric In the best world,…

Read More Read More

Enable measure suggestions with Copilot in Power BI

2023-08-29 Ben Comments 0 Comment

In this short post, we’ll explore how to enable quick-measure suggestions using Copilot in Power BI. Quick measure feature in Power BI If you’re not already aware, Power BI has a feature called quick measure that allows you to simply drag and drop columns to generate predefined measures such as time intelligence, Top N, aggregate measures, etc… Another available feature was the Suggestions where you could simply use natural language to ask Power BI to generate the DAX code for…

Read More Read More