On-Demand Data to Embedded

[barakb32]

Hi,

We want to embed reports in a website based on very large data residing in Fusion Metadata.

As I am less familiar with embedded (more with the service), my thoughts are:

- Since the source data is very large, it calls for Direct Query

- Since there is connector to Fusion MetaData, it calls for an API (which doesn't work with Direct Query).

Am I missing something? Maybe in embedded I can bring data to the user without bringing it to the model in ways other than DirectQuery?

Barak

[v-shex-msft · Accepted solution]

Hi @barakb32,

Did this API support odbc driver? If that is the case, you can consider designing a custom connector with odbc driver and enable 'direct query' connection mode.

Solved: Enabling direct query for a data source via an odb... - Microsoft Power BI Community

Regards,

Xiaoxin Sheng