Forum Discussion

tushartechlab's avatar
tushartechlab
Advocate II
6 years ago

Direct Query With Publish to Web (embedded code link) not working

Hey DataGeeks,   I created a report and published it to Power BI Service on the cloud. It had a few reports working in "direct query" mode and some in "import" mode. It all worked well normally, bu...
Need Help
Show and Tell
Tips and Tricks
venal's avatar
venal
Memorable Member
6 years ago

tushartechlab 

I have few queries to know the details.

 

1. Data Source. (Ex:- Dataset/Oracle/SQL Server..etc.,)

2. Connectivity Mode - Direct Query

3. Gateway version

4. Have you tried to publish the file to the another workspace and check for the option.

 

Note:- If the datasource is "Power BI Dataset" and accessed the same in different report, created a few measures and published the report. In this case we were unable to find the option. To avoid that we need to create the mesaures in Original report and access it in current one.

 

Hope it will help for your issue.

 

If you have any queries, please let us know.

 

If this post helps, then please consider Accept it as the solution to help the other members find it more
If this post was helpful may I ask you to mark it as solution and click on thumb symbol?

 

BR

venal.