Forum Discussion
loading data on power bi service using sql server
I want to load the data on power bi service using sql server and want to create report on service itself. Please advice
You can create a pbix using the desktop that have all of your sql data in it. Publish it to the service and make sure it refreshes (if you need it to). Then from the service you can create a report using that dataset.
Also, are you actually using ODBC instead of the native SQL Server connector?