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

Database credentials lost when report published to powerbi.com

Hi there, tearing hair out on this one

 

Context:-

- Using PowerBI Pro, building on desktop, publishing to PowerBi.com to share

- Using database credentials to authenticate to Azure SQL database - all fine locally

- Azure SQL server is open for Azure service use

- No current option to use AAD or AD for windows auth

 

Reports are working fine locally but when I publish reports to portal, and then try to configure auto-refresh, the database credentials are lost and it says "invalid credentials". 

 

When I try to re-select the database credentials, the option is gone - I can only choose, Windows, Basic or OAuth2 - the database option is gone.  None of those options are useful.

 

What am I doing wrong? Smiley Happy

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-cherch-msft Super Contributor
Super Contributor

Re: Database credentials lost when report published to powerbi.com

Hi @RustyF

 

You may refer to the article and follow the steps in it to set up scheduled data refresh.

1.png

Regards,

Cherie

 

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-cherch-msft Super Contributor
Super Contributor

Re: Database credentials lost when report published to powerbi.com

Hi @RustyF

 

You may refer to the article and follow the steps in it to set up scheduled data refresh.

1.png

Regards,

Cherie

 

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
RustyF Frequent Visitor
Frequent Visitor

Re: Database credentials lost when report published to powerbi.com

I think that may have worked - although I'll know tomorrow if scheduled refresh works.

 

So I think the missing info from the documentation is that "basic" authentication is synonymous with "database authentication" when talking about Azure SQL databases.  That was not obvious to me as "basic" usually means HTTP Basic Auth.

 

Thanks again for your help.

Russ

 

 

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and 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.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 67 members 1,220 guests
Please welcome our newest community members: