Forum Discussion
Refresh issues
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
6 Replies
your filter results in an empty table.
Hi,
So how should I fix it. Can you help
Hi Maha16
Just remove the fliters rows step in applied steps after check
Thanks,
Thennarasu RHi,
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
Do you know why the type mismatch happens?
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.
