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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
aminakov
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...

4 REPLIES 4
v-yuta-msft
Community Support
Community Support

@aminakov ,

 

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

 

Regards,

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

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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