Forum Discussion
Cannot import any tables from SQL Server into Power BI Dataset - M query/native source query error
Hi all, Had a good search but couldn't find a solution. I am trying to import a new table from our SQL Server into our Power BI Dataset but I get the following error message: I trie...
After a few of hours of trying different things, I created a new table by clicking on Enter Data, gave the table a Test name and entered a '1' in to a single cell of the table. After a long loading time, the table loaded. I then tried getting the table from the SQL Server again and, after a similarly long processing time, the table also loaded.
However, when I try to add another table, I still get the original error message. I tried the above again but still get the same result.