On Premises Gateway and Dynamic Data Source (Google Drive)

[vascorey]

Dear all,

I am running Power Query to calculate daily gains and stock price historical data on my portfolio. There are two main sources for data:

1) Transactions (units bought and sold), which I fetch from Google Drive - GoogleSheets.Contents("https://docs.google.com/ ....")

2) Stock data and metadata, which I fetch from Yahoo Finance - Json.Document(Web.Contents("https://query1.finance.yahoo.com/ ..."). I have created a function to pull data from yahoo that is called for every ticker I get from Google Sheets

I am trying to setup auto-refresh on Power BI Web, but I've come across the dreaded "This dataset includes a dynamic data source. Since dynamic data sources aren't refreshed in the Power BI service, this dataset won't be refreshed. Learn more: https://aka.ms/dynamic-data-sources ."

Also, when I go to the "Semanting models" page, I see "Data source for Query1" is the culprit, but Query1 is not a query in my model.

I have investigated further and installed the On Premises Data Gateway which, I assumed, would make Power BI Web reach out to Power BI Desktop and pull relevant data on desktop and forward it to web, but, alas, this has not solved my issue.

Do you have any recommendations to solve what I am doing wrong?

Best,

Vasco

[lbendlin]

nstalled the On Premises Data Gateway which, I assumed, would make Power BI Web reach out to Power BI Desktop and pull relevant data on desktop and forward it to web

No, that's not what a gateway does.  Think of the gateway as a Power BI desktop without user interface.

Read about RelativePath and Query parameters for Web.Contents.