Skip to main content
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.

Frequent Visitor

calls to #sections and #shared doesn't work for model upload

While perfectly working for PQ itself, I cannot use them if any results go to Model. Why is that? It seems rediculous...

Community Support
Community Support

@aminakov ,


Could you please share spme sample data and the M code?



Jimmy Tao

Pls create 2 queries, first one:

= #sections[Section1][ttt]

Second query name ttt and the body of query is any value, e.g. 1.

Ensure that all is ok while you in PQ UI.

Make the first query uploadable to model.

While refreshing the model, you'll get Ole error.

Just checked - in Excel all works fine, regardless of target - model or / and table. You defenitely have a bug in the current release of PBID, guys :-). In some cases PBID rases an OLe error, and in some cases just crashes silently.

Is it possible to have any sort of reaction on this post? Thank you very much in advance.

Helpful resources

Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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