Extract Power BI data & measures with Power Automate

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

КОМЕНТАРІ • 24

  • @willkhan6679
    @willkhan6679 14 днів тому

    Thanks for sharing. I've briefly explored the running query against a power bi dataset step, but I can only see my dashboard under the dataset selection. How do I set this up so that I have access to the dataset(s)?
    Currently, my report is built off dataflows that sit under my fabric workspace and my report is ingesting these as inputs. Have I gone wrong somewhere in this initial infrastructure setup?

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

      So who built the model that your report is based on? Are you saying you don’t see the Semantic model icon when you go into your workspace?

    • @willkhan6679
      @willkhan6679 12 днів тому +1

      Hello mate, I figured out the issue. As it is with these things the solution is often simpler than the problem. I forgot to publish the latest version of my model, so the dax query which was providing the expected output in the desktop version now works when I schedule the flow. All I had to do was publish the model to reflect the latest change I'd implemented in my desktop version of the pbix file. Duh. Thanks for your help 👍🏻

    • @AccessAnalytic
      @AccessAnalytic  12 днів тому +1

      @willkhan6679 glad you got it working

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

    this is brilliant for me, thanks

  • @saakshimankar6215
    @saakshimankar6215 7 днів тому

    Can we apply dynamic filter on our datset using this flow ?

    • @AccessAnalytic
      @AccessAnalytic  4 дні тому

      I believe you could edit the query text to pass a dynamic parameter in. I’ve never tried though.

  • @chrism9037
    @chrism9037 2 місяці тому

    Very cool, thanks Wyn

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

    Amazing, thanks.

  • @mienzillaz
    @mienzillaz 2 місяці тому +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  2 місяці тому

      Any tips?

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

      @@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  2 місяці тому

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

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

      @@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  2 місяці тому

      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?

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

    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  Місяць тому

      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 2 місяці тому +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.