Forum Discussion
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...
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 . At this point in the Process your query needs to be SQL. It is in M which is used a little later in the process.
Try the following and replace yourtablename wiht the name of the table that you want to retrieve. Once you have that working, you can go from there to get exactly the data that you want.
SELECT TOP 100 *
FROM yourtablemame;