I have a use case that, my mongo DB is in cloud , and i have used power bi connector account and inside Power BI Desktop , Native SQL statements were used to create a dataset/semantic model. When i try to schedule inside power bi service, i am getting an error like , unsupported data source. Without power bi gateway, is there a provision to enable a data refresh scheduler inside power bi service with cloud based solution. let
Source = Value.NativeQuery(MongoDBAtlasODBC.Contents(“mongodb://atlas-sql-xxxxx?ssl=true&authSource=admin”, “xxxx”, ){[Name=“xxxx”,Kind=“Database”]}[Data], “select * from xxx”, null, [EnableFolding=true])
in
Source
For cloud based Mongo DB, looking for complete cloud solution. Please support.