Tabular Model Data Refreshing Command in SQL SERVER

gabrielefugazzi — Tue, 06 Oct 2020 07:56:17 GMT

Hello to everyone,

my Power BI project rely on a tabular model created and deployed throught Visual Studio to SQL Server. I'm stucked in the process of refreshing data with SQLAgent because of my lack of knowloadge of an appropriate command to elaborate my model data. Basically I need a command that can do the same of the following Visual Studio screenshot:

which eleborates databases, tables and partitions.

I've been using the following command which clearly only updates the model schema and not the data within:

{
"refresh": {
"type": "automatic",
"objects": [
{
"database": "database_name"
}
]
}
}

What should I use to refresh data correctly? Thanks in advance, Gabriele.

Re: Tabular Model Data Refreshing Command in SQL SERVER

lbendlin — Wed, 07 Oct 2020 02:05:59 GMT

copy that script into a file with a .mdx extension and tell your agent to run that script file.

topic Re: Tabular Model Data Refreshing Command in SQL SERVER in Developer

Tabular Model Data Refreshing Command in SQL SERVER

Re: Tabular Model Data Refreshing Command in SQL SERVER