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

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

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

March2025 Carousel

Fabric Community Update - March 2025

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