Hello, I´ve been going through the learning path on the MS learning for the certification. It was going quite nicely until in the last part I realized the path actually assumes I know something about PowerBI. The thing is, I really don´t know about it much and did not realize this when starting out. I have some experience of Tableau so I´m not completely beginner with BI tools. What level of knowledge should I have to comfortably to be able to pass e.g. the DAX questions? Do you have some suggestions for e.g. MS learn modules that suites this purpose? Considering getting the PL-300 cert at some point but I´m focusing on my data transformation and modeling skills for now (and my Fabric trial is running) so not going to go through process yet.

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.

1. 📖 GET UP TO SPEED: Read everything in here: #Welcome to the community! - it's a short course to help you understand the community, why it exists, what you can do here, and the community guidelines. 2. 🤝 INTRODUCE YOURSELF in this thread below! We're a friendly bunch, all with the goal of learning Fabric. Not sure what to say? You can use the template below: Hi, I'm ___, I'm from ___, I work in/ as a ___ I'm really interested in learning more about _______ ? Thank you for engaging and joining us on this exciting learning journey! 🙏 Will