Forum Discussion

nikode's avatar
nikode
Frequent Visitor
7 years ago

Refresh problem from sharepoint online to ssas tabular model

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 ...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

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's avatar
    nikode
    Frequent Visitor
    7 years ago

    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's avatar
      nikode
      Frequent Visitor
      7 years ago

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