Forum Discussion
failed to publish/refresh
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.
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
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
Anonymous
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
Hi v-haibl-msft
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
Anonymous
In Power BI Service, we can only create a report with one dataset.
Best Regards,
Herbert
