Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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)?
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
Hi @proeyekyuu ,
Try to add the data source in Manage Gateways and set Scheduled refresh.
Reference: Add or remove a gateway data source
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
50 | |
18 | |
17 | |
16 | |
8 |