Unable to create table because target is power BI desktop or pbit which does not yet support modification of this type

[Churchill59]

Hello,

I do not see any restriction or configuration in the How To. Is it impossible to update a Power BI desktop model?

I get the following error:

Thank you

[christianwade]

Hi, there is work that needs to be done ("Desktop hardening") for Power BI Desktop to safely allow external model changes beyond what is documented here:
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-external-tools#supported-write-operations
This of course only applies if the dataset is the Desktop hosted one.

[gmuenster]

@BAAAASS : Please read the article thoroughly. The article explicitly says this:

Data modeling limitations
All Tabular Object Model (TOM) metadata can be accessed for read-only. Write operations are limited because Power BI Desktop must remain in-sync with the external modifications, therefore the following operations are not supported:
Any TOM object types not covered in Supported write operations, such as tables and columns.
...

So, until Power BI Desktop hardening activities are completed, no external tool can perform write operations to tables and columns in a Power BI Desktop file.

[BAAAASS]

Hi Yes, thank you. I saw this after I sent the message (which I subsequently deleted). The OP & the article specifically talk about Table Creation - instead, I am having issues with Relationships not updating, but measures are updating correctly. My thought was that this is different, but since the article also doesn't specifically say that relationships are allowed updating, I assume that this is also not allowed. All cleared up now, Thanks again! Kind Regards, BAAAASS

…

________________________________ From: gmuenster ***@***.***> Sent: Tuesday, 12 July 2022 13:53 To: microsoft/Analysis-Services ***@***.***> Cc: BAAAASS ***@***.***>; Mention ***@***.***> Subject: Re: [microsoft/Analysis-Services] Unable to create table because target is power BI desktop or pbit which does not yet support modification of this type (#89) @BAAAASS<https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2FBAAAASS&data=05%7C01%7C%7C1f658d9e275f4143776608da63fd312f%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637932236352989535%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=k9vR0j8u4D31X%2BtS55GzGSwjGKgGVioC2m0Gcing1nc%3D&reserved=0> : Please read the article thoroughly. The article explicitly says this: Data modeling limitations All Tabular Object Model (TOM) metadata can be accessed for read-only. Write operations are limited because Power BI Desktop must remain in-sync with the external modifications, therefore the following operations are not supported: Any TOM object types not covered in Supported write operations, such as tables and columns. ... So, until Power BI Desktop hardening activities are completed, no external tool can perform write operations to tables and columns in a Power BI Desktop file. — Reply to this email directly, view it on GitHub<https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fmicrosoft%2FAnalysis-Services%2Fissues%2F89%23issuecomment-1181666497&data=05%7C01%7C%7C1f658d9e275f4143776608da63fd312f%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637932236352989535%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=wrZQtkPYyy6AorRe84YzrZsj4qNMa1k%2F5bQQ2kHBO2s%3D&reserved=0>, or unsubscribe<https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FACH2L2L6YL2R2HTCUEB5DRDVTVMFBANCNFSM4WYSQNWA&data=05%7C01%7C%7C1f658d9e275f4143776608da63fd312f%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637932236352989535%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=C06KsUcUsctWY%2BQSE%2BLLeUd6I7pzt2uqOXmYXcjDcJc%3D&reserved=0>. You are receiving this because you were mentioned.Message ID: ***@***.***>

[christianwade]

No worries. I hope some additional dataset hardening for Desktop beyond what is documented as supported today will show up for foundational tabular objects in the 1st half of 2023 CY.

[Kpham-RDMKR]

@christianwade
Hi Christian,

I'm running into the same problem as @Churchill59. I cannot update tables or relationships in my desktop version. I have read your comment about "desktop hardening" and I can't really figure out how to finish the desktop hardening. I can see that the JSON file is in the correct folder:
"C:\Program Files (x86)\Common Files\Microsoft Shared\Power BI Desktop\External Tools\almtoolkit.pbitool.json"
Can I do something so that the I can sync with the Power BI desktop or is this impossible at this moment?

Thank you in advance

Khoi

[christianwade]

Hi all, sorry for delayed response. Power BI Desktop hardening is required to make this happen. It's being done, but not ready quite yet ...