create pivottable unsuccesful

[Anonymous]

hi

am trying to connect via Excel to our Analysis dataset but it gives me the error message create pivottable unsuccesful. Error message: There was an internl error whil processing the request. 

I have full admin rights on the db and there should be no issues to upload it in excel. 

Connections with other db's are giving no issues.

Anyone has an idea what cause this and what to do to solve it???

Appreciate your response

M

[v-cazheng-msft]

Hi @Anonymous ,

Are you connecting to the dataset by Analyze in Excel? To bring Power BI datasets into Excel, you need install Analyze in Excel update. You could download it from Power BI service if you haven’t found it on your machine. For more details, you could refer to Start in Power BI with Analyze in Excel - Power BI | Microsoft Docs.

Then, you could bring dataset to Excel by Analyze in Excel option on the top of the report page.

If you get some problems when you connect Excel to Power BI data, you could refer to these official documents to help you do some troubleshoot firstly.

Troubleshoot connecting Excel to Power BI data - Power BI | Microsoft Docs

Error: We couldn't find any data in your Excel workbook - Power BI | Microsoft Docs

After that, if you still have problems, please provide more details about your issue. Thanks in advance!

Today’s awareness of Power BI:

Best Regards,

Community Support Team _ Caiyun

[Anonymous]

hi,

thanks for the swift response, the issue occurs when i open excel, go to data and then via Get Data try to from Power BI, connect to our cubes. So we are not working like you suggesting. The curious part is that one colleague is able to connect to a cube while i am admin and i cannot connect....

Hope you can help

M

[v-cazheng-msft]

Hi @Anonymous ,

May I know whether you still have problems on it?

Best Regards,

Community Support Team _ Caiyun

[Anonymous]

hi,

indeed this is what i get when trying to connect:

[Anonymous]

hi,

any news on this subject?

Still have the same error message and cannot connect...

Please let me know 

thnx

M

[Anonymous]

Hi,

Was there any resolution on this subject? I'm having the same error.

Thanks,

J