cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mitch_o
Regular Visitor

Excel LTSC Connect to Power BI Dataset

Hi all,

 

I have a user that is using Excel LTSC Professional Plus 2021 and is trying to connect to a Power BI dataset from Excel. They do not have the steps listed here:

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-connect-excel-power-bi-datasets#...

 

Are there any known ways to connect to the Power BI Datasets?

Thanks,

Mitch

4 REPLIES 4
v-jayw-msft
Community Support
Community Support

Hi @mitch_o

 

Try this:

To access Office privacy settings, open any Office application, select Account, and under Account Privacy select the Manage Settings button. This will open the Account Privacy settings dialog box where you can select your privacy options.

 

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
lbendlin
Super User
Super User

I  don't know if that will work with a Pro workspace. In a premium workspace you can find the connection string in the server settings for the dataset.

lbendlin
Super User
Super User

Use the Analysis Services connector.

Hi Ibendlin,

What would the connection look like?

The workspace is a pro workspace?

Helpful resources

Announcements
May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

Power BI Dev Camp Session 22 with aka link 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!

Top Solution Authors
Top Kudoed Authors