Forum Discussion
MicrosoftUser42
1 year agoFrequent Visitor
PowerBI Semantic Models not supported as Direct Query Source in Export to File API
As of now, the Export to File REST API does not support Direct Query Sources (especially PowerBI Semantic Models combined with other data sources). It always shows "Error fetching data for this visua...
Anonymous
1 year agoNot applicable
Hi MicrosoftUser42 ,
Thanks for your sharing. There are some limitations and considerations when export the report to file, you can find the details in this official documentation.
Best Regards
- MicrosoftUser421 year agoFrequent Visitor
Thank you for your response! I don't think dynamic binding is the problem, because there aren't multiple semantic models being used as data source. (Would dynamic binding mean, I have to specify the desired semantic model in the API query?)
But I think your hint towards SSO was correct. For the affected report we do use a composite model with data sources that use SSO. I don't think turning SSO off completely would be a good solution, because that is how access to the data is supposed to be managed. But is there any other way to bypass this issue?