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

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

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.