powerbissmspowerbi-datasourcepower-bi-report-server
SSMS localdb to Power BI Gateway not connecting
I have SSMS installed on my laptop along with a localdb I created:
I am trying to create a connection with my localdb (in Power BI Service) and my local SQL db via my gateway but I keep getting an error. Here is a screenshot:
I am uploading a report from Power BI Report Builder. I am able to connect using the same credentials on Power BI Report Builder. However, when I enter the credentials on Power BI Service I get an error. Does anyone know why I am getting this error?
Solution
Try to install and use the normal SQL Server instead of LocalDB. When connecting to LocalDB, the necessary SQL Server infrastructure is automatically created and started, but I'm not sure that the Power BI Gateway supports that.
- Microsoft Power BI REST API PowerBINotAuthorizedException
- Filtering values on one visual affects filtering on second visual
- PowerBI Embed in Angular "User Owns Data" | Getting InteractionRequiredAuthError: AADSTS65001 while generating powerbi access token
- Displaying a Fixed Timeline in a Power BI Line and Clustered Column Chart with Slicers
- Integrate PowerBI report using 'embed for customer approach' to angular application which use OKTA to authenticate
- Why do fields still show in PowerBI when I have them filtered in the model?
- How to sort a line chart X-axis by a different column than displayed
- Row Comparison in PowerBI
- PowerBI Slicer showing single value from group of values
- Sorting Months in a Power BI Visual by Fiscal Year and Month
- Power BI report of excel data source
- PowerBI REST API get reports
- Reference another table when getting data from Python in Power BI
- Power BI - Powerpoint Export is Not even Showing
- Is it possible to schedule refresh in Power BI with Windows Task Schedule?
- PowerBi measure where the total is based on the legend and adjusts total for selected slicer
- DAX problem - The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value
- How do I create a bar plot histogram of a parameter in power BI
- How to show a colum total in a Power BI matrix visualisation that has implicit columns based on values?
- power Bi count the number of completed tasks per bucket
- How to display the absolute difference between two values on a dumbbell plot
- How would you get category share across time in PBI?
- How to update a column's values in Power BI M Language
- power query design for performance of queries (using SOAP connector) for Power BI/Excel
- Filtering for all records where date is less than slicer value in Power BI
- Calculate Activity based on logon-logoff times
- Power BI Metadata using Azure Data Factory (ADF)
- How to keep DAX Studio connection credentials between Power BI and Excel unchanged?
- Power BI Custom Visual - Visual Tab Not Visible in Formatting Pane
- dax measure percentage of cost