Refresh Error - Data source errorThe input URL is invalid.

[na12063]

Hi,

I got this error last two days which does not make sense the SharePoint URL has not been changed or updated just not sure how to handle this case any information will be helpful solving this issue.

Data source errorThe input URL is invalid. Please provide a URL to the file path on SharePoint up to the file name only (with no query or fragment part).. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action.

Best Regards,

[GilbertQ]

Hi there

Could you make sure that the file name and location still exists in SharePoint?

[na12063]

Hi @GilbertQ , 

Thanks for your respond, the location still exist and files are still there nothing has been changed.

Regards, 

[GilbertQ]

Is this going via a Gateway?

If so could you install the latest version of the On-Premise data gateway?

[na12063]

Hi @GilbertQ,

No, is not going via Gateway, only thru Data source credentials which right now is not editable on Power BI Service!

Regards,

[v-deddai1-msft]

Hi @na12063 ,

Would you please try to use power bi desktop to connect to the same url for test? If there is any error , please show it to us. Please refer to https://www.youtube.com/watch?v=gJF2e_43FRY

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[na12063 · Accepted solution]

Found the issue, was on specific file:

 

I removed the file and Power BI Desktop refreshed successfully.

Thank you @GilbertQ and @v-deddai1-msft  for your help.

[GilbertQ]

Hmm what happens if you try update it manually?