Connect To Data Source Excel 32 Bit Version Regardless
Connect To Data Source Excel Download Box Again

Analyst Module 3: Demystifying DAX Virtual Online In-House Training.

This feature was requested by Avi Singh from PowerPivotPro.com and was heavily supported as a requirement by the community.

You can read more about how you can influence future releases at the bottom of this post.

Note however if you want to upload a workbook and share it with someone else in your organisation so they too can Analyze in Excel, you will need the paid service.

But dont despair- Power BI Pro is cheap and well worth the money.

What that means to you is you can have a powerful server to host your Power BI workbooks and distribute your reports without having to spend hundreds of thousands of dollars getting it all set up.

Note you should only do this with non-confidential data as this approach will make your data available publicly over the Internet.

Sometimes however you just want to get into the data and analyse it using good old fashioned Excel Pivot Tables.

You can prompt this manually from the drop down menu in the top right hand corner of PowerBI.com as shown below.

Connect To Data Source Excel Download Box Again

After you click Dont show this again, you can get to the download box again by clicking the downloads button (shown as 1 below) and then selecting Analyze in Excel updates (2 below).

Connect To Data Source Excel 32 Bit Version Regardless

However when you do this, it currently ONLY DOWNLOADS the 32 bit version regardless if you have 64 bit or not.

I have logged a bug with Microsoft and will remove this comment from this blog once the problem is fixed.

Keep an eye out for the download in your browser mine is shown below.

You can build out a Pivot Table to analyse your data like any other Pivot Table, with a few minor differences.

The first type (shown as 1 below) are the measures stored in your tables in Power BI.

The second type (shown as 2 below) are the actual tables (and columns) from the data model.

You select the Values for your Pivot Table from the measures tables (1) and the RowsColumnsFiltersSlicers from the actual tables (2).

This is a Thin Workbook, in my example it is just 24kb (shown below).

The only data that is in the workbook is the data that is visualised inside the Pivot Table(s).

But there is a cost to this approach you must have a live connection to the Internet to be able to interact with the data in the Pivot Table.

Personally I think this is a small price to pay for all of the benefits, however if you want to interact with your workbook in a location that doesnt have an Internet connection, then this is something you will need to be aware of.

This will be most noticeable for small workbooks that are almost instantaneous on your PC.

These small fast workbooks will move from being instantaneous on your PC to being sub second in the cloud which is not that bad in my view.

Connect To Data Source Excel For Mac