Forum Discussion

Bokazoit's avatar
Bokazoit
Continued Contributor
7 months ago
Solved

Incremental refresh from API as zip file possible?

I can retrieve the data as a zip file, unpack it and load it into a table in Power BI desktop, but how to add incremental refresh? CoPilot says that retrieving data as zip file removes query folding,...
Need Help
  • v-hjannapu's avatar
    v-hjannapu
    7 months ago

    Hi Bokazoit,
    I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.

    Regards,
    Community Support Team.

Bokazoit's avatar
Bokazoit
Continued Contributor
7 months ago

We are moving away from traditional Data warehouse. But I can use Dataflow Gen2 with a PPU licens?

v-hjannapu's avatar
v-hjannapu
Community Support
7 months ago

Hi Bokazoit,

Yes, Dataflow Gen2 can be used with a PPU license. Since you are moving away from a traditional data warehouse, this option should work well for you.

Incremental refresh will not work directly on ZIP files, but you can use Dataflow Gen2 to load and transform the data and store it in a Lakehouse table. Once the data is in the Lakehouse, you can build your model on top of it and use incremental refresh there.

So using Dataflow Gen2 as an intermediate step is the supported way to handle this scenario.

Hope this clarifies. Please let us know if you need any help setting this up.
Regards,
Community Support Team.

  • v-hjannapu's avatar
    v-hjannapu
    Community Support
    7 months ago

    Hi Bokazoit,
    I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.

    Regards,
    Community Support Team.

    • v-hjannapu's avatar
      v-hjannapu
      Community Support
      7 months ago

      Hi Bokazoit.,
      I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We are always here to support you.


      Regards,
      Community Support Team.

  • Bokazoit's avatar
    Bokazoit
    Continued Contributor
    7 months ago

    Plz tell me how to enable it, I can't find it in the settings in power bi

    • v-hjannapu's avatar
      v-hjannapu
      Community Support
      7 months ago

      Hi Bokazoit,
      Dataflow Gen2 is not enabled from Power BI Desktop, so you won’t see it in Desktop settings. It is available only in Power BI Service Fabric.

      Please check this once:
           Login to Power BI Service
           Open a Fabric-enabled workspace
           Click New → you should see Dataflow Gen2 there

      If you are not able to see the Dataflow Gen2 option, it usually means Fabric is not enabled for your tenant or you don’t have the required workspace permissions. Once this is available, you can use Dataflow Gen2 to load the data into a Lakehouse and continue from there. Please check this once and let us know if you are still facing any issues.

      Regards,
      Community Support Team

      • Bokazoit's avatar
        Bokazoit
        Continued Contributor
        7 months ago

        Oh, that was what I was asking for - can I enable Gen2 only having PPU licens. I do not have fabric, since it costs money too. But what You are saying is that fabric is needed?