Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Curious is that, in the ssdt, table process (Model -> Process -> Process Table) is refreshed with out problem any time.
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
@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
but if there is something chaged in online list, this change will not appear in PowerBI Service.
for second way, I changed data source credentials to odata, and refresh is working thank to @v-yulgu-msft