Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
copy that script into a file with a .mdx extension and tell your agent to run that script file.
User | Count |
---|---|
13 | |
4 | |
2 | |
1 | |
1 |
User | Count |
---|---|
22 | |
3 | |
3 | |
2 | |
2 |