Skip to main content
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

New Member

My Bar graph is disappearing!

I inherited a Power BI report for my project reporting.  For the past 5 years from project to project, I would just copy over the current project report to a new one, with a few adjustments that would make it work for the new project.  But all of a sudden, when I copy and paste the new code in the advanced editor, when I "close and apply" it, it makes the bar graph in my power BI report disappear.  Here is the code that was successful in the old report:



    Source = VSTS.AnalyticsViews("odhprod", "ODRS_Modernization", []),

    #"Shared Views_Folder" = Source{[Id="Shared Views",Kind="Folder"]}[Data],

    #"aa9b2a3e-630a-4e30-9dd8-4a62e8d02ddd_Table" = #"Shared Views_Folder"{[Id="aa9b2a3e-630a-4e30-9dd8-4a62e8d02ddd",Kind="Table"]}[Data]




Here is the code that is now working in the new report:



    Source = VSTS.AnalyticsViews("odhprod", "ODRS_MIP", []),

    #"62405a21-ca87-4302-9b6f-48dfc7e1e8a2_Table" = Source{[Id="62405a21-ca87-4302-9b6f-48dfc7e1e8a2",Kind="Table"]}[Data]




Can anyone please tell me why they think the bar graph is disappearing with the new code?  Thanks!


For some strange reason, it just started working for me today.  Thank you very much for your help!!

View solution in original post

Super User
Super User


Can you check if you see data like this once you change the query in advanced editor and maybe refresh preview once to be sure?


If you see date here, then something on the front end causing the visual to go blank. below are few reaons.
Page level or report level filter

No equivalent data for the selected slicers

Let me know if you have any question!

If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate your kudos!!


Here is the view of what I see:


I refreshed like you said with no success.


You have data loading in power query level, Something the report side is causing the visuals to go blank. Take a look at the visual, page and report level filters and also if slicers are impacting the data.

If these doesn't help, you should start looking at the calculations used.

If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate your kudos!!

Can you give me any examples of these filters that would cause a blockage?


If you click on a visual and expand the filter pane on the right side, You would see the filters applied on visuals, Below that you can see page level & report level filters.





I checked and there appears to be nothing different on the filters from the good one to the bad one.


Please try to clear those fiters one by one and see if that makes a difference.




It did not make a difference after I cleared the filter.



Could you please share the pbix file with small sample of data, you can modify sensitive data( export maybe 10 lines of data to Excel and replace it in your report).




Can you please break down how I do that?


Once you have the excel file ready, Follow the below steps. I just noticed you dont have any transformation in your query.


  1. Select the table & go to advanced editor
  2. Change your code with below code Also change the blue highlighted part with your excel file path.

Source = Excel.Workbook(File.Contents("C:\Users\Naveen\Downloads\Test.xlsx"), null, true),
Sheet = Source{[Item="Sheet1",Kind="Sheet"]}[Data]

if there are other tables, Repeat the same step for them too.

Now you will be able to see data load from excel. Upload the file in drive and share me the link. let me know if you have any issues.

For some strange reason, it just started working for me today.  Thank you very much for your help!!

Super User
Super User

Hello @kevinpalicki 

Could you confirm if the data is being loaded in power query level, but just the visuals are blank?



I believe so.  I am not a highly technical person.

Helpful resources

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.