Forum Discussion
Dataset creation in DirectQuery mode and the Snowflake data source
- 9 years ago
That scenario can be the only approach, to implement "no human interaction", you could schedule your C# script to run in a certain interval. When adding rows, do note the API limitation.
I have no idea on any ETA, just keep one eye on the developer blog.
"One scenario would be like , read the data from snowflake in C# via the snowflake API, add the rows to the dataset via Power BI REST API"
Thanks. I am doing that for the moment.
Do you know the likelyhood of those additional features of the API and DirectQuery (i.e. are they short term priority and are likely to land in the next 4 months?). Using the desktop feature is ok for prorotyping but I am creating something that needs to deployed and manage a dimensional model without human interaction.
That scenario can be the only approach, to implement "no human interaction", you could schedule your C# script to run in a certain interval. When adding rows, do note the API limitation.
I have no idea on any ETA, just keep one eye on the developer blog.