Forum Discussion

aspardo's avatar
aspardo
Regular Visitor
10 years ago

New to BI. Writing SQL queries to parse data. I am obviously missing something.

Started using Power BI on the recommendation of a friend. It looks well made and powerful, so I hope to stick with it.   I am pretty decent with SQL and can write some lengthy queries. My goal is t...
Need Help
calerof's avatar
calerof
Icon for Impactful Individual rankImpactful Individual
7 years ago

Hi anithat  and supporting team , ElizabethTachji ,

 

I performed your procedure, only modifying the query to the table I need, as follows:

 

But I'm still getting this error:

 

Could you please help?

 

Best regards,

 

Fernando

 

 

calerof's avatar
calerof
Icon for Impactful Individual rankImpactful Individual
7 years ago

The problem stated here persists for me, but I managed to solve my issue of not being able to upload on table that didn't appear as follows:

  1. The database has more than 10,000 tables
  2. In SSMS all the tables are visible
  3. I deducted after a very long week of insomnia that the problem was the limit of number of tables read with Get Data, SQL Server
  4. So I tried the procedure explained above, with no results
  5. Then I tried it with the blank query option, and voila

I think it's still not resolved using Advanced Options, so I'll leave it open for your comments.

 

Best regards,

 

Fernando