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! Request now

Reply
TerryHarrison
New Member

Error message when trying to connect with Analysis services Connector

Hi all, Im new to Power BI and trying to setup a simple link to a on-premise data model using the Analysis Services Connector. I get to the final screen of the setup (friendly name setup) but when i click next i get the error 'The data at the root level is invalid. Line 1, position 1.' I can access the analysis services data model from excel so not sure what is wrong. any advice appreciated. regards, Terry
1 ACCEPTED SOLUTION
TerryHarrison
New Member

Hi all, I have spoken to Microsoft on this and they have advised that this is a known issue that started about a week ago. They say they are looking into it. If you can then raise a ticket with them as the more users with the problem the quicker it will be fixed. As a workaround you could use the Enterprise gateway if needed. Terry

View solution in original post

3 REPLIES 3
TerryHarrison
New Member

Hi all, I have spoken to Microsoft on this and they have advised that this is a known issue that started about a week ago. They say they are looking into it. If you can then raise a ticket with them as the more users with the problem the quicker it will be fixed. As a workaround you could use the Enterprise gateway if needed. Terry
xfuzzheadx
Regular Visitor

I am getting the same issue also. It worked before, but I am not sure what changes, if any, is giving me the current error message.

Helge
New Member

Hi Terry,

 

I'm getting the exact same error.

Did you already find a solutions?

 

Thanks

Helge

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.