topic Re: Sxchedule Data Sources on Power BI Report Server in Report Server

Sxchedule Data Sources on Power BI Report Server

Anonymous — Thu, 27 Jan 2022 05:17:46 GMT

I am trying to configure and schedule Power BI Reporting Server Data sources and my the connection type is greyed out for my SQL Server data source (no value)

Re: Sxchedule Data Sources on Power BI Report Server

josef78 — Thu, 27 Jan 2022 17:19:22 GMT

which version of Power BI Reports Server you are using, and from which version of Power BI Desktop is report published?

Re: Sxchedule Data Sources on Power BI Report Server

Anonymous — Fri, 28 Jan 2022 04:14:22 GMT

Re: Sxchedule Data Sources on Power BI Report Server

v-henryk-mstf — Wed, 02 Feb 2022 09:34:00 GMT

Hi Anonymous ,

In both import and direct query modes, the connection type used is immutable by default and depends on the credential information of the data source connected in the pbiRS desktop.

You can try reconnecting to the sql data source in deskop and uploading to the report server, or create this shu directly in the report server.

It should also be noted that direct query mode does not support configuration schedule refresh.

If the problem is still not resolved, please point it out and provide related operation screenshoots. 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.