Forum Discussion
Executive Semantic Model
MiquelPBI That would have made life super easy. How large are DAX query return is going to be? Maybe run DAX queries using Power Automate and store the output somewhere in the files and then use it for the semantic model.
Thank you for the suggestion and I made a note. I'm curious if there are options to accomplish our second or third attempt without putting the data somewhere outside Power BI before getting it back in Power BI.
You can use direct query connection to the semantic models but RLS and OLS will be inherited so if the users do not have the right permission or don't have access to the semantic models, they won't be able to see the contents of the reports. So I think as what parry2k has suggested, storing the result of a DAX query outside Power BI is your only option. Aside from running a DAX query with Power Automate, you can also export the data from a visual that isn't in a live connection report and select the option to connect live to the semantic model. Store the Excel file in a private SharePoint folder. You can automate the refresh by creating a scheduled Power Automate flow that adds a row to a table in the same Excel file as the live connection export. You can have as many live connection exports in the same file so you only need one flow to refresh the queries. The caveat is the flow won't fire if there are multiple users opening the file at the same time
