Forum Discussion
Connecting Power BI Service dataset with SQL Server
HI nitishsh91,
This is required by another person, who is external (external - i mean who does not have access to network drive) to have refreshable dataset - who is gathering different datasets into sql server.
So we've been looking for a solution to provide this dataset as a refreshable data into sql server.
I think analyze in excel requires trigger in order to refresh data - which forces user to do such an activity daily or sth.
This doesn't need refreshing dataset as you are already refreshing the data as per your schedule and if you need to access that dataset you can easily do it via this analyze in excel feature which requires you to have access on dataset.
Otherwise you will have to download refreshed data from dataset and then load it in your sql as I haven't seen any default way of doing it.
Hmmm, what if row level data is required? Is there a way? Did anyone have any experience?