Not able to IMPORT CALCULATED Measures into POWER BI from Excel Sheet

Used for anything related to the new Power BI Desktop and Service tools
Shishir
Posts: 2
Joined: Thu Aug 30, 2018 8:27 pm

Not able to IMPORT CALCULATED Measures into POWER BI from Excel Sheet

Postby Shishir » Wed Oct 17, 2018 2:25 am

Hi

Challenge - All the Calculated Measures are not getting imported into Power BI

While I am importing the Excel sheet from File -> Import -> Excel workbook into POWER BI , I am getting a warning message

" This pasted table exceeds the maximum size and could not be imported "

Calculated Measures ( with ) their names are mentioned below this Warning

The size of the Excel Sheet ( Source file used has a size of 34 MB ) & I am using POWER BI Desktop Version


Kindly help
Thanks & Regards
Shishir

RamanaV
Posts: 39
Joined: Thu Oct 19, 2017 12:57 pm

Re: Not able to IMPORT CALCULATED Measures into POWER BI from Excel Sheet

Postby RamanaV » Wed Oct 17, 2018 9:31 am

Hi,

Few quick observations.
1. Both in Excel and Power BI you have "Measures". Only in Excel 2013 version "Measures" were renamed as "Calculated Fields". So there is nothing called CALCULATED Measures.
2. Excel file size is 34 MB. Excel file only with a data model cannot be that large. Do you have Excel tables in the Excel file that are increasing the file size? If so, move them to a different Excel file and load data from the other file.
3. Are you using Linked tables? You cannot import linked tables into Power BI Desktop. So move them to another Excel file and load the data.

If you still get the error, a screenshot of the message would be helpful to understand the problem.

Ramana
Ramana Varanasi
Training and Office Manager
Excelerator BI Pty. Ltd.

Shishir
Posts: 2
Joined: Thu Aug 30, 2018 8:27 pm

Re: Not able to IMPORT CALCULATED Measures into POWER BI from Excel Sheet

Postby Shishir » Wed Oct 17, 2018 8:50 pm

Hi Ramana

1. Both the Excel and Data Model were in the same file , I have segregated that and now the size has reduced to 5MB from 34 MB - so this is RESOLVED

2. If I add more measures in the Data model , I try have to Import the Data Model every time to get these measures in the Power BI
Refresh All just does not work

Is there a way out ?

Thank u for the prompt response

I am using Office 365

Shishir


Return to “Power BI Desktop/Service”

Who is online

Users browsing this forum: No registered users and 1 guest

cron