Mixing DirectQuery and Import modes does not allow me to see published report in Service?

[dtartaglia]

Hi,

Is there a fix to this or is this a known issue? The DirectQuery from SQL is preventing Service from showing the report.

Thanks,

Dan

[v-shex-msft]

HI @dtartaglia,

AFAIK, power bi service does not contain this limitation. Do you confirm you are succeed configured datasources and correspond data source credentials?

Data refresh in Power BI 

Use DirectQuery in Power BI Desktop 

In addition, any advanced operation you apply on query tables? (e.g. merge, combine, reference other query tables, invoke custom functions...)

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng