Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
bpn1973
Resolver II
Resolver II

SQLDUMPER issue after reverting from composite to standard model

Hello!

Tried to create a composite model.

Nothing fancy - PBI dataset from PPU workspace + local data sources (.txt, .xlsx and .csv)
Didn't work for me due to limitations on calculated tables.

Since did a lot of work just removed the connection to the PBI dataset (reverted everything to local sources).

After every operation with a measure or upon creation of any relation i get an sqldumper.exe window. It flashes for a second or two and dissapears. PBI Desktop continues to work normally. Each dump creates a 8+/- mb .mdmp file along with abunch of others

 

bpn1973_0-1643837147366.png

Desktop version

bpn1973_0-1643876769880.png

Enabled preview features

bpn1973_1-1643876801575.png

 

 

 

4 REPLIES 4
bpn1973
Resolver II
Resolver II

That's not a PQ issue.

I've experimented with other simple models - result is the same - SQL Dumper.

The experiment - 
Create composite data model

Remove BI dataset

Get an SQL dumper procedure out of nowhere

 

Had to rebuild the file and avoid any compsoite mode for now. 

Hi, @bpn1973 

 

Have you updated your desktop version to the latest? 

If you only use the dq mode to connect to the data source to create a report, will it report an error?

 

Janey

v-janeyg-msft
Community Support
Community Support

Hi, @bpn1973 

 

You need to go to Power Query to see if there are any problems with the steps. It is not clear if there is an irreversible mix operation (with two data sources). You may need to recreate the report. Please share screenshots of the steps in pq(hide privacy).

 

Did I answer your question? Please mark my reply as solution. Thank you very much.
If not, please add information and feel free to ask me.

Best Regards,
Community Support Team _ Janey

bpn1973
Resolver II
Resolver II

Any ideas? Anyone?

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.