Forum Discussion
Azure content pack for PowerBI - Analyzing data in excel
pixelicous In order for this to work you need to follow this sequence.
Start in the Power BI Desktop
Using the data source connection in the Desktop, connect to the "Azure Enterprise (Beta)" data source
Add your measure
Create Reports
Publish to the Power BI Service
Use Analyze in Excel to connect to the Dataset you've created from the above report
Drop the measure in the values section
If you did all this, then something is broken.
If you started in the Service by connecting to the Content Pack (which is how I read all the above) then it won't work and my previous reply still applies.
You cannot connect to a Content Pack in the Power BI Service and somehow modify the model/add measures or calcs to it.
First of all, thanks for the reply and help :)
I can't open this ODC file in powerbi desktop version.
I tried creating a datasource myself, i created a new dataset of type "Azure Enterprise (Beta)"
As the Azure enterprise rest api endpoint i put "https://analysis.windows.net/powerbi/api"
Then it asks me for the key.. I tried using string i received in the excel connection string, the one after the API endpoint above, it looks like "1234abcb-14ab-az5f-1234-1234567fe083 Model"
That doesnt work, i get "the remote name could not be resolved: 'analysis.windows.net'" in the navigator window.
Is there a different way? should i copy that connection string from the ODC file and create some sort of other OLE data source connection file, and open that up????