Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
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:
let
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]
in
#"aa9b2a3e-630a-4e30-9dd8-4a62e8d02ddd_Table"
Here is the code that is now working in the new report:
let
Source = VSTS.AnalyticsViews("odhprod", "ODRS_MIP", []),
#"62405a21-ca87-4302-9b6f-48dfc7e1e8a2_Table" = Source{[Id="62405a21-ca87-4302-9b6f-48dfc7e1e8a2",Kind="Table"]}[Data]
in
#"62405a21-ca87-4302-9b6f-48dfc7e1e8a2_Table"
Can anyone please tell me why they think the bar graph is disappearing with the new code? Thanks!
Solved! Go to Solution.
For some strange reason, it just started working for me today. Thank you very much for your help!!
@kevinpalicki
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.
@kevinpalicki
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?
@kevinpalicki
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.
Regards,
Naveen
I checked and there appears to be nothing different on the filters from the good one to the bad one.
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).
Regards,
Naveen
Can you please break down how I do that?
@kevinpalicki
Once you have the excel file ready, Follow the below steps. I just noticed you dont have any transformation in your query.
let
Source = Excel.Workbook(File.Contents("C:\Users\Naveen\Downloads\Test.xlsx"), null, true),
Sheet = Source{[Item="Sheet1",Kind="Sheet"]}[Data]
in
Sheet
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!!
Hello @kevinpalicki
Could you confirm if the data is being loaded in power query level, but just the visuals are blank?
Thanks,
Naveen
I believe so. I am not a highly technical person.
User | Count |
---|---|
93 | |
92 | |
85 | |
83 | |
49 |
User | Count |
---|---|
150 | |
142 | |
112 | |
73 | |
55 |