Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

direct query from sqlserver not working for licenced user

Dear Comunity,

 

I have an interesting and kinda ridiculous problem:

 

I made some reports within 60 days period which are all using direct query, I set up the schedule refresh and they still work fine. (I was using my gmail account)
BUT after I start using my licenced pro user, I tried to publish the same reports. In desktop environment all seems fine, when I publish the report, report shows the recently updated data but data source credentials greyed out and also scheduled refresh greyed out.

I use PBI Desktop Version: 2.76.5678.782 64-bit

What may cause this behaviour? And how can I fix this?
you may see the screenshots of both users below:

Free user:

 

Licenced User:

 

5 Replies

  • Anonymous where is db? Is it in cloud or on-prem? Are you using gateway? If yes, personal or enterprise?

    • Anonymous's avatar
      Anonymous
      Not applicable

      parry2k it is on-premise, I am not using gateway, only direct query.

      • parry2k's avatar
        parry2k
        Super User

        Anonymous  is it personal or enterprise gateway? if you expand gateway section , what do you see? I think thats where the issue is?