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
Not able to IMPORT CALCULATED Measures into POWER BI from Excel Sheet
Re: Not able to IMPORT CALCULATED Measures into POWER BI from Excel Sheet
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
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.
Training and Office Manager
Excelerator BI Pty. Ltd.
Re: Not able to IMPORT CALCULATED Measures into POWER BI from Excel Sheet
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
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