The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
Aktiv Directory is an Import Connector, but Power bi think its an Direct Qeury and Dissable the Puplish to Web option (if the Preview Hyprid mode are enabled.)
Had similar issue. I published PBIX file with Import connect and I have a Q&A feature in my report. When I went to the service it told me to change from Direct Query mode ( but im in Import mode )???
i think i found my problem---
my modell used in the Activ Directory Table a many to many relationship, this is also a Preview function and is in the same Preview Option as Hyprid Mode
Glad to hear you found the cause. It's true that it's not possible to publish models using Many to Many relationships to the Power BI service based on this article.
@TexasBI Please check if you hit the same limitation as @Anonymous. Also please ensure the report doesn't contain composite models. From this article: While composite models are in Preview, it is not possible to publish composite models to the Power BI service.
Best Regards,Qiuyun Yu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.