Forum Discussion
Model changes not present in analysis services connector data set
Hi,
I'm deployed a Tabular model and consumed this model via the analysis services connector in the Power BI service.
I made changes to dim table. After redeploying the model and I can see the new field when I browse the model from SSMS.
The dataset in Power BI doesn't update. Is it possible to update an existing dataset with changes from the model?
Also note if I create a new dataset with new connection to the model I don't immediately see the new field. I had to wait approx 1 hour before I saw the field. I assume something is being cached.
I'm currently working on a proof of concept hence development is fairly fluid.
Best
Lee
Anonymous
Both issues you have encountered should actually be working.
1. If you add a column/measure, it should (after deployment) be visible to the Power BI Web Service / PBI Desktop Application. Do you encounter the same problem with the desktop application?
2. Seeing the data after 1 hour is also uncommon. Does the manual refresh work and is the column still invisible afterwards?
4 Replies
Anonymous
Both issues you have encountered should actually be working.
1. If you add a column/measure, it should (after deployment) be visible to the Power BI Web Service / PBI Desktop Application. Do you encounter the same problem with the desktop application?
2. Seeing the data after 1 hour is also uncommon. Does the manual refresh work and is the column still invisible afterwards?
- I'm experiencing exactly the same issue, is there a solution for this? I left mine overnight and still it had not updated, I had to rename the cube and create another connection on PowerBI. It's really frustrating.
How is 'it should work' a solution?
Has this been addressed. I have very inconsistent experiences like those described above. Most deployments are immediatelly visible, but sometimes there is a lag. Is there time needed to propogate changed through the cloud? What is causing this?
