Composite Model relationship causing sqldumper error?

[Anonymous]

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.

[Anonymous]

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 Sheng

[Anonymous]

Thank you.

I am using Version: 2.88.1682.0 64-bit (December 2020)

My storage mode is mixed. One data source is a Power BI data set. The other source is Direct Query to tables in Azure SQL Server. The following preview features are set:

[Anonymous]

Hi @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:

Using DirectQuery for Power BI datasets and Azure Analysis Services (preview)#considerations-and-limitations 

Regards,

Xiaoxin Sheng

[amitchandak]

@Anonymous , Check for some know issue at or create a new issue - https://community.powerbi.com/t5/Issues/idb-p/Issues

[Anonymous]

Thanks Amit. I didn't see a solution so I will post an issue.