Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

thierryh

Composite Model V2 | OLE DB or ODBC error: A loop was found in the chain of Analysis Services data s

Submitted by Employee on ‎02-21-2022 08:37 AM

For an internal reporting, I decided to test the Composite Model V2 (DirectQuery for Power BI datasets and Azure Analysis Services) and on the desktop everything is working fine, however, when I publish to the service, some visuals are returning this error:

 

Couldn't load the data for this visual

Couldn't retrieve the data for this visual. Please try again later.

Please try again later or contact support. If you contact support, please provide these details.

Hide details

  • Activity ID7
  • Request ID
  • Correlation ID
  • TimeMon Feb 21 2022 12:38:24 GMT+0100 (Central European Standard Time)
  • Service version 13.0.17764.45
  • Client version 2202.3.10084-train
  • Cluster URI

I have tested this on Pro, PPU and Embedded with same results.

I’ve catched the error with a Profiler Trace and getting:

 

OLE DB or ODBC error: A loop was found in the chain of Analysis Services data sources.

 

Technical Details:

RootActivityId: e75b104c-

Date (UTC): 2/21/2022 11:33:18 AM. OLE DB or ODBC error: A loop was found in the chain of Analysis Services data sources.

 

Technical Details:

RootActivityId: b89f06fa

Date (UTC): 2/21/2022 11:33:18 AM.

Status: Investigating

Hi,

What kind of data source do you use to connect to in the Power BI desktop?

Have you turned on the option in the desktop setting?

vrobertqmsft_0-1645498248781.png

Would you like to post some screenshots of the Power BI report with this issue without the sensitive data if it’s possible and we can help you to check if it’s an existing issue in the Power BI?

 

I also suggest you to make sure you have updated to the latest version of the Power BI desktop.

 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

See more ideas labeled with:
3 Comments (3 New)
Comments
v-robertq-msft
Community Support
Community Support
‎02-21-2022 06:51 PM
Status changed to: Investigating

Hi,

What kind of data source do you use to connect to in the Power BI desktop?

Have you turned on the option in the desktop setting?

vrobertqmsft_0-1645498248781.png

Would you like to post some screenshots of the Power BI report with this issue without the sensitive data if it’s possible and we can help you to check if it’s an existing issue in the Power BI?

 

I also suggest you to make sure you have updated to the latest version of the Power BI desktop.

 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

thierryh
Employee
Employee
‎02-22-2022 01:04 AM

Hello Robert,

 

The Datasources :

  • AAS on DirectQuery
  • SharePoint List on Import mode

The setting is on on the desktop:

 

thierryh_0-1645520637262.png

 

 

Screenshot from the desktop OK:

thierryh_1-1645520637281.png

 

 

Screenshot from the service KO:

thierryh_2-1645520637295.png

 

Desktop version up to date from MS Store : Version: 2.102.683.0 64-bit (February 2022)

 

Best regards,

Thierry

v-robertq-msft
Community Support
Community Support
‎02-22-2022 06:57 PM

Hi,

According to my research, I also suggest you to check if you have met any limitations of this feature, which is still in the preview stage:

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-datasets-azure-analysis-s...

 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

Idea Statuses