Dax Studio - Python Connection
Hello All, There is a plan to move data source from one database to another for which it would be essential for us to understand the dashboards within a workspace. I have explored few options in Dax Studio which has capability to return Measures, Columns, Catalogs (Dashboards) and other details of a specific workspace. However if I need to get a detailed inforamtion across all the Power BI Dashboards in a workspace, the commands below would not allow me to. SELECT [CATALOG_NAME] FROM $SYSTEM.DBSCHEMA_CATALOGS SELECT [CATALOG_NAME] FROM $SYSTEM.DBSCHEMA_CATALOGS, SELECT [ID],[Name] FROM $SYSTEM.TMSCHEMA_TABLES WHERE NOT [IsHidden] SELECT * FROM $SYSTEM.TMSCHEMA_COLUMNS WHERE NOT [IsHidden] SELECT [ID],[TableID],[Name],[QueryDefinition] FROM $SYSTEM.TMSCHEMA_PARTITIONS SELECT [ID],[TableID],[Name],[Expression] FROM $SYSTEM.TMSCHEMA_MEASURES WHERE NOT [IsHidden] SELECT * FROM $SYSTEM.TMSCHEMA_RELATIONSHIPS Requesting your guidance if there is a way I can loop through all the commands above and get the data into Excel format or into SQL or connect to Power BI directly so that I can analyze it further. Regards Mithun THeader row missing quotes when using DAX Studio
Hello Community! I'm using DAX Studio 3.2.0 to export a Table from PowerBI (the table has 320k rows so the reason for using DAX Studio). It is working perfectly EXCEPT that the header row does not contain quotes... the rest of the entries are wrapped in quotes. Is there a setting I need to change? Below is my simple query to get the table out of PowerBI: // My Query EVALUATE( myTable ) Look forward to your help Ray
Running total in Dax Studio
Hi There, Could anybody held with this Dax Query. I Group Sales by month and created a raking, as following: DEFINE VAR Sales = ADDCOLUMNS ( VALUES ( 'DIM PRODUCTO'[PRODUCTO]), "@SalesMonth", CALCULATE([VENTAS EN UNIDADES], 'DIM TIEMPO'[AÑO-MES]="2024-03") ) EVALUATE ADDCOLUMNS ( Sales, "Rank", RANKX ( Sales, [@SalesMonth] ) ) ORDER BY [@SalesMonth] DESC This is the result: Is there any way to do a running total based on this result? Thanks
DAX Studio not returning all results
Hi All I have a table in a PBI Dataset with few hundreds thousands rows and one of the columns is "Clients" . If I do EVALUATE VAR JustClients = DISTINCT('MyTable'[Client]) Return JustClients or EVALUATE VAR JustClients = Summarize('MyTable', 'MyTable'[Client]) Return JustClients in a DAX Studio, it returns 64 rows But if I do the same in PowerAutomate flow or PBI Desktop - it returns over 4k rows (which is correct) So the question is - why its not returning all the rows in DAX Studio? ThanksHow to Open my Dax Studio from cmd.
Hi Friends, i am working for Client. I am connecting through VPN. All the Power BI Desktop tools have to open through cmd. I opened power bi desktop using cmd. runas /netonly /user:abc "C:\Program Files\Microsoft Power BI Desktop\bin\PBIDesktop.exe" it worked and opening . Now i want to open DaxStudio in same way. i tried by giving runas /netonly /user: abc "C:\Program Files\DAX Studio\bin\DaxStudio.vsto" But failing to open. Getting some error. Can you please guide how to open. Thanks
DAX Studio - DMV Queries - Where LIKE Condition Expression
Hello all! I am exploring this ability in Dax Studio to query measures by their names and expressions via the 'DMV' tab: I have a question about how to query the measures with these objects. I can run a query with a where clause that is equal to or not equal to something like this: But what I would like is a query that can evaluate a string CONTAINED in the expression (In SQL they use a 'LIKE' expression). I looked at a lot of examples, but the documentation about the features for these queries are very limited and none refer to this kind of query. I'm going for something like: Any help would be greatly appreciated.
Self-Query Tool
Not sure if this is the right place to ask this so forgive me if its not. I'm looking to find a tool that is easy for business analysts to use for self-querying and extracting/exporting data from Power BI datasets. DAX Studio is great and, for the most part, very easy to use. However, when it comes to logical OR conditions and nested filtering (nested ORs, ANDs) there doesn't seem to be any easy way to do this. Instead it requires manual manipulation of the DAX code. Analyze in Excel is also great but it too (and Pivot Tables in general) doesn't seem to have a way to do complex filtering nor long list filtering. It would be great if the business analysts would just learn DAX but, in my organization at least, there is not a willingness to expect that from the analysts nor the will/resources to train them. Same goes for SQL. Plus, mastery of DAX can be a very long, difficult road. Looking for a drag and drop type experience. Thanks in advance for any suggestions as to tools I can take a look at.
