Forum Discussion
Solved
Creating a universal dataset for my team.
My team is just in the beginning phases of using Power BI for data modeling within the department. I have been working through the process of creating a dataset which pulls in data from our instituti...
You should instead make a dataflow and connect to THAT with Power BI Desktop.
--Nate
Hi Spencer_Bye ,
Did the above replies help you? If the problem has been resolved, accept them.
For your question, if you want to connect to a data source using import mode, it's best to find a way to connect directly to the SQL database.
Tutorial: Connect to on-premises data in SQL Server - Power BI | Microsoft Learn
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.