Forum Discussion
Cannot Add additional table to Datamart
- 1 year ago
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 Learn
If 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.