failed to publish/refresh

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