Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Bug: Converting Data Source from PBI model from SQL Server to Live SSAS

Submitted by Anonymous on ‎05-10-2018 09:20 AM

I recently converted from a local, pbi model that got data from on-prem SQL Server to a Live connection to Azure AS. I deleted all my queries and was able to connect to the Azure AS datasource. But when publishing to the Service, it tried to use my local gateway and connect to the original, on-prem SQL server.

 

It's like there was residual connection code that was confusing the report.

 

I was able to get around this bug by exporting it as a .pbit, importing the .pbit, re-saving, and re-publishing.

Status: Accepted
See more ideas labeled with:
3 Comments (3 New)
Comments
v-qiuyu-msft
Community Support
Community Support
‎05-12-2018 01:25 AM

Hi @Anonymous,

 

I have reported this issue internally: CRI 69056491. Will update here once I get any information. 

 

Best Regards,
Qiuyun Yu 

Vicky_Song
Impactful Individual
Impactful Individual
‎05-12-2018 01:26 AM
Status changed to: Accepted
 
v-qiuyu-msft
Community Support
Community Support
‎05-22-2018 12:27 AM

Hi @Anonymous,

 

This is an edge case that isn't a priority at the moment. You can submit an idea on ideas.powerbi.com for us to evaluate in the future. Thanks.

 

Best Regards,
Qiuyun Yu 

Idea Statuses