User Profile
SofiaFernandez
Copper Contributor
Joined Jul 18, 2021
User Widgets
Recent Discussions
Analysis Services Community
Hi everyone, I'm not sure if this is the right place for this question, but I can't find a specific community for SSAS projects. Anyway, I hope you can help me with this doubt: I have a Tabular project using Visual Studio and SQL Server Analysis Services (SSAS), with the aim of viewing the data in a Power BI report in Direct Query mode. My question is, why do I have to process the table in Visual Studio, deploy the solution, and then process it again in SQL to see the data refreshed in Power BI when I make changes to the project? Is there a more efficient way to handle this? Why do I need to process the table twice—once in Visual Studio and once again in SQL after deploying? For example: I changed the data type of a column in my table, and I don’t see the change until I go through the previous steps I detailed.I need a query to get pk, fk, indexes, references tables and attributes in sql and export to excel
Hi everyone! , I want to get with SQL all information about all the tables in my database, whit this order: First, the Table Name, Attribute, Data Type, Lenght, Constraint(PK, FK), and ReferencesTable. Because I'm doing a dictionary of data in excel. So I want to export the result of that query to my excel. For example this query brings me the PK for all the tables that I have in my database: select schema_name(tab.schema_id) as [schema_name], tab.[name] as table_name, pk.[name] as pk_name, substring(column_names, 1, len(column_names)-1) as [columns] from sys.tables tab left outer join sys.indexes pk on tab.object_id = pk.object_id and pk.is_primary_key = 1 cross apply (select col.[name] + ', ' from sys.index_columns ic inner join sys.columns col on ic.object_id = col.object_id and ic.column_id = col.column_id where ic.object_id = tab.object_id and ic.index_id = pk.index_id order by col.column_id for xml path ('') ) D (column_names) order by schema_name(tab.schema_id), tab.[name] I try many queries but I can't create one that brings me in ONE query all that information that I want. It has to be IN ONE QUERY. I put here an example for the columns that I need. I hope you can help me! Thanks.
