Forum Discussion
Error message when using Direct Query
Hi hdemedici100 ,
You could explor the possibility of setting up a service principal or a dedicated gateway with specific credentials that can access the underlying data but does not expose it to the end users. This setup would allow automatic data refresh while maintaining the security and restrictions needed.
Best regards,
Lucy Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super UserHey hdemedici100 ,
yes, I'm referring to the 'Microsoft 365 Usage Reports' model, there is no need to import the model, you can transform the live connection to direct query model: https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about when creating the models "M365 Copilot" and "M365 Copilot detail".
Regards,
Tom
Hi TomMartens,
So the connection is already a DirectQuery connection:
In this circumstance, I really need to avoid giving the report consumers access to the 'Microsoft 365 Usage Reports' semantic report.
I've noticed in the semantic report settings for 'M365 Copilot' and 'M365 Copilot detail' lets you choose which 'Connection' to use to access the source semantic model (Microsoft 365 Usage Reports). I've been trying to play around with this to see if this can do anything, I've also been using this guidance: Add or remove a gateway data source - Power BI | Microsoft Learn, but I still haven't got anywhere yet.
Here is the configuration I've been trying to play around with:
The bottom one is the connection to the source semantic model (Microsoft 365 Usage Reports). I've tried the different configuration options, but have not had any luck yet.
Would welcome any further advice. Thank you!
Hi hdemedici100 ,
You could explor the possibility of setting up a service principal or a dedicated gateway with specific credentials that can access the underlying data but does not expose it to the end users. This setup would allow automatic data refresh while maintaining the security and restrictions needed.
Best regards,
Lucy Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.