Forum Discussion

omargazzar's avatar
omargazzar
Frequent Visitor
1 year ago
Solved

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's avatar
    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's avatar
omargazzar
Frequent Visitor
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.

v-saisrao-msft's avatar
v-saisrao-msft
Community Support
1 year ago

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.