Forum Discussion
You need to use SSL error for Fabric SQL database data source
Hi,
I'm trying to set up a translytical task flow.
Therefore I've created a UDF and a Fabric SQL Database. I've added the table I need from that database to my Power BI Datamodel via OneLake catalogue --> SQL database (preview). So far so good.
When I publish the datamodel to the service I get an error for the Data source credentials. I try "Edit credentials" and use OAuth2 for Authentication method and different Privacy level settings. Everytime I get the error "You need to use SSL (HTTPS) when you use OAuth 2.0 authentication.
What am I doing wrong?
Best regards, Carlos
Hi everybody,
I've finally found the solution. All settings and steps were correct from the beginning. The only thing that went wrong is that when you click "sign in" on the "edit credentials" form, a Microsoft pop up opens to log in with your Microsoft account. This pop up was blocked by a pop up blocker (which I didn't know I had in Edge...). So I never actually signed in. That was the cause of the error. The error message was misleading in a way.
Best regards, Carlos
4 Replies
Hi everybody,
I've finally found the solution. All settings and steps were correct from the beginning. The only thing that went wrong is that when you click "sign in" on the "edit credentials" form, a Microsoft pop up opens to log in with your Microsoft account. This pop up was blocked by a pop up blocker (which I didn't know I had in Edge...). So I never actually signed in. That was the cause of the error. The error message was misleading in a way.
Best regards, Carlos
Hi VaVi
The error you're encountering—“You need to use SSL (HTTPS) when you use OAuth 2.0 authentication”—occurs because the Power BI Service requires secure (SSL-encrypted) connections when authenticating via OAuth 2.0, especially for cloud-based data sources like Fabric SQL Databases accessed through the OneLake data hub. Although everything works in Power BI Desktop, the service enforces stricter security standards. The issue likely stems from the connection string or endpoint used in the OneLake Catalog connector not being HTTPS-compliant by default in the preview feature. To resolve this, ensure that your Fabric SQL Database is publicly accessible via an HTTPS endpoint and that the connection in Power BI explicitly targets the secure URL. Since the SQL Database (preview) connector is still evolving, it might not fully support OAuth2 via HTTPS in the service yet. As a workaround, try accessing the same data using the standard Fabric items > Lakehouse or Warehouse connector (which uses HTTPS) instead of the SQL Database (preview) route. Additionally, check the workspace settings and ensure your tenant allows SSL connections and that the data source configuration uses the correct HTTPS endpoint. If this doesn’t help, it's advisable to monitor Microsoft Fabric documentation for updates or raise a support ticket, as this could be a limitation or misbehavior in the current preview release.
Hi Poojara, thanks for your answer. I'll try to apply your suggestions although I first have to figure out how to do the things you suggest. For instance: "ensure that your Fabric SQL Database is publicly accessible via an HTTPS endpoint". I don't know how to do that. I'll try and figure it out. The Microsoft demo example of translytical task flows also uses a SQL Database, so it has to be possible even though it's in preview mode. I've seen it work in video's. The only difference I see is that the video uses sample data from the built in sample data option and I use a table I created myself. But that shouldn't be the problem I'd guess..
