Forum Discussion
Cannot Add additional table to Datamart
Hi All,
I have a Datamart where I have some tables imported from MYSQL Database.
I want to add an additional table to the Datamart for visualization in Power BI.
My way:
Go to Power Bi Service
Open Datamart
Click on one of the present table and Edit.
DUplicate the table
On the duplicated table, go to advanced editor and change the schema and table name
Save changes.
When i do all of this I get error while saving:
Activity ID: 1b0937f8-93e2-7e36-687c-ed5974e81351
Request ID: 8fe42fb0-91dd-4398-b666-baaa53e9d894
Status code: 500
Error Code: DmsPbiServiceUserException
Batch ID: ea44f236-b9f3-424b-9235-ec30e5dc9957@c9845881-4a5e-421d-9df7-d3c3bd8aa715$2025-02-17T11:38:26.0523220Z@06fd865f-a27c-455b-864b-74c874a08fc8
The error message also says my database is in a blocked state
Hi Anonymous
Could you make sure that all the tables are loaded in your datamart before you copy a new table and then edit it to see if that works?
3 Replies
Hi Anonymous
Could you make sure that all the tables are loaded in your datamart before you copy a new table and then edit it to see if that works?
Hi Anonymous,
Thank you for reaching out to the Microsoft Fabric Community Forum.
After thoroughly reviewing the details you provided, here are a few workarounds that might help resolve the issue. Please follow the steps below:
- Confirm that you have the necessary permissions to modify the Datamart by checking with your Power BI admin or workspace owner.
- Note that Datamart is still in preview and has certain limitations, such as the lack of support for DAX tables, dynamic slicers, and measure tables.
- Verify that the database is not in a blocked state by accessing it directly using a tool such as SQL Server Management Studio. Sometimes, refreshing the Datamart in the Power BI service can resolve the issue. Navigate to your Datamart and attempt a refresh.
- If refreshing does not resolve the issue, consider republishing the Datamart. This process involves deleting the current Datamart and recreating it with the same data sources and configurations.
- Ensure that your data source privacy level settings are correctly configured, as incorrect settings can cause issues with data import and refresh.
Also, please refer to the following link for better understanding about Datamart:
Get started with datamarts (preview) - Power BI | Microsoft LearnIf this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.
Best Regards.
Hi Anonymous,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
