search

microsoft / Analysis-Services

Git repo for Analysis Services samples and community projects
MIT License
576 stars 403 forks source link

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

Closed Churchill59 closed 3 years ago

Churchill59 commented 3 years ago

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: image

Thank you

christianwade commented 3 years ago

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 commented 1 year ago

@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 commented 1 year ago

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)

@BAAAASShttps://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 GitHubhttps://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 unsubscribehttps://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 commented 1 year ago

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 commented 1 year ago

@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 commented 1 year ago

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 ...

BadAtDax commented 2 weeks ago

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 ...

Is it ready now? :)

christianwade commented 2 weeks ago

Nope 🙂 Copying @RuiRomano for viz