Forum Discussion

ebertsa's avatar
ebertsa
New Member
4 months ago
Solved

Switching PBI PPU environment's primary datasource from SQL DB to external Data Lake

We have the opportunity for our primary datasources in our PPU enviroment to swich from direct downloads using sql queries from our vendor azure instance to a new external data lake.   Sounds like a ...
Need Help
  • parry2k's avatar
    parry2k
    4 months ago

    ebertsa if you have Fabric capacity, you can use a shortcut and then use it for downstream systems. 

  • v-priyankata's avatar
    v-priyankata
    4 months ago

    Hi ebertsa 

    Thank you for reaching out to the Microsoft Fabric Forum Community.

    parry2k Thanks for the inputs.
    Super user was right & You’re thinking about it the right way that you’ll need the Azure Data Lake Storage Gen2 connector to connect. The main thing to be aware of is that Power BI Premium Per User only covers storage inside Power BI/Fabric, not external Azure Data Lake Storage Gen2, so that will still come with its own Azure costs. The Microsoft Fabric shortcut idea is a good one for simplifying the setup.

     

    If there are any deviations from your expectation please let us know we are happy to address.

    Thanks.

     

v-priyankata's avatar
v-priyankata
Community Support
4 months ago

Hi ebertsa 

Thank you for reaching out to the Microsoft Fabric Forum Community.

parry2k Thanks for the inputs.
Super user was right & You’re thinking about it the right way that you’ll need the Azure Data Lake Storage Gen2 connector to connect. The main thing to be aware of is that Power BI Premium Per User only covers storage inside Power BI/Fabric, not external Azure Data Lake Storage Gen2, so that will still come with its own Azure costs. The Microsoft Fabric shortcut idea is a good one for simplifying the setup.

 

If there are any deviations from your expectation please let us know we are happy to address.

Thanks.