Forum Discussion
Helper IMigration of a data mart and licensing (Fabric + PowerBI)
Super UserAnyway if its really datamart:
- Can anyone explain me a correlation between a Workspace license (Fabric / PPU) and personal license (I have free, my key user has PPU)?
- Simplified, Fabric licensing is broken down 2 types, user license and organizational license. Organizational license are applied on workspaces, the higher the license sku, the more compute power you get for the operations.
User license is for user, but broken down further to free/pro/PPU. Free has limited functionalities mostly for personal reporting. Pro is for collaboration with other users and accessing workspace. PPU is for extra compute and functionalities. PPU can also be applied on workspace, but everybody in the workspace and anybody consuming items in the workspace (eg report users) must have PPU - Will my Data mart be disabled / "dead" after my Trial expires?
-No, anybody in the workspace will be able to Take Over the datamart - What is a best way to migrate my data mart to a PPU-Workspace and re-assign a new ownner?
- Just turn the current workspace to PPU and ask new owner to Take Over
Helper IHello,
I created an object of type "data mart". Thanks for you hints, but I have following concerns:
- The workspace where my datamart is located has license type "Fabric", because it is used as target workspace for data export from PowerPlatform (using Azure Synapse Link). Will changing the license type (Fabric -> PPU) break that data export?
- Unfortunatelly, I do not have "Take over" button im my interface:
There is no button between "last changed by" and "description".
My idea is to find a way to move that datamart from "fabric"-licensed workspace into "ppu"-licensed workspace. Unfortunatelly, no way found yet.
kind regards from Hamburg
- Tutu_in_YYC
I think you may not have the correct Role in the workspace. You must be a "Member" to take over items in the workspace. Can you check if you have the correct role?
As for migrating, i havent found an easy way yet. You may have to recreate using the M query in advanced editor or create a template (pqt file, see picture below,), create the new semantic model, and then you can re-point your existing report to the new one.Update: i just checked if we could import pqt file into datamart, doesnt look like it is possible. But you can definitely create dataflows with the pqt and a semantic model separately.
- Andrey_Hamburg
Hello,
I'm an Administrator of the workspace. But I suppose, there is no "Take over" -button for an object of type "data mart". Because I saw this button on a semantic model and object of type "Warehouse".
I will try to use Power Query Template, thanks for the hint. If it does not work, I decide to rebuild my solution using object of type "Warehouse".Kind regards from Hamburg
- Tutu_in_YYC
Yeah it is so odd that you dont have the "Take Over" button, because i have it on mine.
Rebuilding it is probably the next best option, shouldnt be too hard with either PQT or the M queries in the advanced editor. Alles gute!