Forum Discussion

sdeleener's avatar
sdeleener
Frequent Visitor
10 years ago

refresh fails with web database connection

Hi,

 

I have set up a connection in Power BI Desktop to my online ERP/CRM database via a Basic registration (login & pass of webtool). The refresh of the data works perfect when i do this in Power BI Desktop

 

 

when I publish my file online, the automatic refresh:

- works perfect when I only have one table to refresh

- doesn't work anymore when I want to refresh all the tables of my database. It tells me the credentials are invalid, but when I fill in my credentials online, he accept it but can't use it for a refresh action.

 

 

What can be the cause of this issue?

 

Kind regards,

 

Need Help

1 Reply

  • v-sihou-msft's avatar
    v-sihou-msft
    Microsoft Employee
    10 years ago

    sdeleener

     

    You need to edit all credentials under dataset setting. The refresh should work until all "X" disappear.

     

    Regards,