Forum Discussion

konstantinos's avatar
konstantinos
Memorable Member
11 years ago

If you connect to Azure SQL from PBI Desktop the connection is not live ( the data are stored in PBI desktop data model) ..You need to schedule refresh..No need for Personal DMG..In order for the Azure SQL to be "live" ( refresh every 15 min & with quering ) needs to be connected through the "Get Data" Databases options..

Up to now there is no "live connection" to Azure SQL as for SSAS in PBI Desktop..

 

**edited .. for live Azure SQL you need Pro lisence 

Solutionz's avatar
Solutionz
Helper I
11 years ago

Thanks for the reply...

 

I now realise that if the dataset is in Power BI desktop then it needs to be Published to take affect. But if I create the Data Link in the cloud through "Get Data", I assume this is different....But it is not...The data cannot be refreshed nor is it refreshed automatically. So with Azure it seems right now either way nothing can be done but delete and start again? Surly this cannot be right?

 

When trying to refresh the Azure linked DB this appears...

 

"You cannot schedule refresh for this dataset because it does not contain data model connections. You cannot schedule refresh on worksheet connections or linked tables. To schedule refresh the data must be loaded into the data model."

 

Basically my steps are:

- Get Data directly from Azure SQL Database - (It gets the latest)

- Data changes but Power BI does not update

- Start Again