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.
Hi!
I have a problem when using export to Excel with live connections from a Power BI visual or creating a table from Excel connected to a Semantic Model. I get the columns I choose and I also get columns with the format definitionen for every measure I have chosen and every sortcolumn for the dimension columns I have chosen.
I pick one dimension column (Contry) and one Measure (Sales Net)
When the table is created I got 2 extra columns, one sort column for "Country" and the formatstring for Sales Net
Is it possible to create the tabel without getting this extra columns?
Regards
Fredrik
Hi @FredrikJ
Yes, hide these columns from the model view.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi!
They are already hidden in the model view.
Regards
Fredrik
@FredrikJ
How do you make a connection?
I tested it in my machine and the hidden column didn't appear.
if the problem is with export visual , then just choose "current layout" instead of "summarized data"
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi!
Yes it works fine in Piovot Tables but we want to have a live connected tabel, no Pivot table.
Regards
Fredrik
@FredrikJ
Then it works like "summarized data" so there is no option to hide the "
sort columns"
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
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 |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
138 | |
107 | |
104 | |
82 | |
63 |