TabularEditor / TabularEditor3

Bug reports, feature requests, discussion and documentation for Tabular Editor 3 (commercial version).
65 stars 7 forks source link

Unable to Save changes to Direct Lake dataset #979

Closed tlanza89 closed 1 year ago

tlanza89 commented 1 year ago

Describe the issue I am trying to edit a direct lake dataset using version 3.10.0 (Enterprise), but I receive an error when I save. I have XMLA read/write enabled and I'm on the Fabric trial.

Which version are you currently using? 3.10.0 Enterprise

To Reproduce Are you connected to SSAS/AAS/Power BI or working offline? Connected to my Fabric workspace.

Steps to reproduce the behavior:

  1. I'm simply duplicating a measure as a test (Inv Amt-copy)
  2. Hit ctrl+S to save.

Expected behavior Expecting TE to properly save my changes back to the service.

Screenshots image

Desktop (please complete the following information):

Additional context I've been using Tabular Editor to manage my models via XMLA for over 1 year now. Import models work just fine.

Thank you!

mlonsk commented 1 year ago

Hi @tlanza89

The issue you are facing is that the XMLA endpoint of your Fabrical Trial tennant is not set to read/write. This is a different setting than the Power BI XMLA endpoint.

In the Fabric admin portal you need to navigate to Capacity Settings > Trial and then choose your trial:

image

Inside the trial settings under "Power BI Workloads" you will find the setting for XMLA read/write. image

It is documented by Microsoft here: https://learn.microsoft.com/en-us/power-bi/enterprise/directlake-overview#enable-xmla-read-write

Hope this helps