Forum Discussion
Can't schedule refresh 2 appended data base in the Query Editor
Well I delete the dataset and republish it and now it working. I started with file stored on local server, then local one drive file and finally web one drive URL. Power BI probably got crazy with all those changes.
Thanks for your time and help :-)
Mark
Anonymous ,
"I m trying to set-up schedule a PBI model but it won't work because he can't find the data base"
Could you please describe more about the above sentence? Do you have other data source in your dataset? When refreshing sharepoint online csv, gateway is not required in Power BI.
Regards,
Lydia
Anonymous
here is the error message I get when schedule refresh:
This table "Entries" mentionned in the error message is the append as new table of 2 database which are reference as source in the following credentials.
I also tried to do this append directly in DAX by using the UNION function instead of doing it in the Power Query Editor. And I get this error message:
I don't understand what this message wants to say with an existing cnnection was forcibly closed by remote host.
Any Ideas :-)?
Mark
Hi Mark,
Maybe WEB connector doesn't support appending queries? I am not sure.
If you are using OneDrive or SharePoint, you should try to use sharepoint connector instead of WEB.
Well I delete the dataset and republish it and now it working. I started with file stored on local server, then local one drive file and finally web one drive URL. Power BI probably got crazy with all those changes.
Thanks for your time and help :-)
Mark