Forum Discussion
Call C# executable from a cloud flow to refresh Power BI dataset automatically
I have a requirement to call a C# executable from my Power BI report that can refresh dataset automatically in PBI service.
Point to note here is that my C# exe exports dataset results in Excel file(.xlsx).
Now, the question is whether this scenario is at all possible in PBI service so that Scheduled Refresh works(by calling C# exe internally and importing the results from Excel file into PBI report)?
I can run C# console app locally and get data from excel in the report but I need to schedule it automatically in service. Is it somehow possible?
Thanks
1 Reply
- amitchandakSuper User
Anonymous , Explore if REST APIs and Cmdlets can help. You should be able use them in programming
https://docs.microsoft.com/en-us/rest/api/power-bi/
https://docs.microsoft.com/en-us/powershell/power-bi/overview?view=powerbi-ps