Editing your Direct Lake Datasets from Tabular Editor? Yes please!

Рет қаралды 10,468

Күн бұрын

Wanting to edit your Direct Lake Power BI Dataset in Microsoft Fabric? Now writing via the XMLA endpoint is supported. Patrick shows you how to use tools to modify.
Announcing XMLA Write support for Direct Lake datasets
blog.fabric.microsoft.com/en-...
Dataset connectivity with the XMLA endpoint
learn.microsoft.com/power-bi/...
📢 Become a member: guyinacu.be/membership
*******************
Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.
🎓 Guy in a Cube courses: guyinacu.be/courses
*******************
LET'S CONNECT!
*******************
-- / guyinacube
-- / awsaxton
-- / patrickdba
-- / guyinacube
-- / guyinacube
-- guyinacube.com
**Gear**
🛠 Check out my Tools page - guyinacube.com/tools/
#PowerBI #MicrosoftFabric #GuyInACube

Пікірлер: 20

@SQLMonger 9 ай бұрын

Tabular Editor 3 is fantastic. One interesting 'save' that it provided me was the ability to edit the server name in the connection string for a cube published to a deployment pipeline. Promoting the cube from the dev to test or test to prod workgroup carries the server name from the lower environment forward. The connection cannot be updated via the web interface but can be using Tabular Editor! Macros for generating measures is also fantastic. Select all your implicit measures, run a macro to build DAX measures and hide the implicit ones.

@ericscott5895 9 ай бұрын

Thank for another great episode 🙏

@ajaaskelainen 8 ай бұрын

This is awesome!

@simonloughnane6683 9 ай бұрын

Hi Patrick, you mentioned git integration and CI/CD. I'd very much like to see a video on how this can / should work with this direct lake approach.

@Gid0717 9 ай бұрын

I would make sure to note that "Direct Lake datasets created or modified by using XMLA-based tools cannot be opened in the Web modelling feature" as that might be of concern for some people

@remek5758 9 ай бұрын

concern people - you mean developers? No one else really touches it :D

@Gid0717 9 ай бұрын

@@remek5758 I tried using it yesterday and ran into a problem where I needed to update my model but now that I cannot utilize the online interface have to either purchase TB3 as TB2 does not have built in functionality to create new tables or direct lake datasets. You have to do this manually or with c#. This to me for new people experiencing modeling in fabric and are learning from tutorials could be a problem when they find out.

@anomalyblaze3037 9 ай бұрын

It does create chaos as we built models using TE3 and the business can't modify them at all since we won't let analysts use TE3.

@TomFrost33 2 ай бұрын

What is the best way to manage the data once it is in the Lakehouse? How do we easily insert\update\delete the data? I would prefer not to have to go thru a bulk insert every time. Thank you

@rohaake 9 ай бұрын

Q: Is it also possible to create field parameters for attribute sliders with tab editor in a direct lake dataset? Right now it is the only feature which I don’t know how to migrate from my old big dataset to my new direct lake dataset.

@Fernando_Calero 3 ай бұрын

This is !!!

@muhammadathar626 9 ай бұрын

Question: I have 5 visuals on powerbi Dashboard. Each one of them has a visual level filter related to different DATES criteria. In order to get an updated weekly report i have to change the dates on each visual every week, Is there any smart way to use only one filter and change all the visual level filters w.r.t DATES (keeping the filter criteria of each visual as intact). Thanks in advance for any answer.

@olbu 9 ай бұрын

May be I don't understand your problem, because I don't understand why you have to set a date filter manually every week instead of using relative date filters or precalculated values at your date dimension, which could be used for filtering date periods. May be, you could share more details?

@mallikareddy8330 9 ай бұрын

Hi Patrick,how are you?

@olbu 9 ай бұрын

Q: We tried to change this settings (implicit measure) with TE2.2 on our "default" "Warehouse" and "Lakehouse" (Fabric) dataset, but we got an error that the object either not exists or we don't have enough permissions to do this. (We could connect to these default datasets, change the setting, but if we save, we get this error). We are Workspace Admins. The warehouse/lakehouse(s) were created by us. XMLA read/write is activated at our capacity. (we could change the settings of a "normal" import-dataset in this workspace). What could be the reason for our problem?

@olbu 9 ай бұрын

Lol, we tried this for days and I just send my question here and found my answer by myself: "Note that XMLA Write operations are not supported with default datasets. You must create a separate Direct Lake dataset, sometimes called standalone or custom dataset." I don't delete my question (better for the yt-Algorithm and may be someone else has the same problem) 😂

@jaysleatherco.585 4 ай бұрын

@@olbu Thank you!! I was actually searching for a solution for this as I had the same error.