Forum Discussion

fharvey's avatar
fharvey
New Member
3 years ago

Dataflow refresh fail after ownership change

We are currently initiating a powerBI project in our orgnisation.   I'm the sysadmin of a sensitive database. Only me and the organisation power-bi gateway have permission to connect to. So both o...
Dataflow
YukiK's avatar
YukiK
Icon for Impactful Individual rankImpactful Individual
3 years ago

Did you try to reconfigure the data source credentials?

fharvey's avatar
fharvey
New Member
3 years ago

That option is grayed-out,  same thing from the power-query editor for each tables

 

  • sergej_og's avatar
    sergej_og
    Icon for Super User rankSuper User
    1 year ago

    By taking over the ownership you have to apply the credentials for the underlying data source again (sec reasons). Go inside of your dataflow and find the option "Manage connections", choose your connection(s) and provide the credentials again.
    It should work.

     

    • powerbi_pika's avatar
      powerbi_pika
      New Member
      1 year ago

      Thank you so much, that solves the issue

      • sergej_og's avatar
        sergej_og
        Icon for Super User rankSuper User
        1 year ago

        My pleasure.

        You can "accept as solution" if you want

  • powerbi_pika's avatar
    powerbi_pika
    New Member
    1 year ago

    Have you resolved this issue?