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 Service, I get multiple errors trying to refresh the data (mannualy or automatically).

 

The meesage say something like:

"The credentials provided for the Synapse source are invalid. (Source at Synapse.). The exception was raised by the IDbCommand interface. Table: XXXXXXXXXX".

The table name, changes every time...

 

Could you help me?

7 Replies

  • Hi devGV_88 

     

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

  • aheza's avatar
    aheza
    Regular Visitor

    Hi,

     

    Any chance you found a solution or workaround? I am experiencing a seemingly identical error when trying to refresh a published dataset containing an Azure Synapse Analytics Workspace data source.

    Thank you