We've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now
Hello Experts!
I am currently facing a problem with Power BI while trying to apply my queries which pending changes that have not been applied yet.
When trying to load all tables, I get a message that "the name of a column is already used in a column in another table and I should choose another name". How can I fix this problem or rather why does this problem occur when importing data from Spark to BI?
The same data from another source does not cause any problem. However, I need it through spark.
I have additional information which could help to understand the import problem to PowerBI. After Spark, the tables are loaded without relationships to each other. And I suspect that this could be the reason. But I don't see a setting on the PowerBI side that allows me to ignore these relationships between the tables.
just possible thoughts. still don't understand the error message that the name already exists in another table.
I'm sorry maybe i asked the question in the wrong direction.
The data is uploaded from an Azure Database to PowerBI and i think the problem lies here and not so much with spark.
What Data Connection type are you using? I had a similar sounding issue when trying to connect to a 4D database with an ODBC connection. The solution was to use ODBC > Advanced options and specify the columns I wanted to bring through (something to do with a key that was present on every table of the DB or something beyond my understanding) rather than allowing it to naturally select all columns.
Never used Spark but wonder if its a similar sort of issue? Apologies if this sends you in the wrong direction though!
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 6 | |
| 4 | |
| 3 | |
| 2 | |
| 2 |
| User | Count |
|---|---|
| 11 | |
| 10 | |
| 7 | |
| 7 | |
| 6 |