Extract Power BI data & measures with Power Automate

Поділитися
Вставка
  • Опубліковано 3 лис 2024

КОМЕНТАРІ • 18

  • @stephencoates544
    @stephencoates544 Місяць тому +1

    this is brilliant for me, thanks

  • @pthapa55
    @pthapa55 Місяць тому +1

    Amazing, thanks.

  • @chrism9037
    @chrism9037 Місяць тому

    Very cool, thanks Wyn

  • @davidanalytics1359
    @davidanalytics1359 17 днів тому

    Consider this scenario, I have a PBI report that refreshes everday and i want to extract that data and append it. I dont want it to overwrite the table but always append so that I have historical record. How can i do this? Please

    • @AccessAnalytic
      @AccessAnalytic  17 днів тому

      The csv files could become your data source and then use “from SharePoint folder” connector to consolidate them?
      ua-cam.com/video/-XE7HEZbQiY/v-deo.htmlsi=YUWL7sGbRfEclx0H

  • @stephencoates544
    @stephencoates544 Місяць тому +1

    i found a bug (perhaps), does anyone know a solution. Issue: although the query defines the COLUMN ORDER. I have found that if the FIRST ROW (record) has NULL CELLS (items) the column is MOVED to the END of the COLUMNS in the OUTPUT to .CSV.

  • @mienzillaz
    @mienzillaz Місяць тому +2

    Worth mentioning how to loop through data model as there's a limit how much stuff you can call on one go.

    • @AccessAnalytic
      @AccessAnalytic  Місяць тому

      Any tips?

    • @mienzillaz
      @mienzillaz Місяць тому

      @@AccessAnalytic usual you want to index your data in the model, set bunch of variables, one of which will be batch size, then initial value and optionally count for loops, as then at the end you want to append everything, and each CSV will have own headers, and you don't want them. Loop number will help you with that as then you can skip first row in CSV for loops beyond first one.

    • @AccessAnalytic
      @AccessAnalytic  Місяць тому

      Cheers, so this as a workaround to a paginated report when you want large data exports and don’t have premium capacity ?

    • @mienzillaz
      @mienzillaz Місяць тому

      @@AccessAnalytic no, there's a limit when you query dataset in power automate regardless if the premium. In your case you called single value, so no risk there.. but if you want to catch a snapshot this is the only way..

    • @AccessAnalytic
      @AccessAnalytic  Місяць тому

      Sorry, what I’m saying is a paginated report would be a simpler solution but that requires premium capacity.
      Any idea on what the data limit is?