PowerBI.Tips - Tutorial - Intro to Tabular Editor
HTML-код
- Опубликовано: 21 окт 2024
- Tabular Editor is an incredible Tool that enables users to manipulate a Tabular Model at lighting speeds. Daniel Otykier is the creator of Tabular Editor. This video will explain the basic functionalities of the program.
Watch the full Series: • Tabular Editor
Download Tabular Editor: tabulareditor....
Learn more about Tabular Editor: github.com/oty...
Have a feature idea submit ideas here: github.com/oty...
Visit PowerBI.Tips: powerbi.tips
Oof. The External Sources ribbon is SOOOO good. massive time saver. Thank you Daniel
It really is!
Could you please advise how does it compare with Visual Studio Tabular mode? Understand that we can use SQL which would be a plus. Thank you
Brilliant!!
Quick question. ~9 mins in you find and replace in notepad++ to make the DataModel.file readable. What is the find/replace criteria? Vid is a bit blurred!!
Cheers
Chris
I'm replacing NULL chars with an empty string. In Programmer's Notepad (which I'm using) this can be done using backslash expressions in find and replace: \0 locates the NULL chars.
@@DanielOtykier using notepad++-->what's programmers notepad?? \0 isn't working
oh, it's another notepad. even installing it & doing the \0 move didn't work. oh well.
@@tenaciousdata9200 you have to enable the checkbox that says "Allow backslash expressions" in the search/replace dialog.
Daniel thanks for the reply!
Thank you for making this tool and this tutorial as well!
Hi , Am using Tabular editor v2.17.2 but there is no Advanced scripting / C# scripting available in that , let me know how to enable this
can we see data in this tool? like the dax studio? I'm looking for a tool where I can test my calculated columns instead of trying to break it down into measure to test it
Wow. This is an excellent tool. Downloading and going to have a go now.
Thanks, that was very informative and tool as good as this one needs more of such presentations. Good work!
Hi Daniel....I am trying to connect Azure SQL DW in Direct Query mode with SSDT and get this error - Failed to save modifications to the server. Datasource has authentication kind OAuth2. This is not supported in DirectQuery 1400 mode.
I read in the MS docs that Direct Query mode is not supported with OAuth credentials.
Need help.
Great tool. Waiting for the External Tools integration in Power BI Desktop which will be a huge productivity boost. I updated a couple of measures in Tabular Editor and pushed to PBI via Save to connected Database. I then refreshed the model in PBI to see the changes. However, it error'd out with the following message: "Expense Meaures - The model doesn't have a named expression named Expense Measures". I am not able to get this go away. Is there a way around this? Thanks.
Hi I tried loading a local pbit file and then changed a measure for testing. However when I save it in TabEditor I still see the questionmark after saving (basically the deployment does not work but I also don't receive an error - nothing happens after saving). Is this not supported so far? Thanks
Editing power bi models are not supported yet. This I coming soon in the next few months.
Blew my mind, Thanks !!!
Why am I not able to edit the Expression of a Calculated Column?
So stoked on this, thanks!
Since tabular editor uses Power BI XMLA Models and Power BI Report Server does not support shared datasets (datasets are internal to PBIX file), would Tabular Editor be useful in this environment?
I think you are referring to an On-prem solution for publishing Power BI files. In my opinion, this is not my recommended solution, I would prefer users consume the content from PowerBI.com. The Report Server on-prem is typically 3 to 4 months behind what is being developed in PowerBI.com.
but as this refers to tabular editor. I would highly still recommending learning Tabular Editor. Tabular Editor can connect directly to Power BI desktop and make bulk edits to the PBIX file.
There are things that you can also only do in Tabular Editor that Power BI desktop does not even support, such as Calculation Groups. This is something you have to modify with Tabular editor. So while you can't modify the XMLA endpoint, the editing of the PBIX file is still quite amazing with Tabular Editor.
Hi there! Does anyone know what happens when you deploy an unchanged model to the SSAS server, when it already has been deployed before? Does that affect anything? So basically I'm talking about what happens when you deploy the same model twice, to the same SSAS server, same target database.
'Mike we can probably arrange for these slides to be shared'. Well are they?
Here: pbitipsblob.blob.core.windows.net/externalshare/Tabular%20Editor%20Part%201%20-%20Part%204.zip
Game changer.