Forum Discussion
RLS Analyze in Excel
Analyze in Excel is supported for Microsoft Excel 2010 SP1 and later. Please make sure you've installed SP1 upon your Excel 2010. If your data source is part data from a excel file, it should not be the problem. For the detailed steps of using Analyze in Excel, I think you can take a look at this video and official document.
For your another question, you can change source in data source settings, or alter the data source path directly in Query Editor – Advanced Editor.
Best Regards,
Herbert
Analyze in Excel is supported for Microsoft Excel 2010 SP1 and later. Please make sure you've installed SP1 upon your Excel 2010. If your data source is part data from a excel file, it should not be the problem. For the detailed steps of using Analyze in Excel, I think you can take a look at this video and official document.
For your another question, you can change source in data source settings, or alter the data source path directly in Query Editor – Advanced Editor.
Best Regards,
Herbert
many Thks. I thought I had allready the SP1 but I haven't. Now I have downloaded SP2.
But still it signals no data found in Olap cubus. So some work out to do on my side. But don't know where to look really.
Anyway your advises are very helpful. It is now up to me I guess.
Perhaps he doesnot recognise the part of the worksheet, because I have modified after downloading to Power Bi the lay out etc, deleted some columns, unpivot columns etc. to my liking for power BI.
For the other question. It is now clear to me. Do not understand why I have missed the advance query tick box:smileysurprised:
best regards
Nono Liem