Forum Discussion
Minimum credentials on SQL Server to connect via Power BI Desktop
I would like to create a user on SQL Server with minimal permissions (ideally Read Only) that can then be used to log in via Power BI Desktop. My *.pbix file connects to a database View via DirectQu...
This was a weird one, but thankfully someone at DBA.StackExchange gave the simple answer which solved it.
The solution was to use a brand new username and start from scratch. Previously I was using a Username which we use in other places and it must have had some other associations with it. But, when I used a new Username, it immediately worked as expected!
This was a weird one, but thankfully someone at DBA.StackExchange gave the simple answer which solved it.
The solution was to use a brand new username and start from scratch. Previously I was using a Username which we use in other places and it must have had some other associations with it. But, when I used a new Username, it immediately worked as expected!