Refresh problem from sharepoint online to ssas tabular model

[nikode]

Hello all,

I have a task, I want to create report in to PowerBI services from SharePoint online list.
I have imported sharepoint online list through "odata feed" connector to ssdt (2017), where I created several measures and deploy this tabular model to SSAS (2017), then I connect this model from PowerBI services.
I have problem with model refresh. When I input apropriate credentials, the model is refreshed during 1 hour and after that job is stopped, because credentials problem.

Please see screenshots.

screenshot after entering credentials, during 1 hour "refresh job" is working

screenshot after 1 hour, the job is stopped with error. The credentials is flies off

Curious is that, in the ssdt, table process (Model -> Process -> Process Table) is refreshed with out problem any time.

[v-yulgu-msft]

Hi @nikode ,

Since the data model is hosted on on-premise SSAS, when trying to refresh data on Power BI Service side, you need to configure data gateway.

By the way, why not directly connect to SharePoint online list in Power BI desktop, then, publish the .pbix file to Service.

Regards,

Yuliana Gu

[nikode]

@v-yulgu-msft  Thank you for replay.

I have already configured data gateway, through which I connect PowerBI service and on-premise SSAS.

I have tried second way 

Spoiler

By the way, why not directly connect to SharePoint online list in Power BI desktop, then, publish the .pbix file to Service.

but if there is something chaged in online list, this change will not appear in PowerBI Service.

[nikode]

for second way, I changed data source credentials to odata, and refresh is working thank to @v-yulgu-msft