Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello this can by I bit simple but need to know how they can acess to the data that we have published online.
So we have SQL SERVERs and Excels Data, with that we have created with PowerBI Desktop reports that we have published online. I know that by documentation, all the data is stored in Azure Blob Storage and Azure SQL Server, in csv or json files.
My question is how I can access to this files\data?
Because when I go to the Portal Management of Azure I don't see anything similar to the names of my dataset. (I'm not the Admin of the Tenant of my subscription)
thank you. I hope you understand my question 😄
Solved! Go to Solution.
Hi @luis-martins ,
Your permissions allow you to see the Data Source or not. You cannot see the file in the Power BI server - you can see the data in the original data source (whether SQL, csv, Excel, URL, etc.). And, you can see that Data Source if you have the appropriate permissions in the Report/Dataset.
I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!
Proud to be a Datanaut!
Private message me for consulting or training needs.
Hey @luis-martins ,
So , the way that you worded the question the second time is a bit different than I took it the first time. I thought you were asking to see the data the Power BI was using that was encrypted that was loaded to the "Power BI cloud". But, when you ask if you can see the Gen 2 or Blob data the answer is, yes, you can. The Gen 2 data is stored. Assuming that you have permissions to view you can download the files from the repository. This article will help you:
https://docs.microsoft.com/en-us/power-query/connectors/datalakestorage
You can download them in a few different tools, but, this being a Power BI forum, that is what that link shows you how to view them.
I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!
Proud to be a Datanaut!
Private message me for consulting or training needs.
Hi @luis-martins ,
Your permissions allow you to see the Data Source or not. You cannot see the file in the Power BI server - you can see the data in the original data source (whether SQL, csv, Excel, URL, etc.). And, you can see that Data Source if you have the appropriate permissions in the Report/Dataset.
I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!
Proud to be a Datanaut!
Private message me for consulting or training needs.
Hello @collinq
Well I have the credencial for my SQL Server and for the Excel.
So is impossible to see the actual files and folders that are stored in Azure Blob Storage and Azure Data Lake Gen2 is that?
Thank you a lot
Hey @luis-martins ,
So , the way that you worded the question the second time is a bit different than I took it the first time. I thought you were asking to see the data the Power BI was using that was encrypted that was loaded to the "Power BI cloud". But, when you ask if you can see the Gen 2 or Blob data the answer is, yes, you can. The Gen 2 data is stored. Assuming that you have permissions to view you can download the files from the repository. This article will help you:
https://docs.microsoft.com/en-us/power-query/connectors/datalakestorage
You can download them in a few different tools, but, this being a Power BI forum, that is what that link shows you how to view them.
I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!
Proud to be a Datanaut!
Private message me for consulting or training needs.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.