Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
@axarhaan
Take a look at the above article about parameter. This error means the input value is out of range of the parameter. For example, the the parameter is set to a specific query, lets say from 0-20, you get that error if you input a value more larger then 20.
It seems the error comes from the last table, you might need to detect the r script according the error message first.
Paul Zheng _ Community Support Team
Best Regards
Hi @axarhaan ,
Have you got any parameters (Query parameters) in Power BI? The error is related to parameter values.
Thanks,
Pragati
Hi @Pragati11
Thanks for your reply.
I am pretty new to this. I don't know how to check that, if you can explain that little bit or even if you can tell me how to fix this, that would be helpful. Much appreciated.
Thanks.
Hi @axarhaan ,
This blog tells you how query parameters are created in Power BI, if you scroll down you will see how you can check them in Power BI:
https://www.mssqltips.com/sqlservertip/4475/using-parameters-in-power-bi/
You will see them in Power Query Editor under Manage Parameters.
Thanks,
Pragati
Hi @axarhaan ,
This blog tells you how query parameters are created in Power BI, if you scroll down you will see how you can check them in Power BI:
https://www.mssqltips.com/sqlservertip/4475/using-parameters-in-power-bi/
You will see them in Power Query Editor under Manage Parameters.
Thanks,
Pragati
Hi @axarhaan ,
That is strange then
What happens when you close and open Power BI and try the table load again?
Also I am just worried you have got so many tables, so load of few might be crashing due to cache issue.
Also it might be worth checking what kind of changes happened in the source for these 2 tables:
Thanks,
Pragati
Answer to your questions:
- What happens when you close and open Power BI and try the table load again?
I tried number of times to open and reload the table but failed.
- Also I am just worried you have got so many tables, so load of few might be crashing due to cache issue.
I cleared the cache also but failed. Things is I don't want to load all 52 tables but only those 4 tables.
- Also it might be worth checking what kind of changes happened in the source for these 2 tables:
I want to add one thing here that when I load that csv file seperatly into power bi, it loads perfectly but when I try to load it through the R script it gives me the error.
Hi @axarhaan ,
In that case, you have answer to your question - There is definitely some issue with the R-script in Power BI.
Thanks,
Pragati
I am simply copying the script which runs perfect in R but not loading the table in power bi.. this is just a nightmare.