Status:
Investigating
Direct Query not working with Dataverse and PBI dataset in Power BI Service
I have direct query data sources from dataverse and Power BI dataset and the report works fine in the PBI Desktop but gives error in the portal when the report is published.
v-cazheng-msft
Community Support
Community SupportHi JaideepS,
There are some transformation limitations on Direct Query connection mode itself and connection to Power BI datasets with Direct Query currently, which you could have a look at the following docs.
Using DirectQuery in Power BI - Power BI | Microsoft Docs
Using DirectQuery for datasets and Azure Analysis Services (preview) - Power BI | Microsoft Docs
For the release of some limitations, you could submit your needs in Power BI Ideas or vote for some fabulous ideas there. Thanks in advance!
https://ideas.powerbi.com/ideas/search-ideas/?q=transform
Also, you could subscribe official blog to receive the updates in Power BI at first time.
Power BI Blog—Updates and News | Microsoft Power BI
Best Regards,
Community Support Team _ Caiyun