Forum Discussion
Get DATA using temporary table from SQL
Figured it out. Thank you both for your help.
I was trying to do a 'Direct Query' vs 'Import Query'.
Hope you are safe and well... thanks again!😊
Anonymous
It seems that PowerBI cannot translate the SQL Query properly.
Instead of temp table why dont you use a CTE (in memory table) in your sql query??
Another option is to create a store procedure, add the sql query code there and then call the procedure from PowerBI. Like:
DECLARE @sqlcode varchar(1000)
SET @sqlcode= 'dbo.queryproc
EXEC (@sqlcode)
Figured it out. Thank you both for your help.
I was trying to do a 'Direct Query' vs 'Import Query'.
Hope you are safe and well... thanks again!😊
Hi Anonymous ,
Is there anything else need help about this thread? If no, could you please mark your post as Answered? It will help the others in the community find this solution easily if they face the same problem with you. Thank you.
Otherwise, you can refer the following links to get it.
Connect using advanced options
Working with SQL Server data in Power BI Desktop
Best Regards