Forum Discussion
Helper IIpower bi service data's field data type
Most Valuable ProfessionalI'm glad to see it's not just me complaining about this. :smileyhappy: I posted this over the weekend, same issue. http://community.powerbi.com/t5/Service/Analyze-in-Excel-oddity/m-p/37609
I don't yet have a workaround for this.
Treb Gatte, Power BI Red Carpet Partner | Microsoft MVP | Twitter | Blog | Blog 2
Helper IIThe immediate workaround is to use Excel's OLAP Tools to create Measures in the Excel's new Pivot Table cube.
At least that way they don't have to be created in the Power BI model and just in Excel where they are needed. Still duplication of effort though.
I guess there is no way around this as Power BI Report data is stored in SSAS database which is specified in the .odc connection file and which creates the Excel data connection used by Pivot Table.
I have tried to use the SSAS database connection string in the .odc file to use Power Query to connect to the Power BI report's SSAS database. That Power Query could be used as Pivot Table data source. No luck with this yet. The SSAS string is pretty long and Power Query doesn't accept longer than 128 characters for SSAS database url.
Are there any configuration options in the SSAS connection that might ignore using Measures. Perhaps 'TypedMeasureColumns = false])' ?