@Pavan Kumar Thank you for your response! It's actually a specific scenario I was exploring with some colleagues. --------------- From the second link you sent me, in the "Sharing Access to SQL Endpoint" section, it seems like it's possible to grant read permissions to the SQL Endpoint without granting access to the workspace with a role. However, we've tested this very scenario (both cross-tenant and within the same tenant), and users can't connect to the SQL Endpoint. At the end of the day, it seems like the viewer role is necessary 🙂 So, this post could become: has anyone tried this scenario? If so, did they come to the same conclusion?😄

@Sachin Satkalmi do you see the tables in the default semantic model on Power BI Service? Can you paste some screenshots of what you see? 🙂

Last thing to check: Are tables hidden in the semantic model? Because, if all tables are hidden, you will not see them in Power BI Desktop (only in the "model view"). See the attached screenshots 🙂

Hello Son, the option "Mark as date table" is available for default and custom semantic models on Power BI Desktop and Power BI Service 🙂 As for the "Sort by Column", you should see the option in the Advanced section of "Properties" (after selecting a column from a table).

@Ravi Dhanwani Well, I dedicated part of my Christmas time to studying for the exam. I just followed the Microsoft E-learning materials and scrolled through the whole Fabric documentation for additional information. As always, trying things on Fabric was crucial to understanding everything better 🙂 I would say that the effort was greater compared to the DP-600 because of the topics covered by the exam and because I am a Power BI guy 😄

@Antony Catella is right! 😄 in general, there seems to be no longer that extreme need to be super-expert in programming thanks to AI. HOWEVER, it is important to know the basics of the languages you use, even with Fabric and also with Copilot there to help you. Going back to your question: the code is moderately advanced; however, if you know the basics of Python, even without fully understanding the code, you can answer it by taking advantage of a bit of logic 🙂

Happy New Year, everyone! For sure, DP-700 (I just booked the exam for the 6th of January) :D

Hello @Antony Catella ! I think it went well but let's wait for the final result 😅 As already mentioned by other people online, the questions were all around these topics (here I just added a few comments about what I remember): - Optimization (VACUUM, OPTIMIZE, V-Order): how to optimize parquet files, delete old files, etc. - Monitoring (pipeline, semantic models, real-time): I remember one question about real-time monitoring, something like "where to find details when an error occurs". - Permissions (roles and sharing): questions on domain, workspace, and item-level roles (i.e. which role you need to modify items or to do specific things). - Data Ingestion (pipeline, real-time, shortcuts, cache): which is the best ingestion service in specific cases, questions on real-time ingestion, and shortcuts (especially regarding cache and when to use them). - Deployment pipeline & Versioning: no questions regarding GitHub/AzureDevOps, but several questions about Deployment Pipelines (i.e. when to use them, what items and metadata go from one level to the other, etc.). - Questions on coding (especially KQL; some questions about Spark and SQL). Questions were about query optimization, sorting, filtering, key creation, datatype conversion, merge. - No questions on Power BI, Power Query, or DAX. - Two use-cases (questions regarding item-level roles, ingestion, incremental refresh, shortcuts). In general, a lot of questions were about Real-Time (ingestion, query optimization, KQL syntax) so my suggestion is to read the Microsoft documentation in details. Moreover, for some questions, correct answers can only be given if you use some services every day because it's almost impossible to remember everything (e.g., where I can find something, where I have to click, etc.) Still in beta so I need to wait for GA to know the result 😀 we'll see! Samuele