Forum Discussion
Solved
Refreshing PowerBi Online using Personal Gateway Issue
All, This is a very odd issue and I assume that I am doing something super simple wrong. I have both Desktop PowerBi and PowerBi online (service). I have a dataset that is comprised of two XSLX ex...
Yes for whatever reason, when I recreated it again and left the excel files as stand alones and just had it set to auto refresh on open. I then used a batch file to open them every hour while using the data gateway personal and it worked. Just had to delete and recreate it all.
In some ways another solution would be that if there was anyway to make my main .pbix file not inherit the data source from the .xlsx files and instead just BE the .xlsx files that would solve this 100%.
If there is a way to change that from jira on prem (local web) to be XXXXX.XLSX file I could then use the data gateway personal and it would allow it (per my tests).
Thanks again.