Forum Discussion

icassiem's avatar
icassiem
Post Prodigy
1 year ago
Solved

PBI Service as Storage

Hi,

 

I dont have a storage environment to service complex support queries, i have 3 Read replica RDS and S3 API gateway (all WIP)

But i need to write queries across all my source architectures.

 

Can i via desktop publish all the source tables to PBI service as datasets and then use dbeaver/pbi desktop to connect?

Any ideas, i dont have fabric or anything. Maybe that DB for azure apps

 

Regards

  • Philosophically Power BI is a downstream system, It does not guarantee any reliable storage. It is based on a "Flush and Fill" methodology. Fabric changes that equation, but only a little bit.

     

    Don't base your storage strategy on Power BI or Fabric.  Use proper dedicated storage systems as your upstream source.

2 Replies

  • Philosophically Power BI is a downstream system, It does not guarantee any reliable storage. It is based on a "Flush and Fill" methodology. Fabric changes that equation, but only a little bit.

     

    Don't base your storage strategy on Power BI or Fabric.  Use proper dedicated storage systems as your upstream source.

    • icassiem's avatar
      icassiem
      Post Prodigy

      Thank You lbendlin , I have nothing at my disposal. 

      PowerBI is my only extract or integration

      I was looking at free storage systems but that would not be good governance