Відео

If you want to restrict access to individual tables in a semantic model, your only option is to use the semantic model itself. However, if you need to grant access to a specific table for a user accessing it through the warehouse or lakehouse, you can do so without using the semantic model.

@@KeshariDharmendrathanks but my main question was about Tabular Editor having that ability

@rameshpaskarathas6512, did you see any error?

​@@KeshariDharmendra.I get an error below: " Error Details The view could not be created because of the following error. Error Code InternalError Message An internal error occurred."

Replace and drop will remove the access instead give access at schema level. GRANT SELECT ON schema:dbo to xyz;

​@@KeshariDharmendra Thank you, I was surprised that "Copy data activity" with Overwrite as table action also removed access but it hopefully won't be a problem if I do it at schema level.

@@William-Liljedahl Yes, I am assuming that it should work. If it doesn't, we can think of creating another SP activity in the pipeline to give permission

Thank you Will!

you can follow here www.dharmendrakeshari.com/add-new-articles-existing-transactional-replication-without-initializing-old-articles/

@Daniel, I haven't finished writing my blog, I will update once I finish writing it.

Hello, am I right to alter the properties first on the affected publication before proceeding to add the articles right?

you have to keep following properties disabled. otherwise old article will be regenerated on subscriber --Run on your publication database EXEC sp_changepublication @publication = 'test', --Enter your publication_name @property = 'allow_anonymous' , @value = 'false' GO EXEC sp_changepublication @publication = 'Test', --Enter your publication name @property = 'immediate_sync' , @value = 'false' GO -- then generate snapshot --then enable it back --Run on your publication database EXEC sp_changepublication @publication = 'test', --Enter your publication_name @property = 'allow_anonymous' , @value = 'true' GO EXEC sp_changepublication @publication = 'Test', --Enter your publication name @property = 'immediate_sync' , @value = 'true' GO