Hi, I am using Gen 2 Dataflows to extract data from our Dynamics 365 application. We use Dynamics 365 in two separate sites, US and Spain. My problem is that these are not on the same domain. They have been set up under different domains. Spain uses user@mycompany.com whereas the US uses user@mycompany.net. I have no problem getting a connection to either one from Fabric. However, I cannot connect to both. I have set up two dataflows, one for US and one for Spain. If I put in the correct credentials for the US it changes the credentials on the dataflow for Spain. This causes it to fail. The opposite is also true. Is it possible to overcome this problem? Thanks, Fergus

Sorry this is a bit long. Does anyone else find that Fabric is a little less stable than you would expect? I've been working with Fabric for the past few months. I see it as the ideal tool to answer our data extraction and reporting needs. Initially I was using a trial capacity as a proof of concept. There were a few issues there that I put down to the fact that I was using trial and not paid for capacity. The proof of concept passed and I bought some F2 capacity. We are small and will not be putting much load on the platform after I get everything set up. The first thing I noted on moving from trial capacity is that there is no way to bundle everything you've done and bring it to another workspace. I put this down to Fabric not being a fully finished product, which it clearly is not. Bummer. So I recreated everything again on my development workspace. Took me a week. There were existing reports in this workspace published directly from Power BI Desktop. When I overburdened the F2 capacity of this workspace, these wouldn't run either, even though the contained no "Fabric" specific elements. So bad idea to mix Fabric and non-Fabric elements in the one workspace. I created another workspace solely for Fabric development. Another move. But this time I had the deployment pipeline. That should make things easier. No. It doesn't move Gen 2 Dataflows. It moves data pipelines but leaves dataflow steps pointing at the dataflows in the previous workspace. To correct this is as much work as to create them new. Once I had everything moved I deleted everything from the Power BI workspace that had anything to do with Fabric, so that I could remove the Fabric capacity from it. However, one dataflow was left in "publishing" mode. For 5 days. Never moved to refreshing mode. I eventually had to raise a support ticket and delete the thing using an API call. Onto my current F2 development environment. I started running into performance issues immediately. I downloaded the Fabric Metrics App. Apart from not understanding any of the graphs, it only shows what happened up to midnight on the previous day. I need something that shows me what's eating all my capacity now and allows me stop or pause it if I need something else to run. And it needs to be easy to understand.

Hi, I've been testing Fabric on my own workspace and I'm quite happy with the results. We have purchased Fabric capacity and applied it to our dev and production workspaces. Most of what I developed in testing will be used for our live environment. My question is how do I move all the content (dataflows, databases, pipelines, etc) from one workspace to another? I do not want to overwrite the dev and production workspaces as they are currently in us. I thought I could package up the contents of My Workspace and then just import them into another workspace but I haven't found a way of doing this. Am I missing something? Thanks, Fergus

Microsoft have dropped a pretty lengthy article today that I think many of you will find interesting: Read here: Mastering Enterprise T-SQL ETL/ELT: A Guide with Data Warehouse and Fabric Pipelines Think I might have to replicate this for a video 👀

Welcome to all new members, here's some links and information to help you get started! 𝗤𝘂𝗶𝗰𝗸 𝗟𝗶𝗻𝗸𝘀 𝘁𝗼 𝗴𝗲𝘁 𝘀𝘁𝗮𝗿𝘁𝗲𝗱 - For an introduction to this community → Explore the Welcome Pack - New-ish to Fabric? → Check out our Fabric Foundation module - Studying for the DP-600? → Check out the DP-600 Module and the DP-600 category - Studying for the DP-700? → Check out the DP-700 Module and the DP-700 category - Want to get hands-on? → Check out Fabric Dojo 𝗛𝗼𝘄 𝘁𝗼 𝗲𝗻𝗴𝗮𝗴𝗲 𝘄𝗶𝘁𝗵 𝘁𝗵𝗲 𝗰𝗼𝗺𝗺𝘂𝗻𝗶𝘁𝘆? - Share your knowledge and experience! Even if you're relatively new to Fabric, or the community, your opinion and experiences are valued here! A great way to earn your first point(s) is to introduce yourself in the thread below 👇😀 Thank you for engaging and joining us on this exciting learning journey! 🙏 Will