Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
I've been creating reports using Power BI, but migrated over to PBI Server because one of the key requirements for my project is the ability to automatically update what's in my SQL tables into Power BI to display through the reports. Of course, I've realised that Express doesn't have SQL agent and so it cannot schedule via the front end to do this as and when I require.
I don't have the budget to buy an Enterprise licence, and so I am desperate for any way in which to automatically or SQLCMD via Task Scheduler complete this process. Any ideas or suggestions would be of great help.
You don't need an Enterprise Edition of SQL Server to get SQL Agent. You should be fine using the Standard Edition which is significantly cheaper.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
7 | |
5 | |
3 | |
3 |