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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
axarhaan
Helper I
Helper I

Error loading the data

 

 

11 REPLIES 11
Anonymous
Not applicable

@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. 

Vpazhenmsft_0-1626766826093.png

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
Super User
Super User

Hi @axarhaan ,

 

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

 

Thanks,

Pragati

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

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

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

@Pragati11 

 

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

axarhaan_0-1626449215616.png

 

Thanks.

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

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

@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.

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

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

@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. 

Hi @axarhaan ,

 

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

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.