Forum Discussion

AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
5 years ago

Paginated Report Error in the Service: data source was found but the credentials were incorrect

I'm having trouble when publishing a .rdl file to the service. It works fine in the Power BI Report Builder desktop app but displays this error when I try to open it in the online workspace (after a ...
Need Help
v-angzheng-msft's avatar
v-angzheng-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi, AlexisOlson 

 

Is it possible that this is because the report comes from multiple data sources? That multiple data sources have multiple different credentials? Or different data sources have different connection mode?

I find some information about connection patterns here.

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-datasets-azure-analysis-services

 

Hope you  can find a solution so that we can learn from it.

Best Regards,
Community Support Team _ Zeon Zheng

 

AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
5 years ago

I don't think it has to do with multiple credentials or connection modes since it works fine locally and also works when the stored procedure is replaced by the text that defines the stored procedure. I think I need to create a minimal working example to isolate exactly the sticking point though.

 

Edit: I tried using the same stored procedure as the source for a Power BI report and got an error when I attempted to refresh the dataset. It looks like the issue is still the execute permission. Gotta bug the DB admins again.

 

Data source error:
{"error":
    {"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":
        {"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":
            [{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},
             {"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,
                "value":"Microsoft SQL: The EXECUTE permission was denied on the object 'pr_FC_SOITemplate_Institutional', database 'CWS', schema 'dbo'."}},
             {"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},
             {"code":"Microsoft.Data.Mashup.ValueError.Class","detail":{"type":1,"value":"14"}},
             {"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"SQL"}},
             {"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"sqlcluster;CWS"}},
             {"code":"Microsoft.Data.Mashup.ValueError.ErrorCode","detail":{"type":1,"value":"-2146232060"}},
             {"code":"Microsoft.Data.Mashup.ValueError.Message","detail":{"type":1,
                "value":"The EXECUTE permission was denied on the object 'pr_FC_SOITemplate_Institutional', database 'CWS', schema 'dbo'."}},
             {"code":"Microsoft.Data.Mashup.ValueError.Number","detail":{"type":1,"value":"229"}},
             {"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],
             "exceptionCulprit":1}}}
Table: Query1.
Cluster URI: WABI-WEST-US-redirect.analysis.windows.net
Activity ID: 797ff6e4-6af8-43bf-ba0b-e1d9805b35e4
Request ID: 22850e85-4cf2-bdcf-adfa-018510ada49f
Time: 2021-07-16 16:15:52Z