Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Assistance to connect 2 sources

Dear All

 

I am new to power bi, could someone advice me to build a small report with fixed values in a spreadsheet and values from the AD ? 

 

Thanks very much 🙂

Kate

 

2 ACCEPTED SOLUTIONS
amikm
Helper V
Helper V

Hi @Anonymous 
you can copy the data from the spreadsheet and paste it , or you can use Enter Data option available in Power BI.
You can also use Get Data and point to that excel file and during navigation, Select the required sheet.

 

You can use Get Data option to import the data from Multiple sources ( supported by Power BI)

View solution in original post

amitchandak
Super User
Super User

3 REPLIES 3
Anonymous
Not applicable

Dear All,

I tried to connect to Azure AD from power bi desktop. But i realized that there is no connector. Could you confirm this ? I surprised?

amitchandak
Super User
Super User

@Anonymous , AD -> Active directory ?

What data you need .

refer -https://golive.anywhere365.io/platform_elements/powerbi_integration/additionalconfiguration/power_bi_integration_connect_active_directory.html

 

and connect to excel in import mode

 

amikm
Helper V
Helper V

Hi @Anonymous 
you can copy the data from the spreadsheet and paste it , or you can use Enter Data option available in Power BI.
You can also use Get Data and point to that excel file and during navigation, Select the required sheet.

 

You can use Get Data option to import the data from Multiple sources ( supported by Power BI)

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.