cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mmorley Frequent Visitor
Frequent Visitor

SQL Connections authenication problems

Hi,

 

I have a sql server 8.00.818 (this is a legacy setup and cannot be upgraded to latest versions) setup but unable to get powerbi to refresh from this server on regular basis as it fails saying there is an issue with the credentials, but when checking the gateway and datasources these are fine.

 

So I setup a test on a sql express 14.0.1000 setup which pulls the data from the original server and then I have powerbi use the sql express database and this works fine with no issues with a scheduled refresh, but as I can't configure jobs scheduled jobs within sql express I thought I would try getting it to work with a sql server 9.00.5266.00 setup, which I know is still an older version of SQL, but again I still get the issues with the credentials.

 

Is there a limitation of what version of sql can be used with power bi to successfully refresh data.

 

thanks

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
mmorley Frequent Visitor
Frequent Visitor

Re: SQL Connections authenication problems

Hi @v-danhe-msft,

 

The issue with the credentials is that PowerBI say they are incorrect, even though the same credentials work via the desktop app and authenticate ok in the datasource in the gateway.

 

the 'i can't configure scheduled jobs within sql express' litterally means that, within sql express you cannot setup scheduled jobs to run on a regular basis like you can on sql enterprise editions. A solution I will need to do is setup a scheduled task to run a script

 

I since found out the issues are to do with PowerBI and that you cannot use sql versions prior to 2005 for direct queries and this is the reason why the authenication is failing, it would be better if powerbi gave you a more informative response that was related to this issue.

 

 

2 REPLIES 2
v-danhe-msft Super Contributor
Super Contributor

Re: SQL Connections authenication problems

Hi @mmorley,

Could you please post the problem with the crendials and could you check if you could refresh your data in Power BI Desktop?

And I could not understand the sentence "I can't configure jobs scheduled jobs within sql express", could you please offer more information about the 'jobs' and 'scheduled jobs'?

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
mmorley Frequent Visitor
Frequent Visitor

Re: SQL Connections authenication problems

Hi @v-danhe-msft,

 

The issue with the credentials is that PowerBI say they are incorrect, even though the same credentials work via the desktop app and authenticate ok in the datasource in the gateway.

 

the 'i can't configure scheduled jobs within sql express' litterally means that, within sql express you cannot setup scheduled jobs to run on a regular basis like you can on sql enterprise editions. A solution I will need to do is setup a scheduled task to run a script

 

I since found out the issues are to do with PowerBI and that you cannot use sql versions prior to 2005 for direct queries and this is the reason why the authenication is failing, it would be better if powerbi gave you a more informative response that was related to this issue.

 

 

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 41 members 1,041 guests
Please welcome our newest community members: