Forum Discussion
Solved
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 t...
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.