First steps in Fabric · Learn Microsoft Fabric

7d ago (edited) in Technical

First steps in Fabric

Firstly, I would like to express my excitement about joining this community. I can't wait to hear your guys' ideas and feedback.

Secondly, this is my first post here besides the meet-and-greet post (please give me a thumbs-up there to help me win points towards the next level), and it's hard to decide what question to ask first.

But before I ask anything, I'd like to share my test (not so much) workspace I've created in the past couple of weeks just by watching YouTube videos, especially from Will's channel, Learn Microsoft Fabric with Will, without any experience in Data Engineering, Architecture, or any other skills of that nature (first picture). I could say I have some (beginner) skills in Power Query, and that's all.

Without further ado, my first question (that might be multiple in one) concerns the first letter of ELT: Extract.

I have a pipeline extracting tables from the company's ERP SQL database, but of the 26 tables, 3 have column names with spaces, which gives me an error (second picture). The error message for all tables is the same, only changing the column name, obviously (third picture). I've created a For Each in the pipeline, trying to get the column names to make a condition for when the column has a space character substitute for an underscore (_) character, but my skills are limited, and I can't get to the bottom of it.

The question or questions would be: Is this the right approach, or is it even possible? Is there a better way of extracting these tables without contacting the ERP team and requesting they fix it?

I've tried some YouTube solutions, but most videos are three or four years old and use Azure Data Factory instead of Fabric.

Just to clarify, all other 23 tables, without the error, are up and running in the Lakehouse.

I'm sorry if I extended myself with this post. I am hoping to get some great ideas and feedback from you guys. I appreciate your time and attention.

0 comments