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

[Shishir]

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]

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

[Shishir]

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