Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
QUESTION:
Does anyone know where to find documentation for the best way to set up a dataset for Q&A? I've found this article but it doesn't go as in-depth as I would have expected. I know that setting up Q&A relies heavily on setting up the model in the most ideal way including making many changes and cleaning in the Model tab on Desktop, but I can't find anything about how to set it up on the Model tab. Additionally, with the new Model tab in preview, I can't find documentation talking about what all the new options and settings on that page mean? There are a lot of things that I don't understand what they do (namely the info under the Advanced dropdown on the new Model tab and the Display Folder under General). Anytime I have found something that does go into a deep dive it's outdated or talking about setting up Excel spreadsheets.
WHAT I'VE DONE:
I've done everything I can think of in setting up the Model in desktop:
Even with all of this, my Q&A is slow and not intuitive with the visuals it is producing.
EXAMPLES OF ISSUES
WHERE IS THE ISSUE
Again, I really feel like I must be missing something in setting up my model for Q&A but I can't figure out what I've missed. Searching for support docs on best practices for Q&A data modeling has not really gotten me anywhere and at this point. All behavior is replicated in both Power BI Desktop as well as in our Premium Power BI Workspace on both the report and the dashboard (I'm aware on dashboard Q&A you can change the visual by opening that pane, but that feature is not available in the report Q&A).
It's worth noting, I only have 1 calculated column and it's a simple IF function and the report has no measures. Even after removing this calculated column there was no difference in performance.
Thank you for any guidance/assistance!
EDIT: some grammar and clarification
@Anonymous,
So your requirement is to achieve a better quick insight using Q&A, right? You may refer to tips below:
Also, here're some blogs which may guide you to improve the model performance:
http://blog.pragmaticworks.com/power-bi-performance-tips-and-techniques
http://www.crmsearch.com/powerbi-best-practices.php
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for your reply. I've done most of those articles - I'm looking for documentation specific to Q&A. One big one is information on the model pane and what those options do because I'd guess they are important to set, but I don't know how/what to set them up as. All the articles I find are very similar to the ones you sent and mention the same basic ideas of what to do, but there aren't any details of what to actually set/where - the ones that do mention this are older and don't consider the big changes that have happened over the lat ~8 months. Also, I haven't found anything that talks about how to set up your data to get it to produce the visuals you ask for. I guess to narrow it down, here are the big 3 questions:
EDIT: Grammar and clarity.
Hi apfenech
I hope you find the answer, if so please tell me the road
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |