Visualizations Refreshing Very Slowly

[Hemasekhar]

We have PBIX file (3MB only) linked to Excel file in Same Location. When Refreshing data/change month its taking much time to refreshing Visualizations. Published also taking much time to refresh data

[Eric_Zhang]

---

@Hemasekhar wrote:

We have PBIX file (3MB only) linked to Excel file in Same Location. When Refreshing data/change month its taking much time to refreshing Visualizations. Published also taking much time to refresh data

---

@Hemasekhar

Could you try to disable those highlighted options? If the slowness still persists, could you share the pbix file and excel file?

[Hemasekhar]

Thank you Eric_Zhang for your prompt response.

As you suggested disabled those highlighted options and still slow. Could you please tell me how can I share the pbix file and excel file?

Some observations: In Task Manager 'Microsoft Mashup Evaluation Container' is showing multiple times.

[Hemasekhar]

Eric_Zhang,

As you suggested I have copied two files (pbix, excel) into Google drive and Shared links to you. Could you please look into refreshing issue.

Thanks & Regards,

Hemasekhar

[Eric_Zhang]

@Hemasekhar

The original pbix doesn't takes too much time to refresh in my PC. 

Could you try to create a new BaseQuery as 

let
    Source = Table.Buffer(Excel.Workbook(File.Contents("E:\SourceData.xlsx"), null, true))
in
    Source

And in other queries, reference this BaseQuery as source, instead of retrive data from the excel?

let
    Source = BaseQuery,
    #"CPI Metrics Data_Sheet" = Source{[Item="CPI Metrics Data",Kind="Sheet"]}[Data],
    #"Promoted Headers" = Table.PromoteHeaders(#"CPI Metrics Data_Sheet", [PromoteAllScalars=true]),
    #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Application Name", type text}, {"Release Month", type text}, {"Release Year", Int64.Type}, {"Release", type text}, {"Number of Valid Pre-UAT Defects-P1&P2 (UST)", Int64.Type}, {"Number of Valid Pre-UAT Defects-(Other than P1 & P2) (UST)", Int64.Type}, {"Number of  Valid Pre-UAT Defects#(lf)Defect P1 &P2 #(lf)(Non UST)", Int64.Type}, {"Number of  Valid Pre-UAT Defects #(lf)(Other than P1 & P2)  (Non UST)", Int64.Type}, {"Number of Valid UAT #(lf)Defect- #(lf)(P1 & P2)  (Non UST)", Int64.Type}, {"Number of Valid UAT Defect #(lf)(Other than P1 & P2) #(lf)(Non UST)", Int64.Type}, {"Number of Valid Production Defects (P1 &P2)", Int64.Type}, {"Number of Valid Production Defects (Other than P1 & P2) ", Int64.Type}, {"Total Valid   Defects Raised by UST", Int64.Type}, {"Total Defects Raised by UST", Int64.Type}, {"No of Delivery Commitments met on Time", Int64.Type}, {"#(lf)No of Delivery Commitments Not met on Time", Int64.Type}, {"Simple", Int64.Type}, {"Avg", Int64.Type}, {"High", Int64.Type}, {"V.High", Int64.Type}, {"Simple4", type number}, {"Avg5", type number}, {"High6", type number}, {"V.High7", type number}, {"Simple8", Int64.Type}, {"Avg9", Int64.Type}, {"High10", Int64.Type}, {"V.High11", Int64.Type}, {"Simple12", type number}, {"Avg13", type number}, {"High14", type number}, {"V.High15", type number}, {"Simple16", Int64.Type}, {"Avg17", Int64.Type}, {"High18", Int64.Type}, {"V.High19", Int64.Type}, {"Simple20", type number}, {"Avg21", type number}, {"High22", type number}, {"V.High23", Int64.Type}, {"Total #Applicable  Regression Test Cases", Int64.Type}, {"Total # Regression Test Cases Available", Int64.Type}, {"Total # Regression Test Cases Executed", Int64.Type}, {" Total # Automatable Test Cases", Int64.Type}, {"Total # Test Cases Automated ", Int64.Type}, {"Total # Automation Test Cases Executed ", Int64.Type}, {" Total # Automatable Test Cases planned for the month", Int64.Type}, {"Total # Test Case Automated for the month", Int64.Type}, {"Month No", Int64.Type}}),
    #"Renamed Columns" = Table.RenameColumns(#"Changed Type",{{"Release", "Release"}})
in
    #"Renamed Columns"

Also try to disable the option "Autodetect new relationship after data is loaded" in the snapshot in my previous reply.