Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Sxchedule Data Sources on Power BI Report Server

Hi

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)

 

 

Data Source Configuration
  • v-henryk-mstf's avatar
    v-henryk-mstf
    4 years ago

    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.

3 Replies

  • josef78's avatar
    josef78
    Memorable Member
    4 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Power BI Report Server

      © 2021 Microsoft. All rights reserved

      Version1.12.7977.29537(September 2021)

       

      Power BI Deskop Sepetember 2021

       

      Not greyed out when only have one source type (FILE) . But the next issue is that when i put in window credentials (mine) it can't find the file (mapped drive) but it can within desktop.

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Community Support
    4 years ago

    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.