cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Community Support
Community Support

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

@aminakov ,

 

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

 

Regards,

Jimmy Tao

Highlighted
Frequent Visitor

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

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.

Highlighted
Frequent Visitor

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

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.

Highlighted
Frequent Visitor

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

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

Helpful resources

Announcements
Ignite

Microsoft Ignite

This will be a conference that you do not want to miss!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Don't miss the Power BI Dev Camp this week!

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Kudoed Authors