Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

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

Closed
Churchill59 opened this issue Jan 29, 2021 · 6 comments
Closed

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

Churchill59 opened this issue Jan 29, 2021 · 6 comments

Comments

@Churchill59
Copy link

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
Copy link
Member

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
Copy link

@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
Copy link

BAAAASS commented Oct 11, 2022 via email

@christianwade
Copy link
Member

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
Copy link

@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
Copy link
Member

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
5 participants
@BAAAASS @christianwade @Churchill59 @gmuenster @Kpham-RDMKR