CODEWITHSUNDEEP
azuredashboardpowerpivot
Carlos Martins
Carlos Martins

Reputation: 1

Dashboard from Azure SQL Database

I have a SQL Database on Azure and I want to share some information with two friends. And so I've created 3 VIEWS with that info.

The idea is to develop an easy solution to share a dashboard.

I was thinking to:

  1. Make a powerpivot with that 3 VIEWs
  2. Host the powerpivot on azure (trying to schedule the refresh)
  3. Develop a .xlxs with a connection string pointing to my powerpivot on azure

But the problem is.. I think that is not possible to host my powerpivot on azure and be able to schedule the refresh.

Any sugestions?

Upvotes: 0

Views: 892

Answers (1)

nicolò grando
nicolò grando

Reputation: 407

Use powerBI! it's a complete suite of microsoft created for this problem.

the site is this : https://powerbi.microsoft.com/

You can subscribe, publish your excel and schedule refresh, you can found a tutorial to this site:

https://powerbi.microsoft.com/it-IT/documentation/powerbi-refresh-excel-file-onedrive/

Upvotes: 1

Related Questions