Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Kich254
New Member

Dataset Refresh

Hi,

 

Found a rather curious thing with the dataset refresh: it only works in lineage view and not on the dataset context at the left panel. Meaning when i refresh and go to the report section under workspace there'll be no change. It'll only take effect when i view from the lineage view.

1 ACCEPTED SOLUTION

Excuse my "Noobism" but hadn't seen the refresh icon at the top right on the report sectiction 😯. Now it works. 

One more question: updating rows in the original on-premise data translates to the same in the power bi service on refresh but doesn't happen for newly added columns. Is that how it works? If so how can i go about adding new columns in the original data and not in power bi via the power query?

View solution in original post

4 REPLIES 4
lbendlin
Super User
Super User

Are you sure it isn't your browser cache playing games with you?  Try the report route in incognito mode.

Excuse my "Noobism" but hadn't seen the refresh icon at the top right on the report sectiction 😯. Now it works. 

One more question: updating rows in the original on-premise data translates to the same in the power bi service on refresh but doesn't happen for newly added columns. Is that how it works? If so how can i go about adding new columns in the original data and not in power bi via the power query?

Any changes in meta data will be met with angry outbursts of juvenile petulance by the Power BI service.  Added columns are usually ignored but removed or renamed columns will result in broken visual rendering. The only remedy is a full dataset refresh that includes meta data updates. On Premium you also need to update the app.

I see. Sorry I din't mention was referring to the desktop version. Found a solution by editing the column count in "Advanced Editor" in power query editor. Thanks for you feedback, much appreciated..

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors