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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
eternally777
New Member

No visuals appear after changing Excel data source file - file identical format

Hi

Could you please help - for an existing report, I simply changed the data source (Excel file). File is identical format/columns etc. I already resolved the import issues (like PBI Changed Data Type, some row data #N/A issues) so data imported correctly. Blank chartBlank chartThe point is for visuals to automatically refresh/appear with the new data. I'm a PBI novice, so please help! Thanks

1 ACCEPTED SOLUTION

kleigh_0-1701967377394.png

It's not the refresh, it's a reset button that clears slicers to the default state. 

In Desktop, you may have to check "Slicers affecting this visual" and clear manually.

kleigh_1-1701967597509.png
Hover over the funnel and clear any slicers you see, or set them to current values.

 

View solution in original post

8 REPLIES 8
eternally777
New Member

Thanks kLeigh you were right, filter issue resolved and charts appear.

eternally777
New Member

Thanks! Sorry for being slow - I found the funnel button top right - it appears/disappears so doesn't always show if clicked away from the visual. So now clicking on it the filter selections appeared (they had been blank previously). Also a green tick appears next to the dataset in the data pane. I then refreshed and but visuals don't appear. I also have 5 tabs of visuals and doing the same on each of them (1) filter selection and (2) green tick appears but no visuals and clicking away from the tab the filter selections and green tick disappears.Grren tick_PBI.JPG

Grateful for any further help to take this forward!

eternally777
New Member

Thanks Kleigh I can't seem to see your exact buttons on my PBI desktop app. Is this option 'clear all slicers' under buttons the one? First of course I'd like my charts to appear but then will it mean I'll have to re-select any filters from the original report?Clear slicers optionClear slicers option

Where is this option please - or is it in the 'View' menu - anywhere here?VIEW menuVIEW menu

 

Is it in the Visualisation or Edit Query data area?

eternally777
New Member

@kleighThanks for coming back. Do you mean just the Refresh? If so done that and it runs and still returns blank (and shows no refresh errors). Would these filters have anything to do with it? I really of course don't want to alter any of the settings as haven't got time to fix anything wrong - the report is fine! PBI Refresh buttonPBI Refresh buttonFilters untouched from existing reportFilters untouched from existing report

kleigh_0-1701967377394.png

It's not the refresh, it's a reset button that clears slicers to the default state. 

In Desktop, you may have to check "Slicers affecting this visual" and clear manually.

kleigh_1-1701967597509.png
Hover over the funnel and clear any slicers you see, or set them to current values.

 

kleigh
Resolver II
Resolver II

Could you have a "sticky filter" applied which relates to the old data? Slicers will display old selections even if no data matches.

To the top right you should see a button, a looped arrow in a green circle. Clicking this will reset all selections and can often fix data missing after refresh.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.