Forum Discussion

sekic's avatar
sekic
Icon for Helper I rankHelper 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
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Any news with updated version on this old subejct ?

sekic's avatar
sekic
Icon for Helper I rankHelper 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
      Icon for Helper I rankHelper I
      8 years ago

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