Forum Discussion
Azure content pack for PowerBI - Analyzing data in excel
Hi all,
I have the same issue as the following post:
I tried replying on that post but no comment as of yet.. I was wondering if somebody can help me understand how do i fix the dataset so the "analyze in excel" functionality would work.. i dont get it, as the content pack is only for web, I downloaded the ODC flie to open in excel but i have no idea how to play with it.
i tried in excel to create a new field and added [Usage Details].[Cost] as a MDX definition but that's not it..
thanks in advance
11 Replies
pixelicous Content Packs are Service only connections unless directly supported in the Desktop. It is only then that you would be able to adjust and manipulate the dataset. Is there something you are doing that is different than the first post in that you would expect a different outcome other than what was explained?
Thanks for replying eno1978.. It seemed from the post that it is possible to create an element that will turn the COST field to be able to be maniuplated in a way that it would be useable, thus i asked..
The guys on that post explained the situation and what needs to be done but it didn't seem like it isn't possible with the current option, like there is a way to create a dataset using that service connection to download a schema or amodel and based on that tweak it a bit so analyze in excel would be helpful..
How come such an important content pack is released without the ability to do anything in powerpivot with it..
Hi pixelicous,
You can use analysis in excel function to export data model to excel, but I don't think it will be possible to create a content pack which support drag and drop column to values field.
Regards,
Xiaoxin Sheng
