Excel Pivot connected to powerbi dataset is giving perfomance issue

[Sathiyapriya]

Hi All,

I have a simple powerbi dataset with star schema, connected with Google BQ. 

I have very simple measures, no advance query, direct connection to source.

It works fine with PBI desktop, but when this dataset is connected in excel, it takes time to retrieve the data.

Kindly help to improvise the performance in excel

[SPriya19]

hi Winniz,

thanks for your response.

Here is my issue. Wen i connect excel with powerbi dataset, am not able to put one particular column in filter section, it says "The "" string cannot be converted to unsignedInt" and if we press Ok it again says as "Item cannot be found in OLAP cube". Already that column is string only. Only this particular column am facing this issue. Not sure how to debug or check more with this error. Please help in this regard.

[v-kkf-msft]

Hi @Sathiyapriya ,

Please check the following documents to optimize the Pivot performance:

Why reports obtained with Analyze in Excel can be slower 

Excel PivotTable Query Performance With Analysis Services, Power Pivot And Power BI (Revisited) 

Improving Performance in Excel and Power View Reports with a Power Pivot Data Source 

Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[SPriya19]

hi Winniz,

thanks for your response.

Here is my issue. Wen i connect excel with powerbi dataset, am not able to put one particular column in filter section, it says "The "" string cannot be converted to unsignedInt" and if we press Ok it again says as "Item cannot be found in OLAP cube". Already that column is string only. Only this particular column am facing this issue. Not sure how to debug or check more with this error. Please help in this regard.

[r_mel]

I have this same problem. @SPriya19 Did you ever find the solution to this problem?