Forum Discussion

jmdh's avatar
jmdh
Icon for Advocate IV rankAdvocate IV
9 years ago

Bug in a Query referring (indirectly) to an other Query

I have identified a Bug when Running a Query that calls a function that Accesses external data

 

I have a Pbix (Desktop) where I created functions that take their values in a table (Actions)

Actions is loaded from an Excel File with Get Data > Web

 

When I call one of these functions in a Query (also accessing an Excel file in the same area) , I have the error message:

Formula.Firewall: Query 'Test Query with Bug' (step 'Rename') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.

 

If I go to File>Options>Privacy and click on "Ignore the Privacy Levels …" the message above disappears and everything work fine.

 

But when I publish to the Service  (then edit my Data Source credentials etc.) and try a Refresh, I have funny errors, mainly :

Data source type:

 

Processing error:

We cannot convert the value "[Function]" to type Function.

Cluster URI:

WABI-NORTH-EUROPE-redirect.analysis.windows.net

Activity ID:

527bf804-a51c-4117-96b1-001d368fab6d

Request ID:

7fdf57cc-34fa-4b96-b32a-9900d76209b6

Time:

2017-04-13 16:41:51Z

 

 

After many tests to isolate the bug etc. I figured out that one way to bypass the problem is to create a table using Enter Data and paste there my Actions Table: then my functions, while still calling a Table, do not do it "externally"..

 

But this is a kludge.

 

This is  a real issue since I cannot run my Pbix as in the Desktop and I am stuck after having worked quite a long time on this project.

Need Help

4 Replies

    • jmdh's avatar
      jmdh
      Icon for Advocate IV rankAdvocate IV
      9 years ago

      Thank you.
      I use the remove privacy option on the desktop andit does the trick, however,( i do not use any Gateway on teh Service) I could not find the similar option on the Service ie the ones you mention.

      • v-ljerr-msft's avatar
        v-ljerr-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        9 years ago

        Hi jmdh,



        I use the remove privacy option on the desktop andit does the trick, however,( i do not use any Gateway on teh Service) I could not find the similar option on the Service ie the ones you mention.

        So you may need to use the gateway to refresh your dataset on Power BI service in your scenario. :smileyhappy:

         

        Regards

  • wynhopkins's avatar
    wynhopkins
    Icon for Most Valuable Professional rankMost Valuable Professional
    9 years ago

    I get the same issue, not using gateway but just refreshing from the online data sources.

     

    I have a SQL string in one query that includes a reference to another query (a list of values to filter by),  and can refresh on PBI desktop fine providing I set Ignore Privacy Settings to Always Ignore.

     

    However, when trying to refresh on the Power BI Service it gives me the "Please Rebuild this data Combination" warning.

     

    Any suggestions?