I was advised to start a new thread as our issue could be slightly different to the UK Outage outlined in the below. I posted the issue on the below thread as well.
We cannot import a very simple spreadsheet into CDS. We have tried various methods and data sources but we continue to get errors at random points during the power query process. In order to eliminate any outside influences we stripped it back to a very simple test spreadsheet and we continue to get the error (Attached)
The error can happen at any point during the process however it happens mostly at the last point when the data loads and it stops.
Hope someone can help we have just upgraded to plan 2 to get CDS however our migration project is on hold due to the error. We cannot get any data in at all.
I have a better idea to import spreadsheets! Design your entity, then open Entity in Excel, that will initiate and open Excel CDS add in, sign in to that add in, refersh, then copy your data from your sheet to the entity opened in excel, hit publish, then you are done.
I'm afraid this did not work, I dont think we are allowed the add in (See attached)
Whilts this workaround would be reasonable I feel we should be able to utilise the benefits of Power Query given our subscription plan
Thank you for your answer though, I was hoping it would move us forwards on a temp basis!
I too am having this issue, based out of Canada.
Cannot get a simple 4-column spreadsheet to import (All data is numerical, small numbers well within limits).
Once I get to the import process on 'Choose refresh interval', it stops with "An Unknown Error has occured".
Conversely, when I attempt to use the Excel add-in, it hangs on "Loading MetaData for several minutes until it times out and throws an error.
At this point I have no effective way of importing data into the system.
Any updates on what is going on?
Find your favorite faces from the community presenting at the Power Platform Community Conference!
See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.
ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.
Features releasing from October 2020 through March 2021