Forum Discussion
Power bi direct query with windows authentication, how to setup
I succesfully setup sql 2016 direct query in power bi desktop, it's run fine. But when published, it still use my creditenials to connect, not from another user which is connected to published file....
Hi Sekic,
When you get data from CRM, did you try using API and not SQL DB ?
But in API mode, you will be in import and not Direct Query. Then, in import mode, it will be the same problem, in deploy mode, there is only one unique acount for refresh :(:(
Read live data from sql CRM database is request, so API is not applicable.