Power bi embedd with live connection or direct query

[Anonymous]

Hello, I am trying to find a definitive answer to the capability of using a live connection or direct query to Azure SQL Server DB with Power BI Embedded. The embedded report on my web site never loads when I use a live connection. If I use Direct Query the page returns an error message 'Can't display the visual. See details'.

I would not think that I would have to create an import type of connection for this to work.

Thank you.

[Anonymous · Accepted solution]

Hi @Anonymous,

According to your description, it seems like the issue is more related to data source configurations. How did you config these data source and gateway settings on the power bi service side? Please share more detailed information to help us clarify your scenario and troubleshoot.

How to Get Your Question Answered Quickly 

BTW, have you enabled the RLS and UPN mapping on your data source? AFAIK, they can also affect embedded feature usages. You can take a look at the following links to know more about them:

Manage your data source - Analysis Services - Power BI | Microsoft Docs

Using row-level security with embedded content in Power BI embedded analytics - Power BI | Microsoft Docs
Regards,

Xiaoxin Sheng