Forum Discussion

Edjz's avatar
Edjz
Frequent Visitor
3 years ago

Refreshing data from graph error in service: Failed to update data source credentia

Hi, I have a report in Power BI desktop that uses Graph API as a data source through an Odata feed, specifically it is accessing the schedule table of a Shifts for Teams schedule. The report refreshe...
Need Help
Tips and Tricks
GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
3 years ago

Hi Edjz 

 

The only way I would get this working is to use PowerShell to get the data I need.

 

My method would be to use an Azure Runbook, install the required PowerShell modules then run the PowerShell script.


I would take the output of the PowerShell script and store this in Azure Blob Storage. 

I would then read the files in Azure Blob storage into Power BI.

Edjz's avatar
Edjz
Frequent Visitor
3 years ago

Hmmm.... Well I know what power shell is, so guess I'm a 3rd of the way there right??? I though I was just very close using power automate to run a cmdlet to upload from my PC, but it can only create new, not update and existing, so will try your solution if nothing simpler comes up. Also, I expect I need to upgrade my azure subscription to a P ski? Seems crazy for getting a ms online database to talk to a ms online database, should be out the box! Anyway, thank you very much for your insight. Any others greatly appreciated.

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

    Hi Edjz 

     

    Yeah I had a look and I could not find any other way to get the data easily.

     

    No you do not need a P SKU to do this you can use your existing licenses.