Forum Discussion

tadawID's avatar
tadawID
Icon for Advocate I rankAdvocate I
8 years ago

Power BI Service live connection with Azure Analysis Services pulling data from Azure Blob Storage

Hi, I have a model on Azure Analysis Services (compatibility 1400), which utilize some files from Azure Blob Storage being connected as Data Source. I have several tables now created in VS (e...
Need Help
v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi tadawID,

You update files on the Blob Storage, you need to update it in Analysis Service, so that Power BI can get the latest data. So make sure you process the database in Azure Analysis service, then get data from AS in Power BI. For more detailed about how to process Analysis database, please get professional support from Azure Analysis services forum.

Best Regards,
Angelia

tadawID's avatar
tadawID
Icon for Advocate I rankAdvocate I
8 years ago

Hello Angelia,

many thanks for your reply! I have managed to refresh it by going into Management Studio and processing the whole database there, then going back to VS refreshing the query in Table Designer (PQ), deploying solution, refreshing Power BI Desktop visualisations, publishing to Power BI Service and updateting the app... however what I have expected was to have it happening automatically. I can't imagine doing it every time the new data is palaced into Blob Storage. I must doing somethin wrong and I guess is something about authentication, but no idea in which step. Awaiting support from AAS forum indeed. Thanks!