Cannot enable the scheduled refresh for dataset with LiveConnect mode to Azure Analysis Services

[marcstoffels]

I have created a report connected Azure Analysis Services (LiveConnect) and published this to Power BI Services.
By default the "Scheduled refresh" is enabled and will refresh every 1 hour to update the tile (so no data).
For some reason this refresh failed (AS was Paused).

I changed the "Scheduled refresh" to off, but I cannot re-enable it again.
I only can manually refresh the dataset (On demand) and this completes successfully.
Is there a way to enable this refresh again?
I already tried to re-publish the Power BI report, so that the dataset will be refreshed, but that didn't help.

[marcstoffels]

Thank you for responding to my issue.
Indeed no gateway is being used.
The dataset has been created by publishing an empty report (having a connection to the Azure cube) to the workspace.
The connection:

I see a different settings screen, than showed in the documentation you are referring to.
Initially, the schedule was enabled and it performed the tile refresh (as long as the Azure environment was active).
The issue is that after disabling it, I cannot re-enable it again.

[m_sanket]

In the Data Source Credentials , re - provide the Autentication detail. As you can see there is small "x" there. Although there is message which says "Credentials are set". Reprovide the credentials and once the authentication is successful the scheduler will be enabled again 

[v-easonf-msft]

Hi, @marcstoffels 

Have you tried deleting the original report from the service and re-uploading a new report?

Best Regards,
Community Support Team _ Eason

[marcstoffels]

Yes indeed, I have tried this in a test environment and then the scheduled refresh works.
Till you disable the refresh, which I understand you normally would not do.
So it seems to be a bug that you cannot re-enable the setting anymore.

Deleting the report (dataset) and republishing in production environment could be done, but then I need to do this in a maintenance window and re-add manually all the people and groups again for the access to the dataset (Manage Permissions), about 40 to 50 groups. 
So I posted the issue to find out if there is another way.

Furthermore, our Azure Analysis Services server is paused in the weekend and then the automatic refresh (every hour) will fail and I thought that the refresh did not continued automatically when the server was running again. I will check that once more.

[marcstoffels]

When the Azure Analysis Services server is paused while the dataset tries to refresh, then the refresh will become in an error state:

The next refresh time will never be updated.
So when the AAS server is up again, a next refresh will not automatically be triggered.
Why this refresh has stopped working?
The only way is to refresh the dataset manually and then the refresh is running again.
Because we have the AAS server paused in the weekend, should we manually refresh each Monday morning?

So besides the original issue (after disabling the refresh you cannot re-enable again) we have a second issue, that when the refresh is enabled, it stops working after one scheduled refresh fails.

[v-easonf-msft]

Hi, @marcstoffels 

Are you sure that scheduled refresh was enabled properly before? As far as I know, the Azure Analysis Services is a kind of cloud data source, it needn't to use gateway and it is not possible to configure the schedule refresh interval for the single data source separately. 

Unlike import mode, you don't need to run a data refresh in LiveConnect mode. However, Power BI still performs tile refreshes and possibly report refreshes. A tile is a report visual pinned to a dashboard, and dashboard tile refreshes happen about every hour so that the tiles show recent results. You can change the schedule in the dataset settings or force a dashboard update manually by using the Refresh now option.

For more information, please refer to this official document.

Datasets in DirectQuery/LiveConnect mode 

Best Regards,
Community Support Team _ Eason

[marcstoffels]

Yes, initial (after the first publish) the refresh (I know its not the data, but only the tile and cube structure) is enabled:

You also see that the refresh works fine:

But it fails after the Azure Analysis Services is paused, and it not restarts the refresh after AAS is back online.
And furthermore the original issue, that when you disable the refresh you never can enable it again.
Seems to me functionality to be fixed in the Power BI Services engine.