Forum Discussion

rahulnaik126's avatar
rahulnaik126
New Member
7 years ago

Unable get data from SQL Server in Power BI Desktop

Hi,   I am trying to get data from MS SQL Server into Power BI Desktop. I am trying with local instance of SQL Server. I am connecting to local instance using Windows credential. The server is gett...
Need Help
v-lili6-msft's avatar
v-lili6-msft
Community Support
7 years ago

hi, rahulnaik126 

If you get data from sql server by this document:

https://powerbi.microsoft.com/en-us/blog/pull-data-from-sql-server-with-power-bi-designer/

https://docs.microsoft.com/en-us/power-bi/service-gateway-sql-tutorial

And if you have changed the display options as below:

 

And also please check that if your account has view definition permission on the table in SQL Server. Go to Files>Options and settings>Data source settings, select Global permissions, delete any existing SQL Server data sources and then connnect to your SQL Server from Power BI Desktop.

 

Best Regards,

Lin

rahulnaik126's avatar
rahulnaik126
New Member
7 years ago

Hi v-lili6-msft ,

 

Thanks for the response, but I am still facing same issue. I am logging using Windows credentials and database, both the user have View Definition permission.

 

When I am trying to connect using windows credentails, the server get connected but it's not showing any databases or table under it. And When I am trying to connect using database credentials, it is giving me below error:

 

"We couldn't authenticate with the credentials provided. Please try again."

Due to Security policy I can't attach screenshot here. Please help me to resolve this.

 

Thanks,

Rahul Naik