In the latest video (Transforming data | PySpark, T-SQL & Dataflows in Microsoft Fabric) @ 8.57 it says that after deduplication of the revenue data set, the results can be saved into another table or another downstream activity. I know the sql-endpoint of a lakehouse is "read" only. So, how would I save the results of a deduplication query to another file in the Lakehouse. Even tried to a DW but the command is always rejected. -- deduplication CREATE TABLE [LH_BRONZE].[dbo].[dedup_revenue] AS ( SELECT [Dealer_ID] ,[Date_ID] ,max([Revenue]) 'Revenue' FROM [LH_BRONZE].[dbo].[revenue] GROUP BY [Dealer_ID],[Date_ID] ) This command is rejected, says "CREATE TABLE AS SELECT command is not supported"

I'm am trying to take the assessment for one of Microsoft's Applied Skills Credentialing topics; however, it asks me for some type of "Admin" password. It seems to be trying to set up some type of a sandbox. I am the Global Administrator for my 365 account with Power BI Pro, Azure, and Fabric trial licenses. I have only a single login for everything. The attached screen shots show I am correctly linked to my account, second screen shot show that it won't accept my Global Admin password. Does anybody know what password it is looking for here?

Hi All, I'm testing one of leakhouses for one of my exsisting PBI reports and workspace and when I trying to create a new semantic model I have below error: unexpected error dispatching create semantic model to portal ms fabric lakehouse There is no explanation in MS Community web page, I can modify default semantic model in the warehouse but this error is limiting my actions. Do you have any solutions to it? :)

What have you been working on this week in Fabric? I'd LOVE to hear more about what you're building, or what you're learning. So please share you Fabric WINS below (no matter how small)!! Maybe you built your first data pipeline? Or you wrote a Python notebook to transform some datasets? Or you built a Direct Lake semantic model? Or you did some learning modules? What are you currently learning? Looking forward to hearing what you're working on and celebrating your successes!

Hey folks, happy Friday! I just released video 4 in the 12-part DP-600 series. This time we focus on the analytics development lifecycle, so things like version control, depoyment pipelines and some other fun stuff. I hope you find the video useful in preparing for the exam. Let me know your thoughts! If you found it helpful, please do click through to YouTube and leave a comment there, as it helps with the algorithm (apparently 😂)