How to connect interaction history fact table with PowerBI tool?
Right now I am using data from interaction history fact table as the data source for a dashboard report in PowerBI. Every time I have to export the table as Json file and load that file into PowerBI manually to refresh the report. I wonder if there is an automatic way of connecting interaction history fact table to PowerBI. I know Python.