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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
rkntria
Regular Visitor

PBI Server Data Refresh Error - "Too few arguments were passed to the XNPV function."

I am new to power bi and users are reporting an issue wherein the data refresh is erroring out in PBI Server with the error:

 

Error Processing Data Model Refresh: SessionId: b6b78eba-2d4f-4c6e-890d-18e8dd7d90ca, Status: Error Failed Data Refresh, Exception Microsoft.AnalysisServices.OperationException: Failed to save modifications to the server. Error returned: 'Too few arguments were passed to the SUM function. The minimum argument count for the function is 1.
Too few arguments were passed to the XNPV function. The minimum argument count for the function is 4.
The credentials provided for the Web source are invalid. (Source at https://sharepointsite.com/sites/TEST/testdata.xlsx.). The exception was raised by the IDbCommand interface.

 

I have verified the ff:

 

- account used for the data refresh is not locked out

- account has access to the excel sheet, 

- test connection on the data sources are successful 

- running data refresh in PBI Desktop without any issues 

- no changes to the report 

 

any guidance or help will be much appreciated. 

0 REPLIES 0

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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