Power Query - Problem refreshing a report with dynamic data source

Hello all, I created a PBI report that reads the content of a text file, which has a single URL link that is simply a link to download a csv file. I then managed to create a function that would e...

Need Help

omargazzar
1 year ago
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.

omargazzar

Frequent Visitor

1 year ago

Thanks lbendlin, I followed your advise. I added the static base url, and the report refreshed on Power BI Desktop successfully.

Published the report to Power BI Service, and got a different error message when trying to refresh from service. I tried skipping the connection test, even set them with the same privacy level settings, but still no luck.

Data source error[Unable to combine data] Section1/Query_Test/Expanded functionInvoker 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: Query_Test.

The Query_Test test table contains the text file value that gets passed into the parameter Para_LinkUrl, all I've doing there is Invoke Custom function to pass the value to the function to retrieve the table contents.

---------------------------------
= (Para_LinkUrl as text) => let
Source = Csv.Document(Web.Contents("BASE_URL",[RelativePath = Para_LinkUrl]),[Delimiter=",", Columns=10, Encoding=1252, QuoteStyle=QuoteStyle.None]),
#"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true])
in
#"Promoted Headers"

---------------------------------

The full URL does not get blocked by itself when I try to refresh that table in Power BI Service (ie no firewalls blocking anything there)

Thank you for your help