Forum Discussion

RickW's avatar
RickW
New Member
10 years ago

Azure Blob Storage

I am trying to find a way to store an excel file on Azure Blob Storage and keep it in sync with the PowerBI service.  I have the desktop version and some dashboards online.  When I try to setup the B...
Need Help
RickW's avatar
RickW
New Member
10 years ago

Ok, so I was able to get the generic web source to refresh with anonymous access.  It may be a bug.  I tried to change it to other auth methods and then changed it back to anonymous and it decided it was ok with that.  I would still be interested in knowing what is working for others when it comes to hosting an excel file online for refresh by the PowerBI service.  I would think the Azure blob storage should work using that functionality instead of the generic web source.

 

Thanks,

 

Rick

 

tomv's avatar
tomv
New Member
10 years ago

Hi Rick,   I've also found that Power BI won't list my container items, within the "get data" interface. I did find however that I could load the entire container (or even the next level up - what it calls the account name) as a data source. I was then able to see my individual blobs as a binary data source in the tabular view. Editing the query then allowed expanding this bringing the file content into view.