Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
20 | |
3 | |
2 | |
2 | |
2 |