Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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,
Happy to help!
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,
Happy to help!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.