Forum Discussion

devGV_88's avatar
devGV_88
Helper I
3 years ago

PowerBI - Dataset Refresh Error (Synapse)

Hi all!   I am working with a dataset from a lake database in Azure Synapse.   While I work in PowerBI Desktop, I don't have errors or issues. But, when I publish the report on the PowerBI Servi...
General Comment
GilbertQ's avatar
GilbertQ
Super User
3 years ago

Hi devGV_88 

 

What is the data source you are using to connect to Synapse, is it SQLServerlss or what type?

  • devGV_88's avatar
    devGV_88
    Helper I
    3 years ago

    GilbertQ have you had the chance to check it?

    • GilbertQ's avatar
      GilbertQ
      Super User
      3 years ago

      Hi devGV_88 

       

      Which part of Synapse are you connecting to?

       

      There are multiple data sources in Snyapse so it is good to know which one.

      • devGV_88's avatar
        devGV_88
        Helper I
        3 years ago

        My database is here:

         

        Before to move to Lake database, the database was in SQL database and I had not errors.

        The weird thing is that from PowerBI Desktop and Synapse I do not have errors running queries.