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.
@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.
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.
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.