Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
proeyekyuu
Frequent Visitor

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

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)?

 

 

 

 

3 REPLIES 3
v-stephen-msft
Community Support
Community Support

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
Community Support
Community Support

Hi @proeyekyuu ,

 

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

 

17.png

 

 

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
Super User
Super User

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. 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors