Forum Discussion

Epidot's avatar
Epidot
Regular Visitor
3 years ago
Solved

Unable to auto refresh Dataset using Power Automate due to Data Source Credentials being greyed out

Hi,   I have multiple Datasets being refreshed by Power Automate in my organisation where the data source is a Sharepoint List. With these i get the following. All works fine.   However ive...
Need Help
  • Epidot's avatar
    Epidot
    3 years ago

    Yes however i think i found the solution.  I needed to get data in power bi from 'Web' and insert the local path URL of the spreadsheet found in the file Info section.  This way Power bi points to the correct path without needing a gateway. Now i see options for credentials. I just need to configure credentials and hope it works.

     

     

AmiraBedh's avatar
AmiraBedh
Icon for Super User rankSuper User
3 years ago

This is what I understood : you want to refresh the content of a dataset on Power BI service coming from an excel file using a Power Automate flow ? Correct me if I am wrong.

Epidot's avatar
Epidot
Regular Visitor
3 years ago

Yes however i think i found the solution.  I needed to get data in power bi from 'Web' and insert the local path URL of the spreadsheet found in the file Info section.  This way Power bi points to the correct path without needing a gateway. Now i see options for credentials. I just need to configure credentials and hope it works.

 

 

  • AmiraBedh's avatar
    AmiraBedh
    Icon for Super User rankSuper User
    3 years ago

    You can add a new action in Power Automate using the Power BI connect and then select Refresh dataset (provide the workspace where the dataset is)
    If the Excel file is stored in OneDrive for Business, you'll need to authenticate your account by clicking on the "Sign in" button and following the prompts.
    Depending on your requirements you can choose "Push" or "Streaming" as the refresh type (under "Additional settings")