Forum Discussion

sertank's avatar
sertank
Frequent Visitor
5 years ago
Solved

can't get scheduled refresh working (table schema unexpected error)

Hi to all,   After googling for results for couple of days and reading all the online tutorials and guides, I couldn't solve my problem and decided to post here.   I've installed Power BI Reports...
Schedule Refresh
table schmea unexcpected
  • Icey's avatar
    Icey
    5 years ago

    Hi sertank ,

     

    What's your browser language? Is it "Turkish"?

     

    If so, there is a bug in RS Jan 2021. Please update to the latest version: 15.0.1106.169, it is fixed in this version.

     

    If not, please let me know.

     

     

    Best Regards,

    Icey

     

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

FarhanAhmed's avatar
FarhanAhmed
Icon for Community Champion rankCommunity Champion
5 years ago

Can you please check if any other data source is refreshing fine? like Excel.

 

What is the version of PBIRS you are using? Are you able to successfully connect to SQL Server from PBIRS machine?

 

sertank's avatar
sertank
Frequent Visitor
5 years ago

Thanks for your comment Ahmed.

 

I'm able to connect SQL Server from PBIRS (15.0.1105.195 version) successfully. Also I can connect from PBIRS Reports - Manage - Data Sources screen successfully.

 

We are not using any Excel for now.

  • FarhanAhmed's avatar
    FarhanAhmed
    Icon for Community Champion rankCommunity Champion
    5 years ago

    What is the version of PBIRS you are using ?

     

    The user that you are using in both PBIRS & Report Server is same?

     

    Are you trying to connect to On-Prem SQL Server or Azure SQL ?

     

    I think this may be a bug, you can also post your query at 

     

    Issues - Microsoft Power BI Community

     

    • sertank's avatar
      sertank
      Frequent Visitor
      5 years ago

      Hi Ahmed,

       

      The version we're using is PBIRS on premise and build number is 15.0.1105.195.

      I'm using a local account on PBIRS server and SQL authentication when connecting to SQL.

      Our SQL server is on premise as well.

       

      I'll check the issues page and report as a bug and hopefully get a response.

      • Icey's avatar
        Icey
        Icon for Community Support rankCommunity Support
        5 years ago

        Hi sertank ,

         

        What's your browser language? Is it "Turkish"?

         

        If so, there is a bug in RS Jan 2021. Please update to the latest version: 15.0.1106.169, it is fixed in this version.

         

        If not, please let me know.

         

         

        Best Regards,

        Icey

         

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