Power BI dataset and Excel on Mac OS

0 votes
I'd like to give numerous employees at my company access to data from a Data Warehouse. I need to generate a dataset with filtered data, and then allow access to those data to authorized people in Excel on Mac OS. I'm not sure if this is feasible because the "Analyze on Excel" feature isn't available for Mac users to download. Do you have any suggestions?
Feb 18, 2022 in Power BI by surbhi
• 3,820 points
2,497 views

1 answer to this question.

0 votes

Because Excel for MacOS isn't supported, connecting to Power BI datasets using Power Query isn't possible. Only csv, json, and a few additional file types are supported by Power Query for MacOS Excel. There is no Power Pivot for MacOS.

This premium option allows you to connect to OLAP sources such as SQL Server Tabular, but only for On-premise SSAS or Azure Analysis Service. If you have Power BI Premium, you might be able to connect to the dataset's xmla endpoint using the CDATA plugin.

The other method is to use PBI Desktop on Windows to develop the filtered data model, deploy it to the service, and then grant them access to the Power BI Service.

Unlock the Power of Data Visualization with Our Comprehensive Power BI Course!

answered Feb 18, 2022 by CoolCoder
• 4,420 points

Related Questions In Power BI

+1 vote
3 answers

Send dashboards and reports as automated emails on power bi

also, check - https://bihelper.tech It is a cloud service ...READ MORE

answered Oct 14, 2019 in Power BI by Andrew Caulton
20,941 views
0 votes
1 answer

How to show visualization (map) based on latitude and longitude points in power BI?

Follow the below steps: 1. Select the map ...READ MORE

answered Oct 18, 2019 in Power BI by anonymous
• 3,450 points
2,989 views
0 votes
1 answer

Group by columns on Power BI

On power BI desktop, do the following Add ...READ MORE

answered Sep 25, 2018 in Power BI by Kalgi
• 52,360 points
938 views
0 votes
1 answer

Displaying Table Schema using Power BI with Azure IoT Hub

Answering your first question, Event Hubs are ...READ MORE

answered Aug 1, 2018 in IoT (Internet of Things) by nirvana
• 3,130 points
1,212 views
+1 vote
1 answer

Unable to install connector for Power Bi and PostgreSQL

I think the problem is not at ...READ MORE

answered Aug 22, 2018 in Power BI by nirvana
• 3,130 points
2,678 views
+2 votes
2 answers

Migrate power bi collection to power bi embedded

I agree with Kalgi, this method is ...READ MORE

answered Oct 11, 2018 in Power BI by Hannah
• 18,540 points
1,426 views
+1 vote
1 answer

Connect power bi desktop to dataset and create custom reports

Yes using Power BI REST API to ...READ MORE

answered Sep 18, 2018 in Power BI by Kalgi
• 52,360 points
1,597 views
0 votes
1 answer

Embeded Power BI report with service principal using on premise SSAS as dataset

On the data gateway that is being ...READ MORE

answered Feb 23, 2022 in Power BI by CoolCoder
• 4,420 points
1,136 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP