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.