Forum Discussion

Ragemoomin's avatar
Ragemoomin
New Member
2 years ago

Change data source to one on service

Hi,

 

I have a Power BI dashboard I created in desktop using an Excel file however I want to be able to schedule a refresh of the data. I have now created a data source by uploading the Excel table to Power BI service and putting in a workspace so I have a semantic model I can hopefully connect to that will refresh. However I can't work out how to change my existing data source to this new one. I know how to change data source but I can't seem to browse to My workspace to pick up the new one. Any suggestions please?

Need Help

3 Replies

  • aj1973's avatar
    aj1973
    Icon for Community Champion rankCommunity Champion
    2 years ago

    Hi Ragemoomin 

    Doesn't work that way. The Excel file should be uploaded to OneDrive for Business or Sharepoint(Teams), this option if you don't want to use a Power BI Gateway. The other option is you keep the file where it is now in your machine and install a Personal Gateway to make things automatically refreshable in the service.

    I would pick the first option 😉

     

    • Ragemoomin's avatar
      Ragemoomin
      New Member
      2 years ago

      Thank you. When I originally created the dashboard it was using an Excel file on SharePoint but the schedule refresh options are greyed out

      • aj1973's avatar
        aj1973
        Icon for Community Champion rankCommunity Champion
        2 years ago

        Can you show me some more details, M code, service....