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.
I have a report that uses a flat file that is pulled from a database using import. The pbix file is then provisioned for use in an embedded version. Is there anyway I can automate the building of the pbix file daily so that it contains the latest data? Or any other way to ensure that the data is updated once a day.
I can use direct query as the database is on a secure VPN.
Thanks in advance
@DrBiker You don't need to build pbix file daily to get latest date. Once published to power bi service you need to setup schedule refresh of that report in service daily from on-premise data source using data gateway.
Does that work on embedded (not service?)
I could not find a way to schedule update for embedded through the gateway, only for service.
Would be very happy if someone could let me know how to do this for a provisoned embedded solution.
As you're using Power BI embeded, I suspose that you're already in an Azure subscription. One approach is using Azure SQL database to automate your practice.
Then the embeded reports would be always up to date.
So the above solution is to use an Azure SQL database? Our data is already in one but we find that the connection is rather flakey such that we often get half the visuals on a page loaded while the rest have errors indicating that the server could not be found. Also with the direct query it can take minutes to laod ten visuals.
For the reasons above we have been forced down the import route and was hoping that, if we cannot get the SQl server working consistently, then we could automatically rebuild the pbix file each day with the new data in it and provision it to be used by the embedded version.
Kind regards
Paul
Have you confirmed the reason of the slowness with direct query? Can it be caused by the query perfomance in your Azure SQL database? Ideally there should be no problem workspace collection(where your pbix is imported)
By the way, according to one reply from this thread, new client side API would come soon. Let's see what can the API do with a PBIX file.
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 |
---|---|
107 | |
97 | |
75 | |
65 | |
53 |
User | Count |
---|---|
144 | |
103 | |
98 | |
85 | |
64 |