importing data into the cloud data storage

[fbc]

I have a setup where I am using the PowerBI cloud data storage for my data, as opposed to an external database.  I am trying to import data from a 3rd-party program directly into the cloud data storage (not importing thru the website or desktop app), just like I would if I was hosting my data on an SQL server or any other external database.  How do I find the details (connection name, url, passwords, etc....) that I need in order to connect to the cloud data storage? 

[ibarrau · Accepted solution]

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-storag...

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,