Forum Discussion
Composite Model relationship causing sqldumper error?
Hello, I am using the most recent version of Power BI Desktop. I am using the new composite model with some data coming directly from an Azure SQL database (A) and other data coming from a Power BI dataset (B). After relating a table from (A) to a table from (B) I then go to my report. As soon as I make any changes the SQLDUMPER.EXE screen appears briefly and my visual has the X and the text 'Can't display the visual. See Details. The details window is below:
Is there any solution to this? I would think this is how the composite models should work but maybe I am mistaken.
5 Replies
Anonymous , Check for some know issue at or create a new issue - https://community.powerbi.com/t5/Issues/idb-p/Issues
HI Anonymous,
Can you please share some detailed information to help us clarify these? It is hard to troubleshoot and reproduce your issue without any detailed information.
For example:
power bi desktop version, type(store, official, report optimize), Datasource and connector version.
Any preview feature enabled on the report? Since they are in preview test, so they may affect the usage of the original features.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin ShengHi Anonymous,
Have you worked with AS Data Source that connected with the 'direct query' mode that provided by the preview feature? If that is the case, this feature does some change on SQL connector and it may cause the issue. You can also take a look at the limitation of this feature:
Regards,
Xiaoxin Sheng
