Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago

CSV access from Azure Blob/File Storage

I have a dashboard built that runs from a local CSV.   In order to release the dashboard, I want to move the source of the data to our Azure cloud hosting.  As it's client information, this needs t...
Need Help
Eric_Zhang's avatar
Eric_Zhang
Microsoft Employee
10 years ago

My attempts so far have lead to nothing:

Using Blob storage returns blob information, rather than data from the CSV.

Using File Storage doesn't seem to have a connector in Power BI

 

Anonymous
The Azure blob storage can meet all your requirement in my test.
Regarding the returned blob information, you can click edit query and then extend the content.


And based on my test, after publishing it to Power BI service, dataset refresh works well.



If you have any question, feel free to let me know.

  • 2win2mac's avatar
    2win2mac
    Frequent Visitor
    8 years ago

    Hi,

     

    Thanks for the info, this worked fine.

     

    However, I have run to a new problem with the refresh: if the csv files in the Azure blob storage change (number of files and/or their names), PBI desktop is unable to refresh the data. 

     

    Can you please advise what to do? The whole point of using blob storage is to be able to change the csv files inside it at will (as long as their data model stays stable).

     

    Thanks for your help!