Forum Discussion

qmestu's avatar
qmestu
Helper IV
3 months ago
Solved

Data source credentials missing

Hi,

 

I have a report that gets its data from an Azure SQL instance. That SQL runs on a personal account, to which i can connect from the desktop version and refresh the data. However, when i upload the report to app.powerbi.com, the data source credentials section is disabled.

 

I have tried changing the data source settings in the desktop version to "public" but it made no difference.

 

Thanks.

Need Help
  • ibarrau's avatar
    ibarrau
    3 months ago

    Hi. Is that the only source you have at your model? or do you have an excel file something like that too? Usually that's due to another source. An azure sql database shouldn't be preventing a data source credentials setting at the semantic model. Are you using the azure sql database connector at desktop to connect?

    Regards,

2 Replies

  • ibarrau's avatar
    ibarrau
    Super User
    3 months ago

    Hi. Is that the only source you have at your model? or do you have an excel file something like that too? Usually that's due to another source. An azure sql database shouldn't be preventing a data source credentials setting at the semantic model. Are you using the azure sql database connector at desktop to connect?

    Regards,

    • qmestu's avatar
      qmestu
      Helper IV
      3 months ago

      I had an excel file from a previous version of this dashboard still connected as a data source. Since i don't use it, i removed it and that fixed it. Thanks.