Forum Discussion
giovissimo
6 years agoHelper I
Adding spreadsheet data to the original dataset
Hi,
I have a report based on an Azure database, and I need to add an Excel .xlsx spreadsheet in order to match data and add a new columns, but when I try to import the file, I get the following error message:
"Name validation is not supported in readonly schemas".
What does it actually mean ?
Giovanni
1 Reply
- edhansCommunity Champion
How are you addeing the spreadsheet? It should be either by:
- Add Excel file (local drive)
- Add Local Folder
- Add SharePoint folder
- Datalake connector if the file is there.
And the Excel file has to be closed. If it is open on your PC, it can block the connection.
Please walk us through the actual steps you are taking to get that error.
How to get good help fast. Help us help you.
How to Get Your Question Answered Quickly
How to provide sample data in the Power BI Forum