If getting data from a relational source such as SQL Server, use views to abstract the report from the physical layout of database tables and never write queries inside reports; from a maintenance and development standpoint, it is simpler and faster to update a view than it is to edit a query inside a report and then republish the report.
Also, if available, create a separate schema for the views for grouping and security purposes. This is the recommended architecture:
Click here for a full set of Power BI best practices.
Please follow and like us:
Leave a Reply