Hello all. I am a new, recent downloader of Power bi and am really appreciating what it can do for me! But I have a question that I am unsure of and need some help with this one.
OK. So I have a ASP.NET MVC Web Application in Visual Studio which uses the default SQL Server that is given inside of VS. It is storing the database tables in (localdb)\MSSQLLocalDB ... I created a table a while ago and am looking at two fields to be visible on a chart from Power bi, PlayerID and TotalHits. There are 10 players (as of right now) and each of them has a different amount of TotalHits from different Sessions. I added a new record today inside of VS and Power bi picked up that information.
So my question is, how can I/ is there a way to integrate my Power bi charts into my ASP.NET MVC Web Application that would also update when loaded if new data has been added to the database. It would be pointless to integrate a file right now that could not be updated as that is what I am trying to avoid. Please let me know if there is a way to go about this problem. Thanks
