Forum Discussion

ejaya2's avatar
ejaya2
Frequent Visitor
9 years ago
Solved

Getting data from AAD as a data source

I'm struggling with getting user data from AAD linked into my dashboards.   Here's the basic run down, we have data in Google Analytics that tracks page hit data. That data alos includes our users ...
Need Help
  • ejaya2's avatar
    ejaya2
    9 years ago

    I've worked around this by just writing the AAD data to a list in the group site and have used SharePoint List as a data source. This still feels awkward, in that i have to replicate data I should have access to by virtue of the reports being stored in Power BI on Office 365.

v-caliao-msft's avatar
v-caliao-msft
Microsoft Employee
9 years ago

Hi ejaya2,

 

Based on your description, you publish your AAD information to a CSV file. CSV files are simple text files, so connections to external data sources and reports are not supported. You cannot schedule refresh on a dataset created from a comma delimited file.

However, when the file is on OneDrive, or SharePoint Online, Power BI will synchronize any changes to the file with the dataset automatically about every hour.

 

So in your scenario, you and upload you CSV file to OneDrive or SharePointe online, then data is up to date.

 

Regards,

Charlie Liao

 

 

  • ejaya2's avatar
    ejaya2
    Frequent Visitor
    9 years ago

    Yes, the CSV data is up to date in that case, as it is stored in the same Office group the reports are published to, but the other data source from Google Analytics no longer updates. 

     

    Is there a user voice suggestion for making AAD a data source?

  • ejaya2's avatar
    ejaya2
    Frequent Visitor
    9 years ago

    I've worked around this by just writing the AAD data to a list in the group site and have used SharePoint List as a data source. This still feels awkward, in that i have to replicate data I should have access to by virtue of the reports being stored in Power BI on Office 365.