I just modified the data source for one of my reports to connect it to the OneDrive cloud version of my source Excel file. (Initially I had set it up from a local copy of that source file by mistake.) Now it tells me the report is using Power BI Pro functions? Not sure what the issue is since I've connected to "web" sources in this way on other reports within the past week without issue.
Is there an update on this yet?
I am finding Power BI Service difficult to use as a lot of options that I would use on desktop are not available, but I cannot create the necessary reports in Power BI Desktop because once I publish it to web the data cannot be refreshed.
I am creating visuals based on salesforce reports that are held in the cloud and feel as though I have two less-than-perfect options - build perfect reports on desktop and refresh them manually; or build medocre reports on web that will refresh automatically.
I was able to establish a connection to a web page from Power BI desktop using the Get Data/Web option with the appropriate URL. Then I was able to use the tables (and their data) from the web page to create reports. Then I published the reports to the Power BI service.
Now, when I try to schedule a refresh for the dataset, I get the message “This dataset contains on-premises data sources. To schedule data refresh, try Power BI Pro for 60 days, or contact your Office 365 tenant administrator to purchase Power BI Pro.”
I’ve been reading through this thread. Is my understanding correct that acquiring web page table data for a Power BI dataset/report now requires both a Power BI Pro subscription AND a data gateway? And, prior to a few months ago, that same capability was available without the Power BI Pro subscription and didn’t require a data gateway?
I can successfully publish and schedule refresh for Excel file stores in One Drive For Business and also can schedule the refresh for SQL Server on-prem queries.... BUT - not if both (the One Drive for Business and SQL query) are in the same model.
PowerBI Destop works perfectly, but when I publish to service - I have the Gateway error.
But I do have a SQL Server Gateway and it works. I also don't need a gateway for OneDrive for Business Excel file connection
So why they are not working together and hoe to fix this?
Sorry for the long delay to respond I missed it previously.
The ability to refresh an on-prem data source with OneDrive (using oAuth) is coming really soon. Today you can use the personal gateway to get unblocked, or seperate the 2 data sources.
Let me know if that works!
@dimazaid Hi Dimah,
OAuth2 works through personal gateway, but the dependency on a personal computer is not reliable.
Any ETA on supporting OAuth2 in Enterprise Gateway?