Forum Discussion
Connecting Power BI Service dataset with SQL Server
Hey, i am facing an issue descripted below. I do have a etl process with power query, which is gathering data from ~50 files from network drive. This is creating a dataset, which refresh is sched...
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?