Forum Discussion
PBI Desktop Refresh Issues
Hi All I'm having some issues on a refresh and can't figure out what the fix is. I have a .pbx file I add to each month. Format/column structure remains static. Last month there were no issues...
Hi emma313823 ,
Are you using excel as datasource? Sometime in excel in formulas you have value "#N/A" and that could be the root cause for this. You need to replace that value using query editor with "null" or space.
If this is not the cause of the problem, please consider sharing more details about the error.
Best Regards,
Community Support Team_Gao
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data