Error loading the data

[Anonymous]

@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

[Pragati11]

Hi @axarhaan ,

Have you got any parameters (Query parameters) in Power BI? The error is related to parameter values.

Thanks,

Pragati

[axarhaan]

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.

[Syndicate_Admin]

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

[Pragati11]

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

[axarhaan]

@Pragati11 

I checked and found that there are no parameteres set. Check below image.

Thanks.

[Pragati11]

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:

1. is there any datatype chnage?
2. is the data format right and it is same as expected?

Thanks,

Pragati

[axarhaan]

@Pragati11 

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:

1. is there any datatype chnage? = No changes in any data type what so ever
2. is the data format right and it is same as expected? = Data type is in order. 

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.

[Pragati11]

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

[axarhaan]

@Pragati11 

I am simply copying the script which runs perfect in R but not loading the table in power bi.. this is just a nightmare. 

[Pragati11]

Hi @axarhaan ,

I can't help you until you share your R script. 🙂