Create and manage tabular model Table partitions in AAS

Table in a tabular model is a single partition by default.  the large table like FACT TABLE with multi million rows are processed quickly if you created partitioned for this one.

DIM Table  : Keep default single partition

FACT Table : Try to create number of partition as you required based on partioned column like (year, or date )

let

    Source = #"SQL/sqlserver_database_windows_net ;Contoso",

    dbo_Sales = Source{[Schema="dbo",Item="Sales"]}[Data],

    #"Filtered Rows" = Table.SelectRows(dbo_Sales, each [OrderDateKey] >= 20220101 and [OrderDateKey] <= 20221231)

in

    #"Filtered Rows"

Announcing SQL Server 2022 public preview

Announcing SQL Server 2022 public preview: Azure-enabled with continued performance and security innovation is currently available to download public preview. Try latest version of SQL Server 2022 and you will find many cool features.

Announcing SQL Server 2022 public preview: Azure-enabled with continued performance and security innovation - Microsoft SQL Server Blog

Failed to save modifications to the server. Error returned: 'The Column 'column1' in table 'Table1' has invalid bindings specified

Failed to save modifications to the server. Error returned: 'The Column 'column1' in table 'Table1' has invalid bindings specified

To Fix

=ROW(EmpTabele,1)

Failed to save modifications to the server. Error returned: 'Too few arguments were passed to the ADDCOLUMNS function

 Failed to save modifications to the server. 

Error returned: 'Too few arguments were passed to the ADDCOLUMNS function. The minimum argument count for the function is 3.

Column 'Employee_ID' in Table 'Employee' contains a duplicate value '<pii>2727</pii>'

and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table.'

-- This issue based on Relationship 1:M problem on Azure Analysis model/Cube

How to import Favourites from Internet explorer to Edge browser

 

Professional Azure SQL Database Administration eBook

The e-book version of my book Professional Azure SQL Database Administration is available for free here - do check it out.
https://azure.microsoft.com/en-in/resources/professional-azure-sql-database-administration/

Create SQL Login and SQL User on your Azure SQL DB

/*1: Create SQL Login on master database (connect with admin account to master database)*/
CREATE LOGIN MyLogin WITH PASSWORD = '';


/*2: Create SQL user on the master database (this is necessary for login attempt to the database, as with Azure SQL you cannot set the DEFAULT_DATABASE property of the login so it always will be [master] database.)*/
CREATE USER MyUser FROM LOGIN MyLogin;


/*3: Create SQL User on the user database (connect with admin account to user database)*/
CREATE USER MyUser FROM LOGIN MyLogin;


/*4. Grant permissions to the user by assign him to a database role*/
ALTER ROLE db_datareader ADD MEMBER MyUser;


/*Login with the newly created login:

With SSMS  use login name and password to connect directly to user database \ master \

When using contained database used, you must set the here to be able to connect.
*/