Forum Discussion
Updating issue
- 3 years ago
I tend to just connect direct to the dev model via xlma end point with tabular editor and add new tables there/configure new incremental when required. It's relatively straight forward in TE3 where you can right click to update table meta data once you've set it up. One done I use deployment pipeline to step through test and prod but you could connect straight to prod.
Would happily jump on a call and demo if you needed.
- 3 years ago
Hey smpa01 ,
you can do, this is exactly what ALM Toolkit was build for.
Of course you have to practice, a little.
Regards,
Tom
I believe this is possible but I haven't attempted it myself yet. XMLA connection is the key.
Here are some links that may be useful:
https://docs.tabulareditor.com/te3/powerbi-xmla.html
Create or Replace with XMLA is resulting in this while trying to download from the server a workbook with no incremental but with "createOrReplace" exercised with XMLA through SSMS. I prefer doing it via SSMS but is this a definite side effect or it can be bypassed?
- AlexisOlson3 years agoSuper User
This is a documented limitation:
https://learn.microsoft.com/en-us/power-bi/create-reports/service-export-to-pbix- Reports created in the Power BI service that are based on a single dataset that's configured for large models or incremental refresh, or that has been modified by using the XMLA endpoint can only be downloaded in live connected report mode.
- Datasets modified by using the XMLA endpoint can't be downloaded to a .pbix file.
There are ways to reconstruct a .pbix but they're hacky:
https://data-goblins.com/power-bi/download-pbix