Forum Discussion
Power Query - Problem refreshing a report with dynamic data source
Hey v-saisrao-msft & lbendlin, thank you for all your help. I did ignore the privacy level on the current file, refresh process works normally on Power BI Desktop, but as soon as I upload to Service and try to refresh, I get the same error message on Power BI Service.
Happy for you guys to close this thread. It looks like this one just simply can't be resolved with the current restrictions in my organization.
I'll try exploring more on Power Automation to download the file for me.
Hello v-saisrao-msft,
I did go through the information provided, and I did follow this one before to deal with the dynamic queries issue that I had. The problem now is I'm having issues inlining my function based on lbendlin feedback.
from the main query
= Table.AddColumn(#"Removed Columns1", "CallingFunction", (callFunctionInline) => FunctionInvoker([Original_URL_Link.2.2]))
Error message for the added invoked custom function
Expression.Error: There is an unknown identifier. Did you use the [field] shorthand for a _[field] outside of an 'each' expression?
My function is shown below
= (Parameter1 as text) => let
Source = Csv.Document(Web.Contents("STATIC_URL",[RelativePath = Parameter1]),[Delimiter=",", Columns=10, Encoding=1252, QuoteStyle=QuoteStyle.None]),
#"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true])
in
#"Promoted Headers"
= Table.AddColumn(#"Removed Columns1", "CallingFunction", each Table.PromoteHeaders(Csv.Document(Web.Contents("STATIC_URL",[RelativePath = [Parameter1]]),[Delimiter=",",Encoding=65001, QuoteStyle=QuoteStyle.Csv]), [PromoteAllScalars=true]))
One option (not recommended) is to "ignore privacy levels for this file"
Hi omargazzar,
I wanted to check if you had the opportunity to review the information provided by lbendlin . Please feel free to contact us if you have any further questions. If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.Hi omargazzar,
We haven’t heard back from you regarding your issue. If it has been resolved, please mark the helpful response as the solution and give a ‘Kudos’ to assist others. If you still need support, let us know.
Thank you.
Hey v-saisrao-msft & lbendlin, thank you for all your help. I did ignore the privacy level on the current file, refresh process works normally on Power BI Desktop, but as soon as I upload to Service and try to refresh, I get the same error message on Power BI Service.
Happy for you guys to close this thread. It looks like this one just simply can't be resolved with the current restrictions in my organization.
I'll try exploring more on Power Automation to download the file for me.
Hi omargazzar,
Thanks for the update! It sounds like you've done a thorough job troubleshooting within the limits of your environment. Organizational restrictions can definitely make certain solutions more challenging.
Exploring Power Automate sounds like a good direction hopefully that gives you the flexibility you need.
Thank you.
Thanks lbendlin, followed that one, managed to refresh it on Power BI desktop. Published it to Service, and got the following error message while refreshing via service. Looping back to the partitioning issue that you have shared with me before.
[Unable to combine data] Section1/Main_Query/Expanded CallingFunction is accessing data sources that have privacy levels which cannot be used together. Please rebuild this data combination.. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action. Table: Main_Query.