Refresh issues

[Maha16]

I created power bi report sourced from one SharePoint folder. In query editor, I created one parameter and entered the root url of SharePoint site. And datasource settings I mde changes to point to parameter. And dataset is having around 20 tables. and  now source location gets changed. So i made changes in parameter ( new root url). And in all the 20 tables, I made changes in third step , where the folder path is present. So i just changed it to new path. Earlier, while loading, it doesn't throw error. Got error only refreshing. But now showing error even while loading itself. error is  like parameter1 - key didn't match any rows in table,  ..and from parameter2 to parameter 7 showing error like below image. Don't know what these parameters are. 

•  

Can anyone help me fix this

[christinepayton]

The folder datasources have the path referenced in two places, once in the main query and once in the sample file query. My guess is you put the path parameter in one but not the other. If you check the sample query in the advanced editor you should be able to see the path it's using there. 

[Maha16]

Hi,

 I have deleted all the queries from queries pane  except other queries.  Now I loaded the tables. Didn't get error. But while refreshing it, 

 

 getting these errors. can anyone help me fix this

[lbendlin]

Do you know why the type mismatch happens?

[Thennarasu_R]

Hi @Maha16 

Just remove the fliters rows  step in applied steps after check 

Thanks,
Thennarasu R

[lbendlin]

your filter results in an empty table.

[Maha16]

Hi,

  So how should I fix it. Can you help