Forum Discussion

DrBiker's avatar
DrBiker
Advocate II
10 years ago

Auto building pbix file

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 

Need Help

5 Replies

  • ankitpatira's avatar
    ankitpatira
    Community Champion
    10 years ago

    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.

    • DrBiker's avatar
      DrBiker
      Advocate II
      10 years ago

      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.

       

       

      • Eric_Zhang's avatar
        Eric_Zhang
        Microsoft Employee
        10 years ago

        DrBiker

         

        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.

        1. Create an Azure SQL Database and then connect to it in Power BI desktop in DirectQuery mode.
        2. Design your report and import the pbix to your workspace.
        3. Set the azure credential via REST.
          Patch GatewayDatasource
          Data source connectivity
        4. Set up an automation process to load the flat file into the Azure SQL database via an ETL tool like SSIS(if SQL Server, a database is mentioned in your post) or any other ways.

         Then the embeded reports would be always up to date.