Scenario: Microsoft 365 usage analytics provides a dashboard in Power BI that offers insights into how users adopt and use Microsoft 365. We can find and use it in Power BI Service apps. But if you still want to get personalized or deeper insights, how will you connect the data model to create a report in Power BI Desktop?
Scenario1: When you modify the data structure in the data source, the refresh error occurs. Scenario2: When you have pivot columns steps in query editor, the value in the data source has been modified, the refresh error occurs.
Since starting to use Power BI I have been advocating the following 'basic' model
However. You can also create reports within Power BI Service. This is mentioned within the certification route for DA 100 Analysing Data with Power BI. Which makes things a little more confusing and I have been asked on lots of occasions. "If you can do everything in Service, what is the point of using Desktop?"