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.
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
Desktop version
Enabled preview features
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
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
Any ideas? Anyone?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
98 | |
81 | |
65 | |
62 |
User | Count |
---|---|
147 | |
116 | |
104 | |
88 | |
65 |