Forum Discussion

sekic's avatar
sekic
Helper I
9 years ago

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....
Need Help
sekic's avatar
sekic
Helper I
8 years ago

None. Main answer is that Power bi only can "read" data, and can't send any info to DB, even in live query. 

Which is, in case of Microsoft CRM, useless, because CRM have so many "Filtered" views, and development is, if some still not give up from Power BI, unnecessary slow, because I must rewrite all to the last view to 'duplicate' authorisation system form one Microsoft product to another Microsoft product  :manfrustrated: :manmad: :manfrustrated:

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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 :(:(

 

  • sekic's avatar
    sekic
    Helper I
    8 years ago

    Read live data from sql CRM database is request, so API is not applicable.