The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
There is a PowerBI App where I have the option to "analyse in excel".
This brings up a Pivot table option where I can build a view using data from the model.
However there are many tables here columns have the same or similar names and not all of them appear to be complete.
Unfortunately I'm not able to influence the design of the model or the quality of the backend data.
What could be useful is knowing the the model structure is so I can see how the tables are linked.
Is there a way I can do this?
Hi @Anonymous
Is your problem that you can't distinguish the columns due to similar names and small pivot table field?
You can modify the pivot table field widths by dragging the borders.
If this reply still couldn't help you solve your problem, please show me a screenshot of your problem.
And show me the result you want. This may make it easier for me to understand your requirement.
You may refer to this blog for more details about Analyze in excel.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
51 | |
42 | |
24 | |
23 | |
22 |