Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
hello,
I am experiencing lots of issues with refreshing the data sources recently. Meaning since July.
No changes were done to the data sources but am now getting more frequent "fail to refresh" warnings and prompting me for a Power BI Pro purchase. Something to do with Personal Gateway and On-Premises data. I have not changed it in any way. All of my data sources as hosted on a One Drive for Business location / Sharepoint list and were working fine until recently.
Has anything changed in the Power BI subscription service terms and conditions that might be causing this?
In addition, today I got an error while trying to Publish from PBI Desktop, below.
Thank you for your feedback.
J
Also Refresh History is showing the following information
Processing error: | Your data gateway (Power BI – personal) is offline or could not be reached. Ensure the gateway computer is on and you are logged on to it during the scheduled refresh period. |
Cluster URI: | WABI-NORTH-EUROPE-redirect.analysis.windows.net |
Activity ID: | af359c0f-c41a-47ba-a8a6-c5cd0a7a3a77 |
Request ID: | 00ab5f4f-a7a6-49cc-a5dc-a9b4f9a2be6e |
Time: | 2016-09-06 10:15:17Z |
Solved! Go to Solution.
Hello @v-haibl-msft
New light into the topic.
One of the published PBIX files is actually schedule refreshing fine and is using the same Datasource types.
Dashboard Software allows for Connect Direct. No Gateway.
Dashboard Web 1.1 refresh fails.
Are there any queries to the PBIX that may force the need for a Gateway to be installed?
Thank you.
Please check your gateway status as ankitpatira said. BTW, is your data stored in North Central US? We can check it in About Power BI in the upper right corner as below. If yes, I noticed that there was a message in the support site which said issue was found in the North Central US region. Actually you can find similar issue in this thread and the Power BI team is working on it.
Best Regards,
Herbert
Thank you for your reply.
My data is stored in North Europe (Ireland).
I never needed to install the Gateway before and the schedule refresh was working fine. Set for daily refresh. How can I revert to the previous condition?
Best regards,
Joaquim
@v-haibl-msft and @ankitpatira
I found that an older published report still displays the previous schedule refresh settings. It allows for a Direct Connection, as below.
The other reports show different options.
Why would it be different if all Data Sources are sitting in the same OD4B location?
I want it to still allow a Direct Connection, if it makes any sense.
Thank you for your help.
Joaquim
Did you get data from OD4B as below? In that case, a personal gateway is not needed. Would you mind deleting the dataset and getting data from OD4B again to see if it works?
Best Regards,
Herbert
I did not link to OD4B like that.
I started assembling the Data Sources and Reports in March 2016. I never worked with data analytics before and it has been an interesting learning curve since then.
I started off with the Data Sources as local files, but then moved them to an OD4B account when I realised they could be refreshed automatically. For this I have edited the path as suggested on this post.
-------
To set it up, you need to go into Edit Query -> Advanced Editor, and change the Source line from pointing to your local C: drive to use the Sharepoint/Onedrive URL -- here's an example from one of my dashboards, which hits n XLSX data file that gets saved to my Onedrive for Business folder every night:
Source = Excel.Workbook(Web.Contents("https://domain-my.sharepoint.com/personal/<my O365 ID>/Documents/path/path/path/dates.xlsx"), null, true),
This works great for CSV and other flat files as well.
Then on app.powerbi.com, go into the Dataset properties and you'll be able to set it to auto refresh and select the rough time to run (I use 6A-12P).
-------
Things worked fine and I was able to schedule refresh the data....until mid July, where it prompted for a Gateway.
Now, I have tried to add a Dataset the way you suggested and it seems to be going on the right direction. My question is that I do not know how to create Reports with more than one Dataset, the same way I do in PBI Desktop?
Many thanks for your help.
J
In Power BI Service, we can only create a report with one dataset.
Best Regards,
Herbert
So, just to be sure that I am clear about my options, for the scenario of needing PBI Desktop to query/model data souces, there is no way around it aside installing a Gateway to schedule refresh data. Even though they are hosted on a OD4B location.
It this it?
Regards,
Joaquim
Yes, even though your data are hosted on a OD4B location, but you actually publish to Service from the local .pbix file .
Best Regards,
Herbert
Hello @v-haibl-msft
New light into the topic.
One of the published PBIX files is actually schedule refreshing fine and is using the same Datasource types.
Dashboard Software allows for Connect Direct. No Gateway.
Dashboard Web 1.1 refresh fails.
Are there any queries to the PBIX that may force the need for a Gateway to be installed?
Thank you.
The connect directly option will appear when the source excel file is located in the office 365 environment (stored in an O365 Modern Group document library). If it doesn’t have this option, then it states that there are other data sources which require gateway. You can also have a look at this thread which talks about the connect directly option.
Best Regards,
Herbert
@jagostinhoCT From the error message itself if sounds like your gateway is not accessible at the time of refresh. Have you ensured it is visible so check network / firewall etc. Nothing that I'm aware of has changed in Power BI subscription. We didn't experienced any issue after August update for our gateway refresh or publish from power bi desktop. Publishing error seems weird and you should contact MS support for that if it happens all the time.
Hi @ankitpatira
After a little research yesterday, I found that the Gateway requirement is a new feature. I did not need a Gateway setup previously in order to schedule refresh my data. Not even when going for the "Refresh Now".
May I stress that I did not do changes to my Data Sources. This behaviour just started to happen around mid July/August.
And before I could get access to the Schedule Refresh settings (the one with the Yes/No slider). Now they are greyed out and it seems that they can only be unlocked after installing a gateway.
Here is an older article describing the process and it does not mention Gateway setup.
One of the things I am unable to understand is, if my Data Sources are hosted on One Drive for Business (using the same PBI credentials) why would I need a Gateway? Why would it not just refresh the data straight from the OD4B?
Thank you for your time and feedback.
J