cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ayup Helper I
Helper I

Re: Formula.Firewall: Query references other queries or steps

Hi Mozasf

 

Can you confirm if you managed to solve the issue re refreshing JIRA data via the Power BI service?

 

I have an identical situation using JIRA data - i.e. loads OK via PBI Desktop but not PBI Service - and am struggling to find a solution.

 

Any help appreciated.

 

 

Thanks

Anonymous
Not applicable

Re: Formula.Firewall: Query references other queries or steps

Hi @ayup,

For the moment I haven't found a solution.

I refer you to another post where we are looking for an answer:
https://community.powerbi.com/t5/Service/Unable-to-combine-data-accessing-data-sources-that-have-pri...

sivapratap Helper II
Helper II

Re: Formula.Firewall: Query references other queries or steps

What is the error that is getting thrown when the refresh fails in service? Also, can you mention the duration once the refresh triggered and failed? you might get useful lnformation if you can do a fiddler trace once you start the refresh and share the details with Microsoft through a  support ticket.

 

FYI , If you are pro user, you can raise a support ticket .

 

 

sivaaprataap
ayup Helper I
Helper I

Re: Formula.Firewall: Query references other queries or steps

Hi @sivapratap

 

Thanks for replying.  The error I'm getting is "Message[Unable to combine data] Section1/Issue List/AutoRemovedColumns1 is accessing data sources that have privacy levels which cannot be used together. Please rebuild this data combination."

 

The scenario I have is the same as @Anonymous where I make a first call to the JIRA API to retrieve the issue records I'm interested in; then loop through these records to make a second call to query additional info associated with each issue.  In the second call, the URL path is dynamic as it includes the id of the record being queried.

 

Based on the commentary provided by @mithrandir in the thread referenced by @Anonymous, it sounds like there's nothing that can be done to work around this other than manually refreshing data in PBI Desktop,

tuken
Frequent Visitor

Re: Formula.Firewall: Query references other queries or steps

Hi @ayup @Anonymous,

 

Finally have you found a solution?

 

I have the same issue with JIRA.

 

Thnaks.

ayup Helper I
Helper I

Re: Formula.Firewall: Query references other queries or steps

Hi @tuken

 

I'm afraid not...we're still having to refresh JIRA data manually in PBI Desktop and republish to PBI Service

 

Ayup

tuken
Frequent Visitor

Re: Formula.Firewall: Query references other queries or steps

OK, thank you for your answer. 

 

In case I find a solution or workaround, I'll let you know.

Anonymous
Not applicable

Re: Formula.Firewall: Query references other queries or steps

Hi @tuken!

 

I'm still thinking about the problem but I'm afraid there's no solution at the moment.

 

If you find any solution, please share it with us.

Thanks!

tuken
Frequent Visitor

Re: Formula.Firewall: Query references other queries or steps

I'll do it.

 

Regards.

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors