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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
RAHUL224
New Member

Not able to create data source for Analysis services in PowerBI services

I fetch data from Analysis services into PowerBI (Import mode). I am able to fetch the data but when I publish this report in to powerBI services and i am creating new data source in powerBI services using the same server link i am not able to create data source. It give me bellow error, Not able to understand what to do plz guide me

RAHUL224_0-1679557588389.png

 

7 REPLIES 7
RahulkumarB123
Frequent Visitor

hi,
Thanks for reply.

Can you please tell me what kind of permission cube admin need to provide.

As for data source creation i am using admin credentials. Also i am able to see only windows authentication option.

 

RahulkumarB123_2-1680747019527.png

 

 

RahulkumarB123_1-1680746861825.png

 

they need to make you cube admin, or they need to enter their Windows credentials at that step.

lbendlin
Super User
Super User

I fetch data from Analysis services into PowerBI (Import mode)

Ouw, that hurts!

 

On the gateway there are a couple of prerequisites that do not exist on the Power BI desktop.

- the browser service must be accessible

- the connection user must have Discover privileges on the OLAP cube which means they have to be cube admin (!!!)

Can you please eloborate more on that

Which part?

How to solve this issue. I am new to powerBI. Where i need to check.?

You need to talk to the cube admins about that. They need to give you the required permissions.

Then you need to set up the gateway connection.

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors