Hi.
I'm using sql server and on-premise gate way. I want to connect the sql server table datas and power bi.
But FLOW doesn't recognize table. My table also has prime key.
Below screenshot is my database. I want to connect dbo.gapTest Table. But it doesn't recognized. TT
Should I use Azure SQL SERVER?
I need your help.
Thank you.
Hi @Anonymous,
Did you have a test that selects the master as my Database, then creates a table named "Persons", and the table Persons and the system table from master show up at the same time.
CREATE TABLE Persons ( PersonID int, LastName varchar(255), FirstName varchar(255), Address varchar(255), City varchar(255) );
Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Share
Report
All responses (
Answers (
231
