Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply

Parameters for import mode,

Hi @pallavi_r 
Greetings!
I have three question here on Power BI-
1. Can you please explain in detail about parameters for that import mode? Basically use parameter to restrict the number of rows to may be a few thousands and once you publish refresh it on server with millions of records to test import issue?
2. What are the standard limitation of import mode semantic model?
3. How to resolve it? Refer below image-

AjitSingh100488_0-1737134512250.png

Thanks,
Ajit Singh

 

1 ACCEPTED SOLUTION
SaiTejaTalasila
Super User
Super User

Hi @AjitSingh100488 ,

 

 

  • Parameters for Import Mode: Use parameters (e.g., row limits) in Power BI Desktop to restrict imported rows for testing; adjust the parameter in Power BI Service to load millions of records after publishing.
  • Import Mode Limitations: Dataset size is limited to 1 GB (Pro) or 400 GB (Premium), with refresh limits (8/day for Pro, 48/day for Premium) and slower performance for large datasets.
  • "The key didn't match any rows" Error: This occurs due to missing/mismatched key values, data type mismatches, or case sensitivity. Verify data integrity, relationships, and clean data in Power Query to resolve.

I hope it will be helpful.

 

Thanks,

Sai Teja 

 

View solution in original post

5 REPLIES 5

Hi @SaiTejaTalasila ,
Thank you very much for your quick response on my questions.
Can you please help me understand- How many parameters are availabe in Power BI for Import mode?
And how to apply them(steps)?

SaiTejaTalasila
Super User
Super User

Hi @AjitSingh100488 ,

 

 

  • Parameters for Import Mode: Use parameters (e.g., row limits) in Power BI Desktop to restrict imported rows for testing; adjust the parameter in Power BI Service to load millions of records after publishing.
  • Import Mode Limitations: Dataset size is limited to 1 GB (Pro) or 400 GB (Premium), with refresh limits (8/day for Pro, 48/day for Premium) and slower performance for large datasets.
  • "The key didn't match any rows" Error: This occurs due to missing/mismatched key values, data type mismatches, or case sensitivity. Verify data integrity, relationships, and clean data in Power Query to resolve.

I hope it will be helpful.

 

Thanks,

Sai Teja 

 

Hi @SaiTejaTalasila ,
Greetings!
How to adjust the parameters in Power BI Service to load millions of records after publishing?  (to restrict imported rows for testing).
Need help in this, please share step by step process for it, if possible.

Thanks,
Ajit.

Hi @AjitSingh100488 ,

 

I need more details what is your datasource(SQL,redshift,sap,sf etc,..).

You can directly contact me if you have any urgency.

 

Thanks,

Sai Teja 

Hi @SaiTejaTalasila,
We are using databricks as our datasource.

Thanks,
Ajit.

 

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.