Power BI

Power BI

9059 bookmarks
Custom sorting
ADF Data Flows: Distinct Rows
ADF Data Flows: Distinct Rows
Below is a method to use in ADF’s Mapping Data Flows to reduce the data stream in your data flows to only include distinct rows. This sample is available as a pipeline template here. Choose y…
tommypuglia·mssqldude.wordpress.com·
ADF Data Flows: Distinct Rows
A visual guide to Azure Data Factory
A visual guide to Azure Data Factory
What is Azure Data Factory and how can you use it? In this visual guide to ADF, we break down the what, why, and how of using ADF for data integration.
tommypuglia·acloudguru.com·
A visual guide to Azure Data Factory
Copying large files from SharePoint Online
Copying large files from SharePoint Online
I recently worked on a project where we needed to copy some large files from a specified library in SharePoint Online. In that library, there were several layers of folders and many different types…
tommypuglia·datasavvy.me·
Copying large files from SharePoint Online
Creating a Lake Database using the Database Designer – Serverless SQL
Creating a Lake Database using the Database Designer – Serverless SQL
Synapse Analytics allows the creation of External Tables and Views within a Serverless SQL Pools database and also a Spark database. These objects can be shared between Spark and Serverless using shared metadata. An example is an External Table created using a Spark Pool that can be queried by using a Serverless SQL Pool. During...
tommypuglia·serverlesssql.com·
Creating a Lake Database using the Database Designer – Serverless SQL
Configure Postman to be easily used with any Azure AD protected API (SharePoint, Graph, custom etc.)
Configure Postman to be easily used with any Azure AD protected API (SharePoint, Graph, custom etc.)
As a developer, how many times have you had a need to test different Microsoft 365 APIs? For me, this is a fairly frequent task. Most often it's SharePoint REST API or MS Graph. Every time you should think about the authentication part because all of... [Click to read more]
tommypuglia·spblog.net·
Configure Postman to be easily used with any Azure AD protected API (SharePoint, Graph, custom etc.)
Extract Data from PDFs at Scale with Form Recognizer
Extract Data from PDFs at Scale with Form Recognizer
In this article, Dr. Tom Weinandy demonstrates a set of tools that can extract, compile, and visualize data from large swaths of intractable files - proving that even data on a PDF can have a second life.
tommypuglia·bluegranite.com·
Extract Data from PDFs at Scale with Form Recognizer