Does anybody know if it is possible to connect to a Power BI dataset from Power Apps, in the same way you would connect to database table? I have looked at the Power BI Connector available in power apps but I am not sure if this is what I want. I'm not interested in the reports or analysis that Power BI can do, just the data in the dataset. In my case it would be querying a SQL Server view and I only need read only access.
By the way, the reason why I want to connect to the data via power BI rather than directly through the SQL Server connector is because I'm having problem using that with Universal MFA - I have a separate question open for that.