Power BI server unable to refresh - SP data source

[Selvaprabu]

Hi Team,

I have one report with Share Point folder and SQL server as Datasource. The report is refreshing at locally in my desktop. when I am deploying in POwer BI report server. It thorws an error like : Dynamic data sources can't be refreshed" and I am unable to configure the Share Point folder password too. It throws username password error. But my password is correct and except share Point folder source all sources test connections are done.

[v-henryk-mstf · Accepted solution]

Hi @Selvaprabu ,

Based on your description of the two data sources, it is important to note that the following types of data sources cannot be successfully refreshed in report server

• If you use a "file" or "folder" data source and the file path is local (e.g. C:\Users\user\document), you cannot create a refresh schedule.
• If the sql data source uses a direct query

For more details, you can read below document:

Power BI report scheduled refresh in Power BI Report Server - Power BI | Microsoft Docs

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

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