Way to read data FROM Power BI dataset into another source?

[proeyekyuu]

Hello!

I have a rather complicated Power BI Dataset that pulls a lot of information via Web.Contents.  I transform this data and merge it with a whole host of other queries to get the final product I need. One of the websites I draw from updates daily, but does not keep the information that was there prior - it merely updates to the new days' numbers. I'm trying to basically automate copying and pasting out one of my Power BI tables to a CSV on a daily basis.

I'm very open with what tools may make this possible, as long as it can automate grabbing that data for me without me having to do something on a daily basis. I've looked into Power Apps but it looks like that is more for getting data into Power BI rather than out of Power BI. Is this possible (I do have a Pro license, just not Premium)?

[v-stephen-msft]

Hi @proeyekyuu ,

Could you tell me if your problem has been solved?
If it is, kindly Accept it as the solution. More people will benefit from it.
Or you are still confused about it, please provide me with more details about your problem.

Best Regards,
Stephen Tao

[v-stephen-msft]

Hi @proeyekyuu ,

Try to add the data source in Manage Gateways and set Scheduled refresh.

Reference: Add or remove a gateway data source

                  Configure scheduled refresh

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[GilbertQ]

Hi @proeyekyuu 

it sounds like you need to use another tool such as Azure Data Factory or something to download the files on a daily basis and store it somewhere (That could be Azure Blob Storage) and then use that to bring in this data on a daily basis.

You could also look at Power Automate to do this for you and store the file in OneDrive.