Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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? 🙂
Solved! Go to Solution.
Hi @RustyF
You may refer to the article and follow the steps in it to set up scheduled data refresh.
Regards,
Cherie
Hi @RustyF
You may refer to the article and follow the steps in it to set up scheduled data refresh.
Regards,
Cherie
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.