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.
Hi all
We're currently looking at the feasibility of moving away from Reporting Services to Power BI, but we believe we have a limitation in terms of a like for like replacement where the subscription function of the Power BI Service is concerned. We have some subscriptions at the moment in Reporting Services which are pushing report data out to a fileshare, but it doesn't seem that this particular operation can be achieved in Power BI.
Unless I'm mistaken(?), then we will need to find alternative means to replicate this functionality, so I wondered if anyone has encountered the same problem and how they've gotten around it?
Thanks in advance for any responses.
Michael
I noticed you gave kudos to Collin on this thread, I've still not had time to properly investigate his suggestions, but I did wonder, do MS have any plans to introduce such a feature (subscription to file) for Power BI in their Product Roadmap?
Thanks
Michael
Hi, @MichaelP2020
I'm sorry that there seems currently no direct way to subscription to file.
Best Regards
Janey Guo
Thanks for the details Collin, certainly gives me a few avenues to look into.
Hi @MichaelP2020 ,
I believe that the way to do it is to use the API and Flow to save the report to a location.
You can use the API to export the file
https://docs.microsoft.com/en-us/rest/api/power-bi/reports/exporttofile
Here is an example of svaing a report to OneDrive:
And, a similar example by Erik Svensen here:
ANd, Chris Webb has some blogs about using the API's:
https://blog.crossjoin.co.uk/category/power-bi-api/
So, I know none of these are the exact precise answer but combined I think they will guide you down the path.
I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!
Proud to be a Datanaut!
Private message me for consulting or training needs.
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.