Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Schedule Refresh Errors - Some data sources may not be listed because of hand-authored queries

Hi All,

 

I get this error while trying to refresh my Power BI Dashboard on the Service side. I use SQL code for Azure Databricks. How can I refresh the dashboard on Service? It doesn't allow me because of this. I am running automated jobs from my Azure Databricks Notebooks and my tables and queries in Power BI are based off sql code to pull that and then I want to automate that and automate onto Service with scheduled refreshes 1x/month. There has got to be a way around this right? I know in Tableau you can schedule refreshes using SQL code to a database.

 

 

 

 

Thanks!

 

Need Help

6 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago
    automate onto Service with scheduled refreshes 1x/month

    Not worth it.  Continue manual refresh.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi lbendlin,

     

    That's a fair assessment, but I would still like to get an answer to this. Thanks.

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      2 years ago

      Show a sanitized version of the power query code. 

       

      Where is that .xlsx file stored?  Are you attempting to merge it?

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi lbendlin,

         

        It's just an invoke SQL function to query from our Azure Databricks environment. This seems silly that Power BI can't support custom SQL automatic refreshes but products like Tableau can and have for years.