Forum Discussion
importing data into the cloud data storage
- 4 years ago
Hi. First of all, we could say that Power Bi doesn't have cloud storage. You might be talking about dataflows that can handle some logic and keep some data. I wouldn't say it's a storage because you can't access that data with any other product rather than Power Bi Desktop and Excel.
If you really want dataflows to keep your data as storage, you need to purchase an Azure Data Lake Gen2. Then you can sync it with Power Bi Dataflows in order to keep snapshots of data there. You can read more about it here:
https://docs.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-azure-data-lake-storage-integrationOnce the data is in the lake you can get it from any tool (it has an API rest).
If you were talking about importing Power Bi Datasets. It's just loading data in a compress model. The model will only be available as an XMLA endpoint (like a SSAS server) if you have a premium (capacity or ppu) license.
I hope that helps,
Hi. First of all, we could say that Power Bi doesn't have cloud storage. You might be talking about dataflows that can handle some logic and keep some data. I wouldn't say it's a storage because you can't access that data with any other product rather than Power Bi Desktop and Excel.
If you really want dataflows to keep your data as storage, you need to purchase an Azure Data Lake Gen2. Then you can sync it with Power Bi Dataflows in order to keep snapshots of data there. You can read more about it here:
https://docs.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-azure-data-lake-storage-integration
Once the data is in the lake you can get it from any tool (it has an API rest).
If you were talking about importing Power Bi Datasets. It's just loading data in a compress model. The model will only be available as an XMLA endpoint (like a SSAS server) if you have a premium (capacity or ppu) license.
I hope that helps,