Forum Discussion

GM1's avatar
GM1
Frequent Visitor
8 years ago
Solved

Excel Power BI Connector Extremely Slow... unusable

I have Excel Connected to Power BI DataSet. (Using the Connect to Data Power BI plugin in Excel). I have 2 filters in place, one for date set to 1/1/2018 and one for 1 account number.  I can run th...
Need Help
  • GM1's avatar
    GM1
    8 years ago

    Hi Dale,

    Thanks for your feedback.

     

    I did resolve the Excel issue. It was because I needed Calculated members in my output. Including Calculated Measures in excel from the pivot table, not only speed up the Power Pivot queries but also ensured the relationships I had built in Power BI Worked

     

    Thanks.

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi GM1,

 

There won't be only cause in this scenario.

1. Always use the 64-bit software, both Excel and Desktop.

2. Always use the latest version of software.

3. The size of the model. Power BI is more powerful in handling big dataset.

Please check out. 

 

Best Regards,

Dale

GM1's avatar
GM1
Frequent Visitor
8 years ago

Hi Dale,

Thanks for your feedback.

 

I did resolve the Excel issue. It was because I needed Calculated members in my output. Including Calculated Measures in excel from the pivot table, not only speed up the Power Pivot queries but also ensured the relationships I had built in Power BI Worked

 

Thanks.