Forum Discussion
Advocate IIIPower BI Best Practices for the Analyst/Developer (admin) in Enterprise SSAS Environment
This is awesome! Exactly what I needed. Thanks so much for the help. As I'm setting up the environment, or once it's setup, I may return with a question or two, if that's ok. I'll try to find the answers first before bothering you, though.
Man, fantastic! Thanks again!
Based on what you've written. You are doing the Power BI Reporting with a live connection to the Model in SSAS. I prefer using Power BI Desktop for performance reasons. I found the cloud editor slower and frustrating.
If you wanted to look at the data model itself, get yourself Visual Studio Professional (you'll need SSDT as part of the installation and the Analysis Services extension) or Tabular Editor. I found Visual Studio more user friendly but did work with someone who felt the reverse. Depending on your permissions you should be able to download the model out and review it in either tool. In my case, we use source control on our SSAS models and we get the models through the Solution Explorer in Visual studio. Might be worth checking if your org uses TFS or Git for SSAS.
As for usage metrics. Power BI offers you the ability to check the usage metrics of any report, going back about a month. Power BI's APIs can also let you download usage out, which you could store locally and keep a history.
As for Power BI Dataflows, since all the data is already modelled in SSAS and you're just bolting a report on top, there is no reason to use Power BI Dataflows.
- polymathy2017
This is awesome! Exactly what I needed. Thanks so much for the help. As I'm setting up the environment, or once it's setup, I may return with a question or two, if that's ok. I'll try to find the answers first before bothering you, though.
Man, fantastic! Thanks again!