cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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 

1 ACCEPTED SOLUTION
Bjoern
Responsive Resident
Responsive Resident

@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?

 

 

View solution in original post

4 REPLIES 4
Bjoern
Responsive Resident
Responsive Resident

@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?

 

 

View solution in original post

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?

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.
Anonymous
Not applicable

The new data came in after a page refresh.   There was around a 15 minute lag which is okay.

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors