Forum Discussion
PBI Desktop and SharePoint List Refresh Error
Good morning. Yes I have it working now. These are the steps used for the solution.
Key Recommendations:
1. We indexed the vast majority of columns in a custom view.
2. Using implementation 2.0 we did not have the option to select a specific view. We could only select 'All Columns' or 'Default View'. Regardless of what we selected as the default, it would not work. So we went with implementation 1.0 and it synced.
3. Upon connecting to the data source we deleted all unncessary columns in the third step. 1st - Source, 2nd - Navigation, 3rd - Remove Columns. This helped greatly reduce loading times and obtain the data.
We verified all permissions were correct and expanded the cache memory to the highest it could go. Not sure what help those things did but we were kind of throwing spaghetti at the wall.
Hi RGonz1215 ,
Thanks for the update. Could you please confirm if everything is working as expected now, or if you’re still facing any issues?
Also, let us know if you need any further assistance .
Thank you.
Good morning. Yes I have it working now. These are the steps used for the solution.
Key Recommendations:
1. We indexed the vast majority of columns in a custom view.
2. Using implementation 2.0 we did not have the option to select a specific view. We could only select 'All Columns' or 'Default View'. Regardless of what we selected as the default, it would not work. So we went with implementation 1.0 and it synced.
3. Upon connecting to the data source we deleted all unncessary columns in the third step. 1st - Source, 2nd - Navigation, 3rd - Remove Columns. This helped greatly reduce loading times and obtain the data.
We verified all permissions were correct and expanded the cache memory to the highest it could go. Not sure what help those things did but we were kind of throwing spaghetti at the wall.
Hello RGonz1215,
Thank you, for sharing valuable insights.